internal int InsertBackToBack(List <LC_BackToBack_Temp> _LC_BackToBack) { using (var _Context = new ERPSSL_LCEntities()) { foreach (LC_BackToBack_Temp aitem in _LC_BackToBack) { LC_BackToBack_Temp planning = new LC_BackToBack_Temp(); planning.POOrderNo = aitem.POOrderNo; planning.Barcode = aitem.Barcode; planning.ProductId = aitem.ProductId; planning.ProductName = aitem.ProductName; planning.StyleSize = aitem.StyleSize; planning.Season = aitem.Season; planning.Brand = aitem.Brand; planning.OCode = aitem.OCode; planning.CreateUser = aitem.CreateUser; planning.CPU = aitem.CPU; planning.ReqQty = aitem.ReqQty; planning.BBLCAutoId = aitem.BBLCAutoId; planning.Style = aitem.Style; planning.MasterLC = aitem.MasterLC; planning.PI = aitem.PI; planning.Unit = aitem.Unit; planning.PIDate = aitem.PIDate; planning.B2BLCNo = aitem.B2BLCNo; planning.ExpireDate = aitem.ExpireDate; planning.BBLCDate = aitem.BBLCDate; planning.ProductGroupId = aitem.ProductGroupId; planning.BDTRate = aitem.BDTRate; planning.BDTValue = aitem.BDTValue; planning.USDRate = aitem.USDRate; planning.USDValue = aitem.USDValue; planning.BayerType = aitem.BayerType; planning.SightDaysInterest = aitem.SightDaysInterest; planning.BBLCShipmentDate = aitem.BBLCShipmentDate; planning.SupplierId = aitem.SupplierId; planning.Article = aitem.Article; _Context.LC_BackToBack_Temp.AddObject(planning); _Context.SaveChanges(); } return(1); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { LC_BackToBack LcBack = new LC_BackToBack(); List <LC_BackToBack_Temp> _LC_BackToBack = new List <LC_BackToBack_Temp>(); if (txtPIDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input PI Date !')", true); return; } if (txtBBLCDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input BBLC Date !')", true); return; } foreach (GridViewRow gvRow in grvOrderSheetEntry.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); LC_BackToBack_Temp _orderPlanning = new LC_BackToBack_Temp(); if (rowChkBox.Checked == true) { Label lblProductId = ((Label)gvRow.FindControl("lblProductId")); Label lblCpu = ((Label)gvRow.FindControl("lblCpu")); Label lblBalanceQty = ((Label)gvRow.FindControl("lblBalanceQty")); Label lblProductName = ((Label)gvRow.FindControl("lblProductName")); Label lblUnitName = ((Label)gvRow.FindControl("lblUnitName")); Label lblStyleSize = ((Label)gvRow.FindControl("lblStyleSize")); Label lblBrand = ((Label)gvRow.FindControl("lblBrand")); TextBox txtQty = ((TextBox)gvRow.FindControl("txtQty")); TextBox txtUSDRate = ((TextBox)gvRow.FindControl("txtUSDRate")); // TextBox txtBDTRate = ((TextBox)gvRow.FindControl("txtBDTRate")); Label lblValue = ((Label)gvRow.FindControl("lblValue")); // Label lblBDTValue = ((Label)gvRow.FindControl("lblBDTValue")); if (txtUSDRate.Text == "") { _orderPlanning.USDRate = 0; } else { _orderPlanning.USDRate = Convert.ToDecimal(txtUSDRate.Text.ToString()); _orderPlanning.USDValue = Convert.ToDecimal(lblValue.Text.ToString()); } //if (txtBDTRate.Text == "") //{ // _orderPlanning.BDTRate = 0; // _orderPlanning.BDTValue = 0; //} //else //{ // _orderPlanning.BDTRate = Convert.ToDecimal(txtBDTRate.Text.ToString()); // _orderPlanning.BDTValue = Convert.ToDecimal(lblBDTValue.Text.ToString()); //} if (txtQty.Text == "") { _orderPlanning.ReqQty = 0; } else { _orderPlanning.ReqQty = Convert.ToDouble(txtQty.Text.ToString()); } if (lblCpu.Text == "") { _orderPlanning.CPU = 0; } else { _orderPlanning.CPU = Convert.ToDecimal(lblCpu.Text.ToString()); } if (rdbForeign.Checked == true) { _orderPlanning.BayerType = rdbForeign.Text; } else { _orderPlanning.BayerType = rdbLocal.Text; } _orderPlanning.BBLCDate = Convert.ToDateTime(txtBBLCDate.Text); _orderPlanning.ExpireDate = Convert.ToDateTime(txtExpireDate.Text); _orderPlanning.BBLCAutoId = txtAutoChallanId.Text; _orderPlanning.BBLCShipmentDate = Convert.ToDateTime(txtBBLCDate.Text); _orderPlanning.SightDaysInterest = txtSigntDayInterest.Text; _orderPlanning.ProductId = Convert.ToInt32(lblProductId.Text.ToString()); _orderPlanning.Barcode = lblProductId.Text.ToString(); _orderPlanning.ProductName = lblProductName.Text.ToString(); _orderPlanning.Brand = lblBrand.Text.ToString(); _orderPlanning.StyleSize = lblStyleSize.Text.ToString(); _orderPlanning.Unit = lblUnitName.Text.ToString(); _orderPlanning.OCode = ((SessionUser)Session["SessionUser"]).OCode; _orderPlanning.EditDate = DateTime.Now; _orderPlanning.CreateUser = ((SessionUser)Session["SessionUser"]).UserId; _orderPlanning.Season = ddlSeason.SelectedItem.Text; _orderPlanning.POOrderNo = ddlPoOrder.SelectedItem.Text; _orderPlanning.Style = ddlStyle.SelectedItem.Text; _orderPlanning.Article = ddlArticle.SelectedItem.Text; _orderPlanning.MasterLC = txtMasterLC.Text; _orderPlanning.B2BLCNo = txtB2BLCNo.Text; _orderPlanning.PI = txtPI.Text; _orderPlanning.PIDate = Convert.ToDateTime(txtPIDate.Text); _orderPlanning.ProductGroupId = Convert.ToInt32(drpItemCategory.SelectedValue); _orderPlanning.SupplierId = ddlSupplier.SelectedValue.ToString(); _LC_BackToBack.Add(_orderPlanning); } } if (_LC_BackToBack.Count > 0) { int result = _orderSheetbll.InsertBackToBack(_LC_BackToBack); if (result == 1) { Clear(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); GridBackTobBackLoad(); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true); } } catch (Exception ex) { throw; } }