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 UpdateBuyCentralByStore(int Id, Inv_BuyCentral inv_BuyCentralObj, string ProjectCode, int StoreID, int StoreUnitID) { try { Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id && x.Project_Code == ProjectCode && x.Store_Id == StoreID && x.Store_Unit_Id == StoreUnitID); buyCentralObj.ChallanNo = inv_BuyCentralObj.ChallanNo; buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate; buyCentralObj.CompanyId = inv_BuyCentralObj.CompanyId; buyCentralObj.CompanyCode = inv_BuyCentralObj.CompanyCode; buyCentralObj.CompanyName = inv_BuyCentralObj.CompanyName; buyCentralObj.BarCode = inv_BuyCentralObj.BarCode; buyCentralObj.ProductId = inv_BuyCentralObj.ProductId; buyCentralObj.ProductGroup = inv_BuyCentralObj.ProductGroup; buyCentralObj.ProductName = inv_BuyCentralObj.ProductName; buyCentralObj.Brand = inv_BuyCentralObj.Brand; buyCentralObj.StyleSize = inv_BuyCentralObj.StyleSize; buyCentralObj.FloorName = inv_BuyCentralObj.FloorName; buyCentralObj.UnitName = inv_BuyCentralObj.UnitName; buyCentralObj.ReceiveQuantity = inv_BuyCentralObj.ReceiveQuantity; buyCentralObj.CPU = inv_BuyCentralObj.CPU; buyCentralObj.RPU = inv_BuyCentralObj.RPU; buyCentralObj.ExpireDate = inv_BuyCentralObj.ExpireDate; buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity; buyCentralObj.EditDate = inv_BuyCentralObj.EditDate; buyCentralObj.OCode = inv_BuyCentralObj.OCode; buyCentralObj.Item_Remarks = inv_BuyCentralObj.Item_Remarks; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal Inv_BuyCentral GetProductQtyformBuyCentral(productsDetails aitem) { string Barcode = aitem.ProductId.ToString(); Inv_BuyCentral buyCentral = _context.Inv_BuyCentral.FirstOrDefault(x => x.BarCode == Barcode); return(buyCentral); }
public Inv_BuyCentral GetBuyCentralByBarcodeAndComanyCode(string Barcode, string CompanyCode) { try { Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.CompanyCode == CompanyCode).FirstOrDefault <Inv_BuyCentral>(); return(buyCentrl); } catch (Exception ex) { throw ex; } }
public Inv_BuyCentral GetBuyForReturn(string Barcode, string StoreCode) { try { Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.Store_Code == StoreCode).FirstOrDefault <Inv_BuyCentral>(); return(buyCentrl); } catch (Exception ex) { throw ex; } }
public Inv_BuyCentral GetBuyCentralByBarcode_Store(string Barcode, int CompanyId, string ProjectCode, int StoreID, int StoreUnitID) { try { Inv_BuyCentral buyCentrl = _context.Inv_BuyCentral.Where(bc => bc.BarCode == Barcode && bc.CompanyId == CompanyId && bc.Project_Code == ProjectCode && bc.Store_Id == StoreID && bc.Store_Unit_Id == StoreUnitID).FirstOrDefault <Inv_BuyCentral>(); return(buyCentrl); } catch (Exception ex) { throw ex; } }
internal int Insert(Inv_BuyCentral inv_BuyCentralObj) { try { _context.Inv_BuyCentral.AddObject(inv_BuyCentralObj); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int Update_buyCentral(int id) { try { Inv_BuyCentral prodObj = _context.Inv_BuyCentral.First(x => x.Id == id); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal Inv_BuyCentral GeBuyCentralListbyId(int fID) { try { Inv_BuyCentral Bi = (from b in _context.Inv_BuyCentral where b.Id == fID select b).FirstOrDefault(); return(Bi); } catch (Exception ex) { throw ex; } }
internal int Update_ForReturnBy_CentralToStore(int Id, string barcode, string StoreCode, string challanNo, Inv_BuyCentral inv_BuyCentralObj) { try { Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id && x.BarCode == barcode && x.ChallanNo == challanNo && x.Store_Code == StoreCode); buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
private void GetProductStatus() { try { string status = ""; string OCODE = ((SessionUser)Session["SessionUser"]).OCode; string EID = ((SessionUser)Session["SessionUser"]).EID; //List<Inv_Product> product1 = _productStatus.GetProductStatus(OCODE); List <productsDetails> product = aProductBLL.GetAllGroupProductByEID(EID, OCODE); foreach (productsDetails aitem in product) { Inv_BuyCentral _buyCentral = _productStatus.GetProductQtyformBuyCentral(aitem); //productsDetails _buyCentral = _productStatus.GetAllStockProductByEID(EID, OCODE); //var _buyCentral = lstproductsDetails.FirstOrDefault(); if (_buyCentral != null) { if (aitem.ReOrderQty == _buyCentral.BalanceQuanity) { status += "<b style='color:Black'><img src='img/tkupdown.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity; } else if (aitem.ReOrderQty > _buyCentral.BalanceQuanity) { status += "<b style='color:Black'><img src='img/tkdown.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity; } else if (aitem.ReOrderQty < _buyCentral.BalanceQuanity) { status += "<b style='color:Black'><img src='img/tkup.gif' /> " + aitem.ProductName + "-" + _buyCentral.BalanceQuanity; } } } lblitem.Text = status; } catch (Exception ex) { throw ex; } }
protected void ImgUnitEdit_Click(object sender, EventArgs e) { lblMessage.Text = ""; ImageButton imgbtn = (ImageButton)sender; GridViewRow row = (GridViewRow)imgbtn.NamingContainer; ShowDiv.Visible = true; try { Label lblBuyCentralId = (Label)grdUnit.Rows[row.RowIndex].FindControl("lblId"); int fID = Convert.ToInt16(lblBuyCentralId.Text); Inv_BuyCentral _BuyCID = _buyCentralbll.GeBuyCentralListbyId(fID); if (_BuyCID != null) { HidBuyCentralID.Value = _BuyCID.Id.ToString(); GetAllStore(); ddlStore.SelectedValue = _BuyCID.Store_Code; FillSupplier(); ddlSupplier.SelectedValue = _BuyCID.SupplierCode; txtRefNo.Text = _BuyCID.RefNo_ChallanNo; txtDate.Text = _BuyCID.PurchaseDate.ToString(); txtPINo.Text = _BuyCID.PI_No; txtMRRNo.Text = _BuyCID.ChallanNo; txtMasterLCNo.Text = _BuyCID.MasterLCNo; txtB2BLCNo.Text = _BuyCID.B2BLCNo; txtReceiverEID.Text = _BuyCID.ReceiverEID; LoadOrderNumber(); ddlOrder.SelectedValue = _BuyCID.OrderEId.ToString(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int Update(int Id, Inv_BuyCentral inv_BuyCentralObj) { try { Inv_BuyCentral buyCentralObj = _context.Inv_BuyCentral.First(x => x.Id == Id); buyCentralObj.ChallanNo = inv_BuyCentralObj.ChallanNo; buyCentralObj.CompanyId = inv_BuyCentralObj.CompanyId; buyCentralObj.CompanyCode = inv_BuyCentralObj.CompanyCode; buyCentralObj.CompanyName = inv_BuyCentralObj.CompanyName; buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate; buyCentralObj.BarCode = inv_BuyCentralObj.BarCode; buyCentralObj.ProductId = inv_BuyCentralObj.ProductId; buyCentralObj.ProductGroup = inv_BuyCentralObj.ProductGroup; buyCentralObj.ProductName = inv_BuyCentralObj.ProductName; buyCentralObj.Brand = inv_BuyCentralObj.Brand; buyCentralObj.StyleSize = inv_BuyCentralObj.StyleSize; buyCentralObj.FloorName = inv_BuyCentralObj.FloorName; buyCentralObj.UnitName = inv_BuyCentralObj.UnitName; buyCentralObj.ReceiveQuantity = inv_BuyCentralObj.ReceiveQuantity; buyCentralObj.ActualQty = inv_BuyCentralObj.ActualQty; buyCentralObj.Free_Qty = inv_BuyCentralObj.Free_Qty; buyCentralObj.CPU = inv_BuyCentralObj.CPU; buyCentralObj.PI_No = inv_BuyCentralObj.PI_No; buyCentralObj.RPU = inv_BuyCentralObj.RPU; buyCentralObj.ExpireDate = inv_BuyCentralObj.ExpireDate; buyCentralObj.BalanceQuanity = inv_BuyCentralObj.BalanceQuanity; buyCentralObj.PurchaseDate = inv_BuyCentralObj.PurchaseDate; buyCentralObj.EditDate = inv_BuyCentralObj.EditDate; buyCentralObj.OCode = inv_BuyCentralObj.OCode; buyCentralObj.Item_Remarks = inv_BuyCentralObj.Item_Remarks; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int UpdateBuyCentral(Inv_BuyCentral purchase, int pId) { try { Inv_BuyCentral prodObj = _context.Inv_BuyCentral.First(x => x.Id == pId); prodObj.Store_Id = purchase.Store_Id; prodObj.SupplierCode = purchase.SupplierCode; prodObj.RefNo_ChallanNo = purchase.RefNo_ChallanNo; //prodObj.SeasonID = purchase.SeasonID; prodObj.OrderEId = purchase.OrderEId; prodObj.PurchaseDate = purchase.PurchaseDate; prodObj.ChallanNo = purchase.ChallanNo; prodObj.MasterLCNo = purchase.MasterLCNo; prodObj.B2BLCNo = purchase.B2BLCNo; prodObj.PI_No = purchase.PI_No; _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { Inv_BuyCentral purchase = new Inv_BuyCentral(); //purchase.Store_Id = Convert.ToInt32(ddlStore.SelectedValue.ToString()); purchase.SupplierCode = ddlSupplier.SelectedItem.Text; purchase.RefNo_ChallanNo = txtRefNo.Text; //purchase.SeasonID = Convert.ToInt32(ddlSeason.SelectedValue.ToString()); purchase.OrderEId = Convert.ToInt32(ddlOrder.SelectedValue.ToString()); purchase.Store_Code = ddlStore.SelectedValue; purchase.PurchaseDate = DateTime.Parse(txtDate.Text); purchase.ChallanNo = txtMRRNo.Text.Trim(); purchase.MasterLCNo = txtMasterLCNo.Text; purchase.B2BLCNo = txtB2BLCNo.Text; purchase.PI_No = txtPINo.Text; purchase.EditDate = DateTime.Now; purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId; int pId = Convert.ToInt16(HidBuyCentralID.Value); int result = rChallanBll.UpdateBuyCentral(purchase, pId); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } ShowDiv.Visible = false; } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int UpdateBuyCentralByStore(Inv_BuyCentral inv_BuyCentralObj, int Id, string ProjectCode, int StoreID, int StoreUnitID) { return(buyCentralDal.UpdateBuyCentralByStore(Id, inv_BuyCentralObj, ProjectCode, StoreID, StoreUnitID)); }
internal int Update(Inv_BuyCentral inv_BuyCentralObj, int Id) { return(buyCentralDal.Update(Id, inv_BuyCentralObj)); }
internal int Insert(Inv_BuyCentral inv_BuyCentralObj) { return(buyCentralDal.Insert(inv_BuyCentralObj)); }
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 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 btnConfirm_Click(object sender, EventArgs e) { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString(); List <Inv_Damage_Temp> damageList = new List <Inv_Damage_Temp>(); string challanNo = txtChalanNo.Text.Trim(); damageList = rChallanBll.GetTempDanmage(((SessionUser)Session["SessionUser"]).OCode, challanNo); foreach (Inv_Damage_Temp rchallan in damageList) { Inv_BuyCentral buycentral = _BuyCentral.GetBuyForReturn(rchallan.BarCode, rchallan.Store_Code); if (buycentral != null) { // Kamruzzaman........... Inv_Damage _damage = new Inv_Damage(); _damage.ChallanNo = txtChalanNo.Text; _damage.Challan_No_To = rchallan.Challan_No_To; _damage.BarCode = rchallan.BarCode; _damage.ProductId = Convert.ToInt32(rchallan.ProductId); _damage.ProductGroup = rchallan.ProductGroup; _damage.ProductName = rchallan.ProductName; _damage.Brand = rchallan.Brand; _damage.StyleSize = rchallan.StyleSize; _damage.FloorName = rchallan.FloorName; _damage.UnitName = rchallan.UnitName; _damage.ReceiveQuantity = rchallan.ReceiveQuantity; _damage.CPU = rchallan.CPU; _damage.RPU = rchallan.RPU; _damage.ExpireDate = rchallan.ExpireDate; _damage.BalanceQuanity = rchallan.BalanceQuanity; _damage.PurchaseDate = rchallan.PurchaseDate; _damage.EditDate = rchallan.EditDate; _damage.OCode = rchallan.OCode; _damage.Store_Code = rchallan.Store_Code; _damage.SupplierReturnQty = rchallan.SupplierReturnQty; _damage.CompanyCode = rchallan.CompanyCode; _damage.PurchaseDate = rchallan.PurchaseDate; _damage.EditDate = DateTime.Today; _damage.EditUser = rchallan.EditUser; _damage.DamageDate = DateTime.Today; _damage.CompanyName = rchallan.CompanyName; _damage.CompanyId = rchallan.CompanyId; _damage.DamageQty = rchallan.DamageQty; _damage.DamageCategory = rchallan.DamageCategory; _damage.Remarks = rchallan.Remarks; _BuyCentral.InsertDamage(_damage); buycentral.BalanceQuanity = buycentral.BalanceQuanity - rchallan.DamageQty; buycentral.SupplierReturnQty = buycentral.DamageQty + rchallan.DamageQty; //buyCentral.Id = Convert.ToInt16(hidId.Value); _BuyCentral.Update_ForReturn(buycentral.Id, buycentral.BarCode, buycentral.Store_Code, buycentral.ChallanNo, buycentral); _BuyCentral.DeleteDamage_Temp(rchallan.Id); } else { } } grdDamage.DataSource = null; grdDamage.DataBind(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Product damage information inserted successfully!')", true); Response.Redirect(Request.RawUrl); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
public Inv_BuyCentral GetBuyCentralByBarcodeAndStoreCode(string barcode, string StoreCode) { Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcodeAndStoreCode(barcode, StoreCode); return(buyCentral); }
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); } }
public Inv_BuyCentral GetBuyCentralByBarcode_Store(string barcode, int CompanyId, string ProjectCode, int StoreID, int StoreUnitID) { Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcode_Store(barcode, CompanyId, ProjectCode, StoreID, StoreUnitID); return(buyCentral); }
public Inv_BuyCentral GetBuyCentralByCompanyCodeAndBarcode(string barcode, string CompanyCode) { Inv_BuyCentral buyCentral = buyCentralDal.GetBuyCentralByBarcodeAndComanyCode(barcode, CompanyCode); return(buyCentral); }
internal int UpdateBuyCentral(Inv_BuyCentral purchase, int pId) { return(rChallanDal.UpdateBuyCentral(purchase, pId)); }
internal int Update_ForReturn(int Id, string barcode, string StoreCode, string challanNo, Inv_BuyCentral inv_BuyCentralObj) { return(buyCentralDal.Update_ForReturn(Id, barcode, StoreCode, challanNo, inv_BuyCentralObj)); }
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 (gvPurchase.Rows.Count == 0) { //lblMessage.Text = "<font color='red'>Item list is empty!</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item list is empty!')", true); return; } //if (hiddenCompanyType.Value == "CENTRAL") //{ foreach (Inv_RChallan_Temp rchallan in staticPurchaseList) { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByBarcode_Store(rchallan.BarCode, Convert.ToInt32(rchallan.CompanyId), rchallan.Project_Code, Convert.ToInt32(rchallan.Store_Id), Convert.ToInt32(rchallan.Store_Unit_Id)); 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.Item_Remarks = rchallan.Item_Remarks; newBuyCentral.Project_Code = rchallan.Project_Code; newBuyCentral.Store_Id = rchallan.Store_Id; newBuyCentral.Store_Unit_Id = rchallan.Store_Unit_Id; 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.UpdateBuyCentralByStore(buyCentral, Convert.ToInt32(buyCentral.Id), buyCentral.Project_Code, Convert.ToInt32(buyCentral.Store_Id), Convert.ToInt32(buyCentral.Store_Unit_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); 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, Convert.ToInt32(rchallan.CompanyId)); // 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.BalanceQty; // invBuy.PurchaseDate = rchallan.PurchaseDate; // invBuy.DeliveryQty = Convert.ToInt32(rchallan.DeliveryQty); // invBuy.EditDate = rchallan.EditDate; // invBuy.OCode = rchallan.Ocode; // 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>"; // ddlChalanNo.Items.Clear(); // } // ClearForm(); //}// End of IF CENTRAL OR GENERAL } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }