File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/SaleRate.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 SaleRate : BasePageClass { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Common.BindControl(SupplierId, Global.Context.Customers.AsEnumerable().ToList(), "EnglishName", "CustomerId", "Select"); Common.BindControl(HamalId, Global.Context.Hamals.AsEnumerable().ToList(), "HamalName", "HamalId", "Select"); Common.BindControl(LocationId, Global.Context.Locations.AsEnumerable().Select(p => new { p.LocationId, p.LocationName }).ToList(), "LocationName", "LocationId", "Select"); if (Request.QueryString["SaleRateId"].ConvertInt() > 0) { int Id = Request.QueryString["SaleRateId"].ConvertInt(); var obj = Global.Context.SaleRates.SingleOrDefault(p => p.SaleRateId == Id); SupplierId.SelectedValue = obj.CustomerId.Value.ToString(); InvoiceNo.Text = obj.InvoiceNo.ToString(); Dates.Text = obj.Date.Value.ToString("dd/MM/yyyy"); TotalAmount.Text = obj.TotalAmount.ToString(); VehicleNo.Text = obj.VehicleNo; try { HamalId.SelectedValue = obj.HamalId.Value.ToString(); } catch { } TotalAmountTotal.Text = obj.TotalQuantity.Value.ToString(); try { LocationId.SelectedValue = obj.LocationId.Value.ToString(); } catch { } try { var Datax = Global.Context.Locations.SingleOrDefault(p => p.LocationId == obj.LocationId); LocationRate.Value = Datax.Rate.Value.ToString("0.00"); FormulaRate.Value = Common.Convertstring(Datax.CalcFormula); } catch { } } else { int compId = SiteSession.CompnayId; InvoiceNo.Text = (Global.Context.SaleRates.Where(p => p.CompnayId == compId).Count() + 1).ToString(); Dates.Text = Common.DateTimeNow().ToString("dd/MM/yyyy"); try { InvoiceNo.Text = (Global.Context.InvNoes.Where(p => p.CompnayId == compId && p.SesssionId == SiteSession.SessionId).Count() + 1).ToString(); } catch { } } InvoiceNo.Enabled = false; } } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string UpdateBilty(string SaleRateId) { int ChallanIds = SaleRateId.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.SaleRateItems.AsEnumerable().Where(p => p.SaleRateId == ChallanIds).ToList().Select(p => new { p.SaleRateItemId, p.ItemId, p.Quantity, p.Rate, p.Amount, p.Weightkg, 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), stockqty = StockDataUpdateTime(p.ItemId.Value, p.BrandId.Value, p.WeightId.Value, p.Weightkg, p.Quantity.Value), Kg = Common.Convertstring(p.Weight.Kg) }).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 Hamalirate(string Id) { try { int IDS = Id.ConvertInt(); return Global.Context.Locations.SingleOrDefault(p => p.LocationId == IDS).Rate.Value.ToString(); } catch { return "0.00"; } } public static decimal StockDataUpdateTime(int Itemid, int BrandId, int WeightId, string WeightKG, decimal qty) { try { return Global.Context.ExecuteStoreQuery<KeyDataHolder>("select dbo.[GetOpeningStockForCheck](" + Itemid + "," + BrandId + "," + WeightId + "," + SiteSession.CompnayId + ",'" + (WeightKG).Replace(" ", "").ToUpper() + "') as KeyData").FirstOrDefault().KeyData + qty; } catch (Exception ex) { return qty; } } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string ListForCombo() { return Global.Context.DropdownOptionItem(SiteSession.CompnayId).FirstOrDefault(); } [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 deleteitem(string SaleRateItemId) { try { int Id = SaleRateItemId.ConvertInt(); var obj = Global.Context.SaleRateItems.SingleOrDefault(p => p.SaleRateItemId == Id); obj.Delete(); return "1<>Suc"; } catch (Exception ex) { return "0<>" + ex.Message; } } [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; } [System.Web.Services.WebMethod()] public static string SaveChallandataSaleRate(string SaleRateId, string TotalAmount, string VehicleNo, string SupplierId, string Dates, string InvoiceNo, string HamalId, string Hamali, string LocationId, string TotalQunatity, string BiltyList) { try { int ID = 0; using (TransactionScope tran = new TransactionScope()) { var ItemList = JsonConvert.DeserializeObject<List<SaleRateItem>>(BiltyList); if (SaleRateId.ConvertInt() > 0) { int PurId = SaleRateId.ConvertInt(); var objData = Global.Context.SaleRates.SingleOrDefault(p => p.SaleRateId == PurId); if (LocationId.ConvertInt() > 0) { objData.LocationId = LocationId.ConvertInt(); } objData.VehicleNo = VehicleNo; objData.TotalAmount = TotalAmount.ConvertDecimal(); objData.CustomerId = SupplierId.ConvertInt(); objData.Date = Common.DateConvertMultimatch(Dates); objData.Hamali = Hamali.ConvertDecimal(); if (HamalId.ConvertInt() > 0) { objData.HamalId = HamalId.ConvertInt(); } else { objData.HamalId = null; } //if (LocationId.ConvertInt() > 0) //{ // objData.LocationId = LocationId.ConvertInt(); //} //else //{ // objData.LocationId = null; //} objData.TotalQuantity = TotalQunatity.ConvertDecimal(); objData.Save(); ID = objData.SaleRateId; ItemList.ForEach(x => { if (x.SaleRateItemId.ConvertInt() > 0) { int PurItemId = x.SaleRateItemId.ConvertInt(); var poItem = Global.Context.SaleRateItems.SingleOrDefault(p => p.SaleRateItemId == PurItemId); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.Rate = LIBS.Common.ConvertDecimal(x.Rate); poItem.Amount = LIBS.Common.ConvertDecimal(x.Amount); poItem.WeightId = x.WeightId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.BrandId = x.BrandId.ConvertInt(); poItem.Save(); } else { var poItem = new Business.SaleRateItem(); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Rate = LIBS.Common.ConvertDecimal(x.Rate); poItem.Amount = LIBS.Common.ConvertDecimal(x.Amount); poItem.WeightId = x.WeightId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.BrandId = x.BrandId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.SaleRateId = objData.SaleRateId; poItem.Save(); } }); } else { var objData = new Business.SaleRate(); objData.InvoiceNo = Global.Context.InsertinvNo(SiteSession.SessionId, SiteSession.CompnayId).FirstOrDefault().Value.ToString(); objData.CustomerId = SupplierId.ConvertInt(); objData.SessionId = SiteSession.SessionId; objData.Date = Common.DateConvertMultimatch(Dates); objData.VehicleNo = VehicleNo; objData.TotalAmount = TotalAmount.ConvertDecimal(); objData.Hamali = Hamali.ConvertDecimal(); objData.TotalQuantity = TotalQunatity.ConvertDecimal(); objData.CompnayId = SiteSession.CompnayId; if (LocationId.ConvertInt() > 0) { objData.LocationId = LocationId.ConvertInt(); } if (HamalId.ConvertInt() > 0) { objData.HamalId = HamalId.ConvertInt(); } else { objData.HamalId = null; } //if (LocationId.ConvertInt() > 0) //{ // objData.LocationId = LocationId.ConvertInt(); //} //else //{ // objData.LocationId = null; //} objData.Save(); ID = objData.SaleRateId; ItemList.ForEach(x => { //string inputData = x.Weightkg; //var data = Regex.Match(inputData, @"\d+").Value; //var WeightKGdata = data + " " + (x.Weightkg.Replace(data, "").Replace(" ", "")).ToUpper(); if (x.SaleRateItemId.ConvertInt() > 0) { int PurItemId = x.SaleRateItemId.ConvertInt(); var poItem = Global.Context.SaleRateItems.SingleOrDefault(p => p.SaleRateItemId == PurItemId); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.Rate = LIBS.Common.ConvertDecimal(x.Rate); poItem.Amount = LIBS.Common.ConvertDecimal(x.Amount); poItem.WeightId = x.WeightId.ConvertInt(); poItem.BrandId = x.BrandId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.Save(); } else { var poItem = new Business.SaleRateItem(); poItem.ItemId = x.ItemId.ConvertInt(); poItem.Quantity = LIBS.Common.ConvertDecimal(x.Quantity); poItem.SaleRateId = objData.SaleRateId; poItem.WeightId = x.WeightId.ConvertInt(); poItem.Rate = LIBS.Common.ConvertDecimal(x.Rate); poItem.Amount = LIBS.Common.ConvertDecimal(x.Amount); poItem.BrandId = x.BrandId.ConvertInt(); poItem.Weightkg = x.Weightkg; poItem.Save(); } }); } tran.Complete(); } return "Id:" + ID.ToString() + "<> 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 SaleRateItem { public string SaleRateItemId { get; set; } public string ItemId { get; set; } public string BrandId { get; set; } public string WeightId { get; set; } public string Rate { get; set; } public string Amount { get; set; } public string Quantity { get; set; } public string Weightkg { get; set; } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings