private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t) { Inv_RChallan c = new Inv_RChallan(); c.BalanceQty = t.BalanceQuanity; c.Barcode = t.BarCode; c.Brand = t.Brand; c.ChallanDate = t.PurchaseDate; c.ChallanNo = t.ChallanNo; c.ChallanTotal = t.ChallanTotal; c.CompanyCode = t.CompanyCode; c.CompanyId = t.CompanyId; c.CompanyName = t.CompanyName; c.CPU = t.CPU; c.DeliveryQty = t.DeliveryQty; c.EditDate = t.EditDate; c.EditUser = t.EditUser; c.FloorName = t.FloorName; c.Id = t.Id; c.PurchaseDate = t.PurchaseDate; c.Ocode = t.OCode; c.ProductGroup = t.ProductGroup; c.ProductId = t.ProductId; c.ProductName = t.ProductName; c.ReceiveQuantity = t.ReceiveQuantity; c.RPU = t.RPU; c.ExpireDate = t.ExpireDate; c.StyleSize = t.StyleSize; c.SupplierCode = t.SupplierCode; c.SupplierReturnQty = t.SupplierReturnQty; c.UnitName = t.UnitName; // if neeeded //c.VailPerPack = t.VailPerPack; //c.TestPerVail = t.TestPerVail; //c.TotalVailQty = t.TotalVailQty; //c.BalanceStatus = t.BalanceStatus; c.Item_Remarks = t.Item_Remarks; c.PO_No = t.PO_No; c.Mode_Of_Delivery = t.Mode_Of_Delivery; c.Unit_Cheked = t.Unit_Cheked; c.Reciept_Condition = t.Reciept_Condition; c.Delivery_Type = t.Delivery_Type; c.Senior_Packer_EID = t.Senior_Packer_EID; c.Move_Coordinator = t.Move_Coordinator; c.Project_Code = t.Project_Code; c.Store_Id = t.Store_Id; c.Store_Unit_Id = t.Store_Unit_Id; return(c); }
internal int Insert(Inv_RChallan_Temp purchase) { try { _context.Inv_RChallan_Temp.AddObject(purchase); _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
private Inv_RChallan ConvertTmpToRchallan(Inv_RChallan_Temp t) { Inv_RChallan c = new Inv_RChallan(); c.BalanceQty = t.BalanceQuanity; c.Barcode = t.BarCode; c.Brand = t.Brand; c.ChallanDate = t.ChallanDate; c.ChallanNo = t.ChallanNo; c.ChallanTotal = t.ChallanTotal; c.CompanyCode = t.CompanyCode; c.CompanyId = t.CompanyId; c.CompanyName = t.CompanyName; c.CPU = t.CPU; c.DeliveryQty = t.DeliveryQty; c.EditDate = t.EditDate; c.EditUser = t.EditUser; c.FloorName = t.FloorName; c.Id = t.Id; c.PurchaseDate = t.PurchaseDate; c.Ocode = t.OCode; c.ProductGroup = t.ProductGroup; c.ProductId = t.ProductId; c.ProductName = t.ProductName; c.ReceiveQuantity = t.ReceiveQuantity; c.Remarks = t.Item_Remarks; c.RPU = t.RPU; c.ExpireDate = t.ExpireDate; c.StyleSize = t.StyleSize; c.FloorName = t.FloorName; c.SupplierCode = t.SupplierCode; c.SupplierId = t.SupplierId; c.SupplierReturnQty = t.SupplierReturnQty; c.UnitName = t.UnitName; c.OrderNo = t.OrderNo; // if neeeded //c.VailPerPack = t.VailPerPack; //c.TestPerVail = t.TestPerVail; //c.TotalVailQty = t.TotalVailQty; //c.BalanceStatus = t.BalanceStatus; return(c); }
internal int UpdateInv_MRRRChallan_Temp(string ChallanNo, int Id, Inv_RChallan_Temp purchase) { try { Inv_RChallan_Temp RchallanObj = _context.Inv_RChallan_Temp.First(x => x.ChallanNo == ChallanNo && x.Id == Id); RchallanObj.ProductGroup = purchase.ProductGroup; RchallanObj.ProductId = purchase.ProductId; RchallanObj.ProductName = purchase.ProductName; RchallanObj.ReceiveQuantity = purchase.ReceiveQuantity; RchallanObj.ActualQty = purchase.ActualQty; RchallanObj.Free_Qty = purchase.Free_Qty; RchallanObj.Actual_Amount = purchase.Actual_Amount; RchallanObj.FreeQty_Amount = purchase.FreeQty_Amount; RchallanObj.UnitName = purchase.UnitName; RchallanObj.Brand = purchase.Brand; RchallanObj.FrmCurrency = purchase.FrmCurrency; RchallanObj.CPU = purchase.CPU; RchallanObj.TotalPrice = purchase.TotalPrice; RchallanObj.ToCurrency = purchase.ToCurrency; RchallanObj.Rate = purchase.Rate; RchallanObj.TotalAppCost = purchase.TotalAppCost; RchallanObj.Store_Code = purchase.Store_Code; RchallanObj.SupplierCode = purchase.SupplierCode; RchallanObj.RefNo_ChallanNo = purchase.RefNo_ChallanNo; RchallanObj.SeasonID = purchase.SeasonID; RchallanObj.OrderEId = purchase.OrderEId; RchallanObj.MasterLCNo = purchase.MasterLCNo; RchallanObj.PI_No = purchase.PI_No; RchallanObj.B2BLCNo = purchase.B2BLCNo; RchallanObj.BarCode = purchase.BarCode; RchallanObj.BalanceQuanity = purchase.BalanceQuanity; RchallanObj.PurchaseDate = purchase.PurchaseDate; _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
internal int Insert(Inv_RChallan_Temp purchase) { return(rChallanDal.Insert(purchase)); }
internal int UpdateInv_MRRRChallan_Temp(string ChallanNo, int Id, Inv_RChallan_Temp purchase) { return(rChallanDal.UpdateInv_MRRRChallan_Temp(ChallanNo, Id, purchase)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (btnSubmit.Text == "Add") { if (txtReceiveQty.Text == string.Empty || txtCPU.Text == string.Empty) { return; } SerialNo = SerialNo + 1; Inv_RChallan_Temp purchase = new Inv_RChallan_Temp(); purchase.Id = SerialNo; //foreach (DataRow dr in stCompany.Rows) //{ // purchase.CompanyId = int.Parse(dr["CompanyId"].ToString()); // purchase.CompanyName = dr["CompanyName"].ToString(); // purchase.CompanyCode = dr["CompanyCode"].ToString(); //} purchase.CompanyCode = ddlStore.SelectedValue.ToString(); purchase.CompanyName = GetCompanyNameByCode(purchase.CompanyCode); purchase.CompanyId = int.Parse(GetCompanyIdByCode(ddlStore.SelectedValue.ToString())); purchase.ChallanNo = txtChallanNo.Text.Trim(); purchase.ChallanDate = DateTime.Parse(txtDate.Text); purchase.ProductId = int.Parse(ddlProductName.SelectedValue.ToString());//Convert.ToInt32(txtProductId.Text.Trim()); //purchase.Barcode = buyCentralBll.GetBarcode(int.Parse(purchase.ProductId.ToString())); purchase.BarCode = txtbarcode.Text; purchase.ProductGroup = int.Parse(ddlProductGroup.SelectedValue.ToString()); string pronductNameandBrand = ddlProductName.SelectedItem.ToString(); string[] values = pronductNameandBrand.Split('-'); purchase.ProductName = values[0].ToString(); purchase.UnitName = txtUnit.Text; purchase.Brand = hdnBrand.Value; purchase.StyleSize = hdnStyle.Value; purchase.FloorName = txtFloorName.Text; //purchase.StyleSize = txtStyleSize.Text; purchase.DamageQty = 0; purchase.DeliveryQty = 0; purchase.SupplierReturnQty = 0; purchase.OrderNo = txtOrderNo.Text; try { purchase.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { purchase.PurchaseDate = DateTime.Today; } purchase.ReceiveQuantity = Convert.ToInt32(txtReceiveQty.Text.Trim()); //if (chkBalanceStatus.Checked) // purchase.BalanceStatus = "OpeningBalance"; //else // purchase.BalanceStatus = "MRR"; decimal CPU = Convert.ToDecimal(txtCPU.Text.Trim()); purchase.CPU = CPU; //if (txtRPU.Text == string.Empty) //{ // purchase.RPU = Convert.ToInt32(float.Parse(txtCPU.Text)); //} //else //{ // purchase.RPU = Convert.ToInt32(float.Parse(txtRPU.Text)); //} purchase.BalanceQuanity = Convert.ToInt32(txtBalanceQty.Text.Trim()) + purchase.ReceiveQuantity; //purchase.SupplierId = 0; // obsolete; no longer used purchase.SupplierCode = ddlSupplier.SelectedValue.ToString(); // identity of the supplier purchase.EditDate = DateTime.Now; purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId; string OCODE = ((SessionUser)Session["SessionUser"]).OCode; purchase.OCode = OCODE; //purchase.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce"); //purchase.Ocode = "8989"; var RChalan = rChallanBll.GetDataByInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, OCODE).ToList(); double ReceiveQty = Convert.ToDouble(txtReceiveQty.Text); if (RChalan.Count > 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already in The List')", true); return; //var update = rChallanBll.UpdateInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, ReceiveQty, CPU); //if (update == 1) //{ // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true); // BindPurchaseGrid(txtChallanNo.Text.Trim()); // ClearProduct(); // return; //} //else //{ //} } rChallanBll.Insert(purchase); BindPurchaseGrid(purchase.ChallanNo); ClearProduct(); //lblMessage.Text = "<font color='green'>Purchase information has been added temporarily. Please post.</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information has been added temporarily. Please post.')", true); } else { if (btnSubmit.Text == "Update") { double ReceiveQty = Convert.ToDouble(txtReceiveQty.Text); decimal CPU = Convert.ToDecimal(txtCPU.Text.Trim()); decimal total = Convert.ToDecimal(txtTotalCost.Text.Trim()); var update = rChallanBll.UpdateInv_RChallan_Temp(txtChallanNo.Text, txtbarcode.Text, ReceiveQty); if (update == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true); BindPurchaseGrid(txtChallanNo.Text.Trim()); ClearProduct(); //lblTotal.Visible = true; btnSubmit.Text = "Add"; return; } else { } } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
//private string GetCompanyCodeById(int Id) //{ // return companyBll.GetCompanyCodeById(Id); //} protected void btnSubmit_Click(object sender, EventArgs e) { try { if (txtReceiveQty.Text == string.Empty || txtCPU.Text == string.Empty) { return; } SerialNo = SerialNo + 1; Inv_RChallan_Temp purchase = new Inv_RChallan_Temp(); purchase.Id = SerialNo; foreach (DataRow dr in stCompany.Rows) { purchase.CompanyId = int.Parse(dr["CompanyId"].ToString()); purchase.CompanyName = dr["CompanyName"].ToString(); purchase.CompanyCode = dr["CompanyCode"].ToString(); } //purchase.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); //purchase.CompanyName = txtCompanyName.Text.Trim(); //purchase.CompanyCode = GetCompanyCodeById(int.Parse(purchase.CompanyId.ToString())); purchase.ChallanNo = txtChallanNo.Text.Trim(); purchase.ChallanDate = DateTime.Parse(txtDate.Text); purchase.ProductId = int.Parse(ddlProductName.SelectedValue.ToString());//Convert.ToInt32(txtProductId.Text.Trim()); //purchase.Barcode = buyCentralBll.GetBarcode(int.Parse(purchase.ProductId.ToString())); purchase.BarCode = purchase.ProductId.ToString(); purchase.ProductGroup = int.Parse(ddlProductGroup.SelectedValue.ToString()); string productNameandBrand = ddlProductName.SelectedItem.ToString(); string[] values = productNameandBrand.Split(' ', '-'); purchase.ProductName = values[0].ToString(); purchase.UnitName = txtUnit.Text; purchase.Brand = hdnBrand.Value; purchase.StyleSize = hdnStyle.Value; purchase.DamageQty = 0; purchase.DeliveryQty = 0; purchase.SupplierReturnQty = 0; purchase.Item_Remarks = txtRemarks.Text; try { purchase.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { purchase.PurchaseDate = DateTime.Today; } purchase.ReceiveQuantity = Convert.ToInt32(txtReceiveQty.Text.Trim()); //if (chkBalanceStatus.Checked) // purchase.BalanceStatus = "OpeningBalance"; //else // purchase.BalanceStatus = "MRR"; purchase.CPU = Convert.ToDecimal(txtCPU.Text.Trim()); //if (txtRPU.Text == string.Empty) //{ // purchase.RPU = Convert.ToInt32(float.Parse(txtCPU.Text)); //} //else //{ // purchase.RPU = Convert.ToInt32(float.Parse(txtRPU.Text)); //} //decimal balanceQty = Convert.ToDecimal(txtBalanceQty.Text); //string[] value = balanceQty.ToString().Split('-'); //decimal result = Convert.ToDecimal(value[0]); //purchase.BalanceQty = Convert.ToDecimal(result) + purchase.ReceiveQuantity; purchase.BalanceQuanity = Convert.ToDouble(txtBalanceQty.Text); purchase.SupplierId = 0; // obsolete; no longer used purchase.SupplierCode = ddlSupplier.SelectedValue.ToString(); // identity of the supplier purchase.EditDate = DateTime.Now; purchase.EditUser = ((SessionUser)Session["SessionUser"]).UserId; purchase.OCode = ((SessionUser)Session["SessionUser"]).OCode; //purchase.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce"); //purchase.Ocode = "8989"; purchase.Item_Remarks = txtItemRemarks.Text; purchase.PO_No = txtPONo.Text; purchase.Mode_Of_Delivery = ddlModeofDelivery.SelectedItem.Text; purchase.Unit_Cheked = ddlUMCheckedCondition.SelectedItem.Text; purchase.Reciept_Condition = ddlRecieptCondition.SelectedItem.Text; purchase.Delivery_Type = ddlDelivery.SelectedItem.Text; purchase.Senior_Packer_EID = ddlSrpacker.SelectedValue; purchase.Move_Coordinator = txtMoveOrdinator.Text; purchase.Project_Code = ddlProject.SelectedValue; purchase.Store_Id = Convert.ToInt16(ddlStoreName.SelectedValue); purchase.Store_Unit_Id = Convert.ToInt16(ddlStoreUnit.SelectedValue); rChallanBll.Insert(purchase); BindPurchaseGrid(purchase.ChallanNo); ClearProduct(); //lblMessage.Text = "<font color='green'>Purchase information has been added temporarily. Please post.</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information has been added temporarily. Please post.')", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }