File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/Purchase.aspx.cs
Back
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Services; using System.Web.Script.Services; using Newtonsoft.Json; using Business; using WebApp.LIBS; using Newtonsoft.Json.Linq; using System.Transactions; using System.Text.RegularExpressions; namespace WebApp.admin { public partial class Purchase : BasePageClass { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Common.BindControl(SupplierId, Global.Context.Suppliers.AsEnumerable().ToList(), "SupplierName", "SupplierId", "Select"); if (Request.QueryString["PurchaseId"].ConvertInt() > 0) { int Id = Request.QueryString["PurchaseId"].ConvertInt(); var obj = Global.Context.Purchases.SingleOrDefault(p => p.PurchaseId == Id); SupplierId.SelectedValue= obj.SupplierId.Value.ToString(); InvoiceNo.Text = obj.InvoiceNo.ToString(); Dates.Text = obj.Date.Value.ToString("dd/MM/yyyy"); } } } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string UpdateBilty(string PurchaseId) { int ChallanIds = PurchaseId.ConvertInt(); int ComId = SiteSession.CompnayId; var obj = Global.Context.Items.AsEnumerable().Where(p=> p.CompnayId== ComId).ToList(); var objBrand = Global.Context.Brands.AsEnumerable().Where(p => p.CompnayId == ComId).ToList(); var Weight = Global.Context.Weights.AsEnumerable().Where(p => p.CompnayId == ComId).ToList(); return JsonConvert.SerializeObject(Global.Context.PurchaseItems.AsEnumerable().Where(p => p.PurchaseId == ChallanIds).ToList().Select(p => new { p.PurchaseItemId, p.ItemId, p.BrandId, p.Weightkg, p.WeightId, p.Quantity, Item = StationListUpdate(obj, p.ItemId.Value), Brand = BrandListUpdate(objBrand, p.ItemId.Value, p.BrandId.Value), Weight = WeightListUpdate(Weight, p.ItemId.Value, p.BrandId.Value,p.WeightId.Value), }).ToList()); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string ListBrand(string ItemId) { int ChallanIds = ItemId.ConvertInt(); int ComId = SiteSession.CompnayId; var obj = Global.Context.Brands.AsEnumerable().Where(p => p.ItemId == ChallanIds).ToList(); return JsonConvert.SerializeObject(obj.ToList().Select(p => new { p.BrandId, p.BrandName, }).ToList()); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string ListWeight(string BrandId, string ItemId) { int ChallanIds = ItemId.ConvertInt(); int BrandIds = BrandId.ConvertInt(); var obj = Global.Context.Weights.AsEnumerable().Where(p => p.ItemId == ChallanIds && p.BrandId==BrandIds).ToList(); return JsonConvert.SerializeObject(obj.ToList().Select(p => new { p.WeightId, p.WeightName, }).ToList()); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string ListWeightSale(string BrandId, string ItemId) { int ChallanIds = ItemId.ConvertInt(); int BrandIds = BrandId.ConvertInt(); var obj = Global.Context.ExecuteStoreQuery<WeightNmes>("select WeightId,WeightName+('['+convert(nvarchar(100),(dbo.GetOpeningStockForCheck(ItemId,BrandId,WeightId,CompnayId)))+']') as WeightName from [Weight] where ItemId=" + ChallanIds + " and BrandId=" + BrandIds + " and CompnayId=" + SiteSession.CompnayId + "").ToList(); try { return JsonConvert.SerializeObject(obj.ToList().Select(p => new { p.WeightId, p.WeightName, }).ToList().OrderByDescending(x=> Convert.ToInt32(Regex.Match(x.WeightName, @"\d+").Value))); } catch { return JsonConvert.SerializeObject(obj.ToList().Select(p => new { p.WeightId, p.WeightName, }).ToList()); } } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string StationListUpdate(List<Item> obj, int Id) { string returnstr = "<option value='0'>Select </option>"; obj.ForEach(x => { returnstr = returnstr + " " + ("<option value='" + x.ItemId + "' " + (Id == x.ItemId ? "selected" : "") + ">" + x.ItemName + "</option>"); }); return returnstr; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string BrandListUpdate(List<Brand> obj, int ItemId, int BrandId) { string returnstr = "<option value='0'>Select </option>"; obj.Where(p=> p.ItemId== ItemId).ToList().ForEach(x => { returnstr = returnstr + " " + ("<option value='" + x.BrandId + "' " + (BrandId == x.BrandId ? "selected" : "") + ">" + x.BrandName + "</option>"); }); return returnstr; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string WeightListUpdate(List<Weight> obj, int ItemId, int BrandId,int WeightId) { string returnstr = "<option value='0'>Select </option>"; obj.Where(p => p.ItemId == ItemId && p.BrandId==BrandId).ToList().ForEach(x => { returnstr = returnstr + " " + ("<option value='" + x.WeightId + "' " + (WeightId == x.WeightId ? "selected" : "") + ">" + x.WeightName + "</option>"); }); return returnstr; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string ListForCombo() { return Global.Context.DropdownOptionItem(SiteSession.CompnayId).FirstOrDefault(); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string deleteitem(string PurchaseItemId) { try { int Id = PurchaseItemId.ConvertInt(); var obj = Global.Context.PurchaseItems.SingleOrDefault(p => p.PurchaseItemId == Id); obj.Delete(); return "1<>Suc"; } catch (Exception ex) { return "0<>"+ex.Message; } } [System.Web.Services.WebMethod()] public static string SaveChallandata(string PurchaseId,string TotalAmountTotal, string SupplierId, string Dates, string InvoiceNo, string BiltyList) { try { int ID = 0; using (TransactionScope tran = new TransactionScope()) { var ItemList = JsonConvert.DeserializeObject<List<PurchaseItem>>(BiltyList); if (PurchaseId.ConvertInt() > 0) { int PurId = PurchaseId.ConvertInt(); var objData = Global.Context.Purchases.SingleOrDefault(p => p.PurchaseId == PurId); objData.InvoiceNo = InvoiceNo; objData.Date = Common.DateConvertMultimatch(Dates); objData.TotalQuantity = TotalAmountTotal.ConvertDecimal(); objData.Save(); ItemList.ForEach(x => { //string inputData = x.Weightkg; //var data = Regex.Match(inputData, @"\d+").Value; //var WeightKGdata = data + " " + (x.Weightkg.Replace(data, "").Replace(" ", "")); if (x.PurchaseItemId.ConvertInt() > 0) { int PurItemId = x.PurchaseItemId.ConvertInt(); var poItem = Global.Context.PurchaseItems.SingleOrDefault(p => p.PurchaseItemId == PurItemId); poItem.ItemId = x.ItemId.ConvertInt(); poItem.WeightId = x.WeightId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.BrandId = x.BrandId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.Save(); } else { var poItem = new Business.PurchaseItem(); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.PurchaseId = objData.PurchaseId; poItem.WeightId = x.WeightId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.BrandId = x.BrandId.ConvertInt(); poItem.Save(); } }); } else { var supplierdata = Global.Context.Suppliers.AsEnumerable().FirstOrDefault(); var objData = new Business.Purchase(); objData.InvoiceNo = InvoiceNo; objData.SupplierId = supplierdata.SupplierId; objData.Date = Common.DateConvertMultimatch(Dates); objData.CompnayId = SiteSession.CompnayId; objData.TotalQuantity = TotalAmountTotal.ConvertDecimal(); objData.SessionId = SiteSession.SessionId; objData.Save(); ItemList.ForEach(x => { //string inputData = x.Weightkg; //var data = Regex.Match(inputData, @"\d+").Value; //var WeightKGdata = data + " " + (x.Weightkg.Replace(data, "").Replace(" ", "")); if (x.PurchaseItemId.ConvertInt() > 0) { int PurItemId = x.PurchaseItemId.ConvertInt(); var poItem = Global.Context.PurchaseItems.SingleOrDefault(p => p.PurchaseItemId == PurItemId); poItem.WeightId = x.WeightId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.BrandId = x.BrandId.ConvertInt(); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.Save(); } else { var poItem = new Business.PurchaseItem(); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.PurchaseId = objData.PurchaseId; poItem.Weightkg = x.Weightkg; poItem.WeightId = x.WeightId.ConvertInt(); poItem.BrandId = x.BrandId.ConvertInt(); poItem.Save(); } }); } tran.Complete(); } return "Id:125<> data has been successfully save"; } catch (Exception ex) { String Messages = (ex.InnerException != null ? ex.InnerException.Message : ex.Message); if (Messages.Contains("UNIQUE KEY")) { Messages = "Record already exists. Please enter another."; } return "Error<>" + Messages; } } } } public partial class PurchaseItem { public string PurchaseItemId { get; set; } public string ItemId { get; set; } public string BrandId { get; set; } public string WeightId { get; set; } public string Quantity { get; set; } public string Weightkg { get; set; } } public partial class WeightNmes { public int WeightId { get; set; } public string WeightName { get; set; } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.07 |
proxy
|
phpinfo
|
Settings