protected void txtbarcode_TextChanged(object sender, EventArgs e) { try { if (hiddenCompanyType.Value.Trim() == "CENTRAL") { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString()); if (buyCentral != null) { txtBalanceQty.Text = Convert.ToString(buyCentral.BalanceQuanity); } else { txtBalanceQty.Text = "0"; } } else { Inv_Buy invBuy = buyBll.GetBuyByCompanyAndBarcode(txtbarcode.Text, ddlStore.SelectedValue.ToString()); if (invBuy != null) { txtBalanceQty.Text = Convert.ToString(invBuy.BalanceQuanity); } else { txtBalanceQty.Text = "0"; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int Update(int Id, Inv_Buy inv_BuyObj) { try { Inv_Buy buyObj = _context.Inv_Buy.First(x => x.Id == Id); buyObj.ChallanNo = inv_BuyObj.ChallanNo; buyObj.CompanyId = inv_BuyObj.CompanyId; buyObj.CompanyCode = inv_BuyObj.CompanyCode; buyObj.CompanyName = inv_BuyObj.CompanyName; buyObj.BarCode = inv_BuyObj.BarCode; buyObj.ProductId = inv_BuyObj.ProductId; buyObj.ProductGroup = inv_BuyObj.ProductGroup; buyObj.ProductName = inv_BuyObj.ProductName; buyObj.Brand = inv_BuyObj.Brand; buyObj.StyleSize = inv_BuyObj.StyleSize; buyObj.FloorName = inv_BuyObj.FloorName; buyObj.UnitName = inv_BuyObj.UnitName; buyObj.ReceiveQuantity = inv_BuyObj.ReceiveQuantity; buyObj.CPU = inv_BuyObj.CPU; buyObj.RPU = inv_BuyObj.RPU; buyObj.ExpireDate = inv_BuyObj.ExpireDate; buyObj.BalanceQuanity = inv_BuyObj.BalanceQuanity; buyObj.PurchaseDate = inv_BuyObj.PurchaseDate; buyObj.EditDate = inv_BuyObj.EditDate; buyObj.OCode = inv_BuyObj.OCode; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
public Inv_Buy GetBuy_DPT_Return(string Barcode, string StoreCode, string challanNo) { try { Inv_Buy buy = _context.Inv_Buy.Where(bc => bc.BarCode == Barcode && bc.Store_Code == StoreCode && bc.ChallanNo == challanNo).FirstOrDefault <Inv_Buy>(); return(buy); } catch (Exception ex) { throw ex; } }
internal int Insert(Inv_Buy inv_BuyObj) { try { _context.Inv_Buy.AddObject(inv_BuyObj); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int Update_Return_DptWise(int Id, string barcode, string StoreCode, string challanNo, Inv_Buy Inv_BuyObj) { try { Inv_Buy buyCentralObj = _context.Inv_Buy.First(x => x.Id == Id && x.BarCode == barcode && x.ChallanNo == challanNo && x.Store_Code == StoreCode); buyCentralObj.BalanceQuanity = Inv_BuyObj.BalanceQuanity; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
public Inv_Buy GetBuyBarcodeAndComanyCode(string Barcode, string CompanyCode) { using (ERPSSL_INVEntities ctx = new ERPSSL_INVEntities()) { try { Inv_Buy buy = ctx.Inv_Buy.Where(bc => bc.BarCode == Barcode && bc.CompanyCode == CompanyCode).FirstOrDefault <Inv_Buy>(); return(buy); } catch (Exception ex) { throw ex; } } }
internal int Update(Inv_Buy inv_BuyObj, int Id) { return(buyDal.Update(Id, inv_BuyObj)); }
internal int Insert(Inv_Buy inv_BuyObj) { return(buyDal.Insert(inv_BuyObj)); }
public Inv_Buy GetBuyByCompanyCodeAndBarcode(string barcode, string CompanyCode) { Inv_Buy buy = buyDal.GetBuyBarcodeAndComanyCode(barcode, CompanyCode); return(buy); }
internal int Update_Return_DptWise(int Id, string barcode, string StoreCode, string challanNo, Inv_Buy Inv_BuyObj) { return(buyCentralDal.Update_Return_DptWise(Id, barcode, StoreCode, challanNo, Inv_BuyObj)); }
protected void BtnSave_Click(object sender, EventArgs e) { try { string challanNo = txtChalanNo.Text.Trim(); //string CType = hiddenCompanyType.Value; string CType = "CENTRAL"; if (CType == "CENTRAL") { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buyCentral == null) { // Insert New Inv_BuyCentral newBuyCentral = new Inv_BuyCentral(); newBuyCentral.ChallanNo = txtChalanNo.Text; newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); newBuyCentral.CompanyCode = HiddenCompanyCode.Value; newBuyCentral.CompanyName = HiddenCompanyName.Value; newBuyCentral.BarCode = hdnBarCode.Value; newBuyCentral.ProductId = int.Parse(hdnBarCode.Value.ToString()); newBuyCentral.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); newBuyCentral.ProductName = txtProduct.Text; newBuyCentral.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; newBuyCentral.UnitName = txtUnit.Text; newBuyCentral.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { newBuyCentral.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { newBuyCentral.PurchaseDate = DateTime.Today; } newBuyCentral.EditDate = DateTime.Now; newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId; newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyCentralBll.Insert(newBuyCentral); } else { buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buyCentral.CPU = rchallan.CPU; //buyCentral.RPU = rchallan.RPU; //buyCentral.ExpireDate = rchallan.ExpireDate; buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); GenerateReport(); ClearForm(); } else // obsolete // hiddenCompanyType = General { Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buy == null) { // Insert New Inv_Buy invBuy = new Inv_Buy(); invBuy.ChallanNo = txtChalanNo.Text; invBuy.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); invBuy.CompanyCode = HiddenCompanyCode.Value; invBuy.CompanyName = HiddenCompanyName.Value; invBuy.BarCode = hdnBarCode.Value; invBuy.ProductId = int.Parse(hdnBarCode.Value.ToString()); invBuy.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); invBuy.ProductName = txtProduct.Text; invBuy.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; invBuy.UnitName = txtUnit.Text; invBuy.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { invBuy.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { invBuy.PurchaseDate = DateTime.Today; } invBuy.EditDate = DateTime.Now; invBuy.EditUser = ((SessionUser)Session["SessionUser"]).UserId; invBuy.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyBll.Insert(invBuy); } else { buy.BalanceQuanity = buy.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buy.CPU = rchallan.CPU; //buy.RPU = rchallan.RPU; //buy.ExpireDate = rchallan.ExpireDate; buy.ReceiveQuantity = buy.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyBll.Update(buy, Convert.ToInt32(buy.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); } ClearForm(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { List <Inv_RChallan_Temp> staticPurchaseList = new List <Inv_RChallan_Temp>(); string challanNo = txtChallanNo.Text.Trim(); staticPurchaseList = rChallanBll.GetTempRChalan(((SessionUser)Session["SessionUser"]).OCode, challanNo); //staticPurchaseList = rChallanBll.GetTempRChalan("8989", challanNo); if (hiddenCompanyType.Value.Trim() == "CENTRAL") { foreach (Inv_RChallan_Temp rchallan in staticPurchaseList) { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode); if (buyCentral == null) { // Insert New Inv_BuyCentral newBuyCentral = new Inv_BuyCentral(); newBuyCentral.ChallanNo = rchallan.ChallanNo; newBuyCentral.CompanyId = rchallan.CompanyId; newBuyCentral.CompanyCode = rchallan.CompanyCode; newBuyCentral.CompanyName = rchallan.CompanyName; newBuyCentral.BarCode = rchallan.BarCode; newBuyCentral.ProductId = Convert.ToInt32(rchallan.ProductId); newBuyCentral.ProductGroup = rchallan.ProductGroup; newBuyCentral.ProductName = rchallan.ProductName; newBuyCentral.Brand = rchallan.Brand; newBuyCentral.StyleSize = rchallan.StyleSize; newBuyCentral.FloorName = rchallan.FloorName; newBuyCentral.UnitName = rchallan.UnitName; newBuyCentral.ReceiveQuantity = rchallan.ReceiveQuantity; newBuyCentral.CPU = rchallan.CPU; newBuyCentral.RPU = rchallan.RPU; newBuyCentral.ExpireDate = rchallan.ExpireDate; newBuyCentral.BalanceQuanity = rchallan.BalanceQuanity; newBuyCentral.PurchaseDate = rchallan.PurchaseDate; newBuyCentral.EditDate = rchallan.EditDate; newBuyCentral.OCode = rchallan.OCode; newBuyCentral.OrderNo = rchallan.OrderNo; buyCentralBll.Insert(newBuyCentral); } else { buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ReceiveQuantity; buyCentral.CPU = rchallan.CPU; buyCentral.RPU = rchallan.RPU; buyCentral.ExpireDate = rchallan.ExpireDate; buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + rchallan.ReceiveQuantity; //buyCentral.Id = Convert.ToInt16(hidId.Value); buyCentralBll.Update(buyCentral, buyCentral.Id); } rChallanBll.Insert(ConvertTmpToRchallan(rchallan)); rChallanBll.DeleteTempChalanById(rchallan.Id); //string OCODE = ((SessionUser)Session["SessionUser"]).OCode; //string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString(); //string Company_Code = "CMP201506051"; //string ModuleType = "Inventory"; //string VoucherType = "PAYMENT"; //rChallanBll.Enter_VoucherDetails(OCODE, Company_Code,Edit_User, ModuleType, VoucherType, ConvertTmpToRchallan(rchallan)); //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); gvPurchase.DataSource = null; gvPurchase.DataBind(); ddlChalanNo.Items.Clear(); } ClearForm(); } else // hiddenCompanyType = General { foreach (Inv_RChallan_Temp rchallan in staticPurchaseList) { Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(rchallan.BarCode, rchallan.CompanyCode); if (buy == null) { // Insert New Inv_Buy invBuy = new Inv_Buy(); invBuy.ChallanNo = rchallan.ChallanNo; invBuy.CompanyId = rchallan.CompanyId; invBuy.CompanyCode = rchallan.CompanyCode; invBuy.CompanyName = rchallan.CompanyName; invBuy.BarCode = rchallan.BarCode; invBuy.ProductId = Convert.ToInt32(rchallan.ProductId); invBuy.ProductGroup = rchallan.ProductGroup; invBuy.ProductName = rchallan.ProductName; invBuy.Brand = rchallan.Brand; invBuy.StyleSize = rchallan.StyleSize; invBuy.FloorName = rchallan.FloorName; invBuy.UnitName = rchallan.UnitName; invBuy.ReceiveQuantity = rchallan.ReceiveQuantity; invBuy.CPU = rchallan.CPU; invBuy.RPU = rchallan.RPU; invBuy.ExpireDate = rchallan.ExpireDate; invBuy.BalanceQuanity = rchallan.BalanceQuanity; invBuy.PurchaseDate = rchallan.PurchaseDate; invBuy.DeliveryQty = Convert.ToInt32(rchallan.DeliveryQty); invBuy.EditDate = rchallan.EditDate; invBuy.OCode = rchallan.OCode; invBuy.OrderNo = rchallan.OrderNo; buyBll.Insert(invBuy); } else { buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ReceiveQuantity; buy.CPU = rchallan.CPU; buy.RPU = rchallan.RPU; buy.ExpireDate = rchallan.ExpireDate; buy.ReceiveQuantity = buy.ReceiveQuantity + rchallan.ReceiveQuantity; int Id = Convert.ToInt16(hidId.Value); buyBll.Update(buy, Id); } rChallanBll.Insert(ConvertTmpToRchallan(rchallan)); rChallanBll.DeleteTempChalanById(rchallan.Id); // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); ddlChalanNo.Items.Clear(); } ClearForm(); } // End of IF CENTRAL OR GENERAL } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btnConfirm_Click(object sender, EventArgs e) { try { DateTime date = DateTime.Today; GetNewChallanNo(date); string OCODE = ((SessionUser)Session["SessionUser"]).OCode; string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString(); Guid UserId = ((SessionUser)Session["SessionUser"]).UserId; List <Inv_Return_Temp> ReturnList = new List <Inv_Return_Temp>(); string challanNo = txtChalanNoReturn.Text.Trim(); ReturnList = rChallanBll.GetTempReturn(((SessionUser)Session["SessionUser"]).OCode, UserId); foreach (Inv_Return_Temp rchallan in ReturnList) { if (ddlStoreName.SelectedValue == "CNT") { Inv_BuyCentral buyCentral = _BuyCentral.GetBuyForReturn(rchallan.BarCode, rchallan.Store_Code); if (buyCentral != null) { // Kamruzzaman........... Inv_Return _return = new Inv_Return(); _return.ChallanNo = txtChalanNoReturn.Text; _return.ChallanNo_To = rchallan.ChallanNo_To; _return.BarCode = rchallan.BarCode; _return.ProductId = Convert.ToInt32(rchallan.ProductId); _return.ProductGroup = rchallan.ProductGroup; _return.ProductName = rchallan.ProductName; _return.Remarks = rchallan.Remarks; _return.Brand = rchallan.Brand; _return.StyleSize = rchallan.StyleSize; _return.FloorName = rchallan.FloorName; _return.UnitName = rchallan.UnitName; _return.ReceiveQuantity = rchallan.ReceiveQuantity; _return.CPU = rchallan.CPU; _return.RPU = rchallan.RPU; _return.ExpireDate = rchallan.ExpireDate; _return.BalanceQuanity = rchallan.BalanceQuanity; _return.PurchaseDate = rchallan.PurchaseDate; _return.EditDate = rchallan.EditDate; _return.OCode = rchallan.OCode; _return.Store_Code = rchallan.Store_Code; _return.SupplierReturnQty = rchallan.SupplierReturnQty; _return.SupplierCode = rchallan.SupplierCode; _return.CurrentCompanyCode = rchallan.CurrentCompanyCode; _return.PurchaseDate = rchallan.PurchaseDate; _return.EditDate = DateTime.Today; _return.EditUser = rchallan.EditUser; _return.OldCompanyCode = rchallan.OldCompanyCode; _return.ReturnDate = DateTime.Today; _return.ERetQty = rchallan.ERetQty; _return.OldCompanyName = rchallan.OldCompanyName; _return.OldCompanyId = rchallan.OldCompanyId; _return.ReturnType = "StoreToCentral"; _return.EID = rchallan.EID; _return.DPT_CODE = rchallan.DPT_CODE; _return.ProgramId = rchallan.ProgramId; _BuyCentral.InsertReturn(_return); // buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty; buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + rchallan.ERetQty; //buyCentral.Id = Convert.ToInt16(hidId.Value); // _BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy); _BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral); _BuyCentral.DeleteReturn_Temp(rchallan.Id); } else { } } else { Inv_Buy buy = _BuyCentral.GetBuy_DPT_Return(rchallan.BarCode, rchallan.Store_Code, rchallan.ChallanNo_To); if (buy != null) { // Kamruzzaman........... Inv_Return _return = new Inv_Return(); _return.ChallanNo = txtChalanNoReturn.Text; _return.ChallanNo_To = rchallan.ChallanNo_To; _return.BarCode = rchallan.BarCode; _return.ProductId = Convert.ToInt32(rchallan.ProductId); _return.ProductGroup = rchallan.ProductGroup; _return.ProductName = rchallan.ProductName; _return.Brand = rchallan.Brand; _return.StyleSize = rchallan.StyleSize; _return.FloorName = rchallan.FloorName; _return.UnitName = rchallan.UnitName; _return.ReceiveQuantity = rchallan.ReceiveQuantity; _return.CPU = rchallan.CPU; _return.Remarks = rchallan.Remarks; _return.RPU = rchallan.RPU; _return.ExpireDate = rchallan.ExpireDate; _return.BalanceQuanity = rchallan.BalanceQuanity; _return.PurchaseDate = rchallan.PurchaseDate; _return.EditDate = rchallan.EditDate; _return.OCode = rchallan.OCode; _return.Store_Code = rchallan.Store_Code; _return.SupplierReturnQty = rchallan.SupplierReturnQty; _return.SupplierCode = rchallan.SupplierCode; _return.CurrentCompanyCode = rchallan.CurrentCompanyCode; _return.PurchaseDate = rchallan.PurchaseDate; _return.EditDate = DateTime.Today; _return.EditUser = rchallan.EditUser; _return.OldCompanyCode = rchallan.OldCompanyCode; _return.ReturnDate = DateTime.Today; _return.ERetQty = rchallan.ERetQty; _return.OldCompanyName = rchallan.OldCompanyName; _return.OldCompanyId = rchallan.OldCompanyId; _return.ReturnType = "StoreToStore"; _return.EID = rchallan.EID; _return.DPT_CODE = rchallan.DPT_CODE; _return.ProgramId = rchallan.ProgramId; _BuyCentral.InsertReturn(_return); // buy.BalanceQuanity = buy.BalanceQuanity - rchallan.ERetQty; buy.BalanceQuanity = buy.BalanceQuanity + rchallan.ERetQty; //buyCentral.Id = Convert.ToInt16(hidId.Value); _BuyCentral.Update_Return_DptWise(buy.Id, buy.BarCode, buy.Store_Code, buy.ChallanNo, buy); // _BuyCentral.Update_ForReturnBy_CentralToStore(buyCentral.Id, buyCentral.BarCode, buyCentral.Store_Code, buyCentral.ChallanNo, buyCentral); _BuyCentral.DeleteReturn_Temp(rchallan.Id); } else { } } } grdTransfer.DataSource = null; grdTransfer.DataBind(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Returned Successfully')", true); Response.Redirect(Request.RawUrl); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }