private void button2_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null) { using (var context = new TTI2Entities()) { foreach (DataGridViewRow rw in dataGridView1.Rows) { if (!(bool)rw.Cells[1].Value) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)rw.Cells[0].Value); if (bales != null) { if ((bool)rw.Cells[1].EditedFormattedValue) { bales.CoBales_CottonSequence = Convert.ToInt32(txtIssueToProdNo.Text); bales.CoBales_BlowRoomPosition = (int)rw.Cells[2].Value; } else { bales.CoBales_CottonSequence = 0; bales.CoBales_BlowRoomPosition = 0; } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } //----------------------------------------------------------------------- //Now we need to print the report //------------------------------------------------------------------- frmViewReport vRep = new frmViewReport(1); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool success = true; if (oBtn != null) { using (var context = new TTI2Entities()) { foreach (DataGridViewRow dr in dataGridView1.Rows) { if ((int)dr.Cells[1].Value == 0) { continue; } TLSPN_CottonReceivedBales bales = new TLSPN_CottonReceivedBales(); //--------------------------------------------------------------------------- bales.CotBales_BaleNo = (int)dr.Cells[1].Value; bales.CotBales_Mic = (decimal)dr.Cells[2].Value; bales.CotBales_Weight_Nett = (decimal)dr.Cells[3].Value; bales.CotBales_Staple = (decimal)dr.Cells[4].Value; bales.CotBales_LotNo = _CTrns.cotrx_LotNo; bales.CotBales_Weight_Gross = (decimal)dr.Cells[5].Value; bales.CoBales_CottonSequence = _CTrns.cotrx_Return_No; //------------------------------------------------------------------------------ context.TLSPN_CottonReceivedBales.Add(bales); } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } if (success) { MessageBox.Show("Rocords stored to database successfully"); this.Close(); } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool success = true; if (oBtn != null) { using (var context = new TTI2Entities()) { foreach (DataGridViewRow rw in dataGridView1.Rows) { if ((bool)rw.Cells[1].Value == false) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)rw.Cells[0].Value); if (bales != null) { bales.CotBales_ConfirmedByQA = true; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } } } if (success) { dataGridView1.Rows.Clear(); MessageBox.Show("Records stored successfully to database"); } } }
private void btnImport_Click(object sender, EventArgs e) { Button oBtn = sender as Button; int RowCount = 0; if (oBtn != null) { // Create an instance of the open file dialog box. OpenFileDialog openFileDialog1 = new OpenFileDialog(); // Set filter options and filter index. openFileDialog1.Filter = "Text Files (.txt)|*.txt|All Files (*.*)|*.*"; openFileDialog1.FilterIndex = 1; openFileDialog1.Multiselect = false; // Call the ShowDialog method to show the dialog box. DialogResult res = openFileDialog1.ShowDialog(this); // Process input if the user clicked OK. if (res == DialogResult.OK) { // Open the selected file to read. try { System.IO.Stream fileStream = openFileDialog1.OpenFile(); using (System.IO.StreamReader reader = new System.IO.StreamReader(fileStream)) { using (var context = new TTI2Entities()) { // Read the first line from the file and write it the textbox. string[] input = reader.ReadToEnd().Split('\r'); foreach (var line in input) { string[] row = line.Split(','); if (row[0].Contains("Bale")) { continue; } TLSPN_CottonReceivedBales BalesRec = new TLSPN_CottonReceivedBales(); //------------------------------------------------------------------------------------- int Bale = Convert.ToInt32(row[0]); decimal Micro = Math.Round(Convert.ToDecimal(row[1]), 1); decimal Staple = Math.Round(Convert.ToDecimal(row[3]), 1); //----------------------------------------------------------------------------- BalesRec.CotBales_BaleNo = Bale; BalesRec.CotBales_CotReceived_FK = _CTrns.cotrx_pk; BalesRec.CotBales_LotNo = _CTrns.cotrx_LotNo; BalesRec.CoBales_CottonSequence = _CTrns.cotrx_Return_No; BalesRec.CotBales_Mic = Micro; BalesRec.CotBales_Staple = Staple; BalesRec.CotBales_Weight_Nett = _CTrns.cottrx_NettAveBaleWeight; BalesRec.CotBales_Weight_Gross = _CTrns.cotrx_GrossAveBaleWeight; var index = dataGridView1.Rows.Add(); dataGridView1.Rows[index].Cells[1].Value = Bale; //Bale No dataGridView1.Rows[index].Cells[2].Value = Micro; // MIC Decimal dataGridView1.Rows[index].Cells[3].Value = _CTrns.cottrx_NettAveBaleWeight; // Kgs (NETT)decimal dataGridView1.Rows[index].Cells[4].Value = Staple; // staple decimal dataGridView1.Rows[index].Cells[5].Value = _CTrns.cotrx_GrossAveBaleWeight; // kgs (GROSS) decimal RowCount += 1; } dataGridView1.Refresh(); } } fileStream.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } if (RowCount != _CTrns.cotrx_NoBales) { MessageBox.Show("The number of records read in does not correspond to the number entered" + Environment.NewLine + "Please investigate" + Environment.NewLine + "Number of Rows read in " + RowCount.ToString()); btnSave.Enabled = false; } } } }
private void btnSave_Click(object sender, EventArgs e) { TLSPN_CottonReceivedBales bales; Button oBtn = sender as Button; if (oBtn != null & formloaded) { if (RowsSelected != null && rbWriteOff.Checked) { var cnt = RowsSelected.Where(x => x == false).Count(); if (cnt == RowsSelected.Count()) { MessageBox.Show("Please select at least one row from the grid as shown"); return; } } var errorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM); return; } var LotDetails = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; //dont forget last number used //------------------------------------------- using (var context = new TTI2Entities()) { var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col3 += 1; } // 0 // 1 Selected // 2 Bales Numeric // 3 MIC Decimal // 4 kgs (NETT) Decimal // 5 Staple Decimal // 6 kgs (GROSS) decimal int NoBales = 0; decimal NettMass = 0M; decimal GrossMass = 0M; var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false) { continue; } NoBales += 1; NettMass += (decimal)row.Cells[4].Value; GrossMass += (decimal)row.Cells[6].Value; if (rbWriteOn.Checked) { TLSPN_CottonReceivedBales Bales = new TLSPN_CottonReceivedBales(); Bales.CotBales_BaleNo = (int)row.Cells[2].Value; Bales.CotBales_Mic = (decimal)row.Cells[3].Value; Bales.CotBales_Staple = (decimal)row.Cells[5].Value; Bales.CotBales_Weight_Nett = (decimal)row.Cells[4].Value; Bales.CotBales_LotNo = LotDetails.cotrx_LotNo; Bales.CotBales_Weight_Gross = (decimal)row.Cells[6].Value; Bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text); context.TLSPN_CottonReceivedBales.Add(Bales); } else { bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { if ((bool)row.Cells[1].Value == true) { bales.CoBales_CottonReturned = true; bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text); try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } //---------------------------------------------------------------------------- // //------------------------------------------------------------------------------ TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); cotTrans.cotrx_TransDate = dateTimePicker1.Value; cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk; cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue); cotTrans.cotrx_NetWeight = NettMass; cotTrans.cotrx_GrossWeight = GrossMass; cotTrans.cotrx_NoBales = NoBales; //cotTrans.cotrx_VehReg_FK = null; cotTrans.cotrx_WeighBridgeFull = 0; cotTrans.cotrx_WeighBridgeEmpty = 0; cotTrans.cotrx_NettPerWB = 0; cotTrans.cotrx_Return_No = Convert.ToInt32(txtAdjustmentNumber.Text); cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK; cotTrans.cotrx_Notes = rtbNotes.Text; //------------------------------------------------------------------------- // Consult Table TLADM_TranTypes //---------------------------------------------------------------------------- var DepDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); if (DepDetail != null) { var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 400 && x.TrxT_Department_FK == DepDetail.Dep_Id).FirstOrDefault(); if (Trantype != null) { cotTrans.cotrx_TranType = Trantype.TrxT_Pk; } } if (rbWriteOff.Checked) { cotTrans.cotrx_WriteOff = true; } else { cotTrans.cotrx_WriteOff = false; } //------------------------------------------------------------------------ context.TLSPN_CottonTransactions.Add(cotTrans); //----------------------------------------------------------- // //------------------------------------------------------------ string Mach_IP = Dns.GetHostEntry(Dns.GetHostName()) .AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork) .ToString(); TLADM_DailyLog DailyLog = new TLADM_DailyLog(); DailyLog.TLDL_IPAddress = Mach_IP; DailyLog.TLDL_Dept_Fk = DepDetail.Dep_Id; DailyLog.TLDL_Date = DateTime.Now; DailyLog.TLDL_TransDetail = "Cotton Adjustment"; DailyLog.TLDL_AuthorisedBy = txtAdjustmentNumber.Text; DailyLog.TLDL_Comments = txtAdjustmentNumber.Text; context.TLADM_DailyLog.Add(DailyLog); try { context.SaveChanges(); var Retno = Convert.ToInt32(txtAdjustmentNumber.Text); frmViewReport vRep = new frmViewReport(4, Retno); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); SetUp(); MessageBox.Show("Data saved to database successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool success = true; if (oBtn != null) { var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; using (var context = new TTI2Entities()) { //Hard Coded at the moment // See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department //-------------------------------------------------------------------------------------------------- var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 500 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault(); var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col5 += 1; } var NoBales = 0; var GrossWeight = 0M; var NettWeight = 0M; foreach (DataGridViewRow rw in dataGridView1.Rows) { if (rw.Cells[1].Value == null || (bool)rw.Cells[1].Value == false) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)rw.Cells[0].Value); if (bales != null) { bales.CoBales_IssuedToProd = true; bales.CoBales_BlowRoomPosition = 0; bales.CoBales_CottonSequence = Convert.ToInt32(txtIssueToProdNo.Text); NoBales += 1; NettWeight += (decimal)rw.Cells[5].Value; GrossWeight += (decimal)rw.Cells[7].Value; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } } //------------------------------------------------------------------ TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); cotTrans.cotrx_TransDate = dtpTransDate.Value; cotTrans.cotrx_Supplier_FK = CottonRec.cotrx_Supplier_FK; cotTrans.cotrx_Return_No = Convert.ToInt32(txtIssueToProdNo.Text); cotTrans.cotrx_ContractNo_Fk = CottonRec.cotrx_ContractNo_Fk; cotTrans.cotrx_LotNo = CottonRec.cotrx_LotNo; cotTrans.cotrx_NoBales = NoBales; cotTrans.cotrx_GrossWeight = GrossWeight; cotTrans.cotrx_NetWeight = NettWeight; cotTrans.cotrx_WeighBridgeFull = 0M; cotTrans.cotrx_WeighBridgeEmpty = 0M; cotTrans.cotrx_NettPerWB = 0M; cotTrans.cotrx_GrossAveBaleWeight = (GrossWeight / NoBales); cotTrans.cottrx_NettAveBaleWeight = (NettWeight / NoBales); cotTrans.cotrx_TranType = TranType.TrxT_Pk; cotTrans.cotrx_WriteOff = true; //--------------------------------------------- // Need to store this to the laydown file //----------------------------------------------------------- TLSPN_YarnOrderLayDown ld = new TLSPN_YarnOrderLayDown(); ld.YarnLD_BaleAvgWeight = cotTrans.cottrx_NettAveBaleWeight; ld.YarnLD_Date = dtpTransDate.Value; ld.YarnLD_LayDownNo = Convert.ToInt32(txtIssueToProdNo.Text); ld.YarnLD_LotNo = CottonRec.cotrx_LotNo; ld.YarnLD_NoOfBales = NoBales; ld.YarnLD_WeightKg = NettWeight; try { context.TLSPN_CottonTransactions.Add(cotTrans); context.TLSPN_YarnOrderLayDown.Add(ld); context.SaveChanges(); SetUp(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } if (success) { MessageBox.Show("Records stored successfully to database"); } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { var errorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM); return; } var cnt = RowsSelected.Where(x => x == false).Count(); if (cnt == RowsSelected.Count()) { MessageBox.Show("Please select at least one row from the grid as shown"); return; } var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem; var CustomerDetails = (TLADM_CustomerFile)cmbCustomerName.SelectedItem; //Dont forget last number used //---------------------------------------------- using (var context = new TTI2Entities()) { //Hard Coded at the moment // See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department //-------------------------------------------------------------------------------------------------- var SequenceNo = Convert.ToInt32(txtDeliveryNo.Text); var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col4 += 1; } // 0 // 1 Selected // 2 Bales Numeric // 3 MIC Decimal // 4 kgs Decimal // 5 Staple Decimal int NoBales = 0; decimal Mass = 0.00M; decimal Gross = 0.00M; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { bales.CoBales_CottonSold = true; bales.CoBales_CottonSequence = SequenceNo; NoBales += 1; Mass += (decimal)row.Cells[4].Value; Gross += (decimal)row.Cells[6].Value; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); var haul = (TLADM_CottonHauliers)comboTransporter.SelectedItem; cotTrans.cotrx_TransDate = dtpDateDelivered.Value; cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk; cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue); cotTrans.cotrx_NetWeight = Mass; cotTrans.cotrx_GrossWeight = Mass; cotTrans.cotrx_NoBales = NoBales; cotTrans.cotrx_Haulier_FK = haul.Haul_Pk; cotTrans.cotrx_VehReg = txtVehReg.Text; cotTrans.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeFull.Text); cotTrans.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeEmpty.Text); cotTrans.cotrx_NettPerWB = cotTrans.cotrx_WeighBridgeFull - cotTrans.cotrx_WeighBridgeEmpty; cotTrans.cottrx_NettAveBaleWeight = Mass / NoBales; cotTrans.cotrx_GrossAveBaleWeight = Gross / NoBales; cotTrans.cotrx_Return_No = SequenceNo; cotTrans.cotrx_Customer_FK = CustomerDetails.Cust_Pk; cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK; cotTrans.cotrx_Notes = txtCustOrderNo.Text; cotTrans.cotrx_WriteOff = true; //------------------------------------------------------------------------- // Consult Table TLADM_TranTypes //---------------------------------------------------------------------------- var DeptDetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 300 && x.TrxT_Department_FK == DeptDetails.Dep_Id).FirstOrDefault(); if (Trantype != null) { cotTrans.cotrx_TranType = Trantype.TrxT_Pk; } try { if (!_EditMode) { context.TLSPN_CottonTransactions.Add(cotTrans); } context.SaveChanges(); Setup(); frmViewReport vRep = new frmViewReport(5, SequenceNo); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); MessageBox.Show("Data saved to database successfully"); btnPickList.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } } btnSave.Enabled = false; } }
private void btnSave_Click(object sender, EventArgs e) { bool success = true; Button oBtn = sender as Button; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } using (var context = new TTI2Entities()) { TLSPN_CottonReceived cotrec = new TLSPN_CottonReceived(); var Contract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem; var Supplier = (TLADM_Cotton)cmbCottonSuppliers.SelectedItem; var Haulier = (TLADM_CottonHauliers)cmbHaulier.SelectedItem; var NoOfBales = Convert.ToInt32(txtNoOfBales.Text); //--------------------------------------------------------------------------------------------------- //Unfortunately hard coded at the moment //-------------------------------------------------------------------------------------------------- var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 100 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault(); if (TranType != null) { cotrec.CotReC_TranType_FK = TranType.TrxT_Pk; var CountTrx = context.TLSPN_CottonTransactions.Count(); if (CountTrx == 0) { //-------------------------------------------- //this means that this transaction is being run for the first time ie add a record of zeros to the Opening Balance table // This table will cater for future yearend //-------------------------------------------------------------------------------- TLSPN_OpenBalance openBal = new TLSPN_OpenBalance(); openBal.OpenBal_Store_FK = (int)TranType.TrxT_FromWhse_FK; openBal.OpenBal_GrossBaleWeight = 0M; openBal.OpenBal_NettBaleWeight = 0M; openBal.OpenBal_NoOfBales = 0; context.TLSPN_OpenBalance.Add(openBal); } } //---------------------------------------------------------------- // Now onto the main transaction //------------------------------------------------------------------- TLSPN_CottonTransactions CTS = new TLSPN_CottonTransactions(); CTS.cotrx_ContractNo_Fk = Contract.CottonCon_Pk; CTS.cotrx_Customer_FK = null; CTS.cotrx_GrossWeight = Convert.ToDecimal(txtSuppplierGrossWeight.Text); CTS.cotrx_LotNo = Convert.ToInt32(txtLotNo.Text); CTS.cotrx_NettPerWB = Convert.ToDecimal(txtCottonNettWeight.Text); CTS.cotrx_NetWeight = Convert.ToDecimal(txtSupplierNettWeight.Text); CTS.cotrx_NoBales = NoOfBales; CTS.cotrx_Notes = string.Empty; CTS.cotrx_Return_No = Convert.ToInt32(txtGrnNumber.Text); CTS.cotrx_Supplier_FK = Supplier.Cotton_Pk; CTS.cotrx_TransDate = dtpDateReceived.Value; CTS.cotrx_TranType = TranType.TrxT_Pk; CTS.cotrx_VehReg = txtVehReg.Text; CTS.cotrx_Haulier_FK = Haulier.Haul_Pk; CTS.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeNett.Text); CTS.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeGross.Text); CTS.cotrx_WriteOff = false; CTS.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNetAvgBaleWeight.Text); CTS.cotrx_GrossAveBaleWeight = Convert.ToDecimal(txtGrossAvgBaleWeight.Text); context.TLSPN_CottonTransactions.Add(CTS); //-------------------------------------------------------------------------------- var lastNumber = context.TLADM_LastNumberUsed.Find(1); if (lastNumber != null) { lastNumber.col1 += 1; lastNumber.col12 += 1; } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (microAvailNo.Checked) { decimal micraFrom = 0.00M; decimal micraTo = 0.00M; decimal micraAvg = 0.00M; decimal staplefrom = 0.00M; decimal stapleto = 0.00M; decimal stapleAvg = 0.00M; var CottonContract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem; if (CottonContract != null) { micraFrom = CottonContract.CottonCon_MicraFrom; micraTo = CottonContract.CottonCon_MicraTo; staplefrom = CottonContract.CottonCon_StapleFrom; stapleto = CottonContract.CottonCon_StapleTo; if (micraFrom > 0 && micraTo > 0) { micraAvg = (micraFrom + micraTo) / 2; } else { micraAvg = 1; } if (staplefrom != 0 && stapleto != 0) { stapleAvg = (staplefrom + stapleto) / 2; } else { stapleAvg = 1; } } var n = 0; while (++n <= CTS.cotrx_NoBales) { TLSPN_CottonReceivedBales recBales = new TLSPN_CottonReceivedBales(); recBales.CotBales_BaleNo = n; recBales.CotBales_CotReceived_FK = cotrec.CotRec_Pk; recBales.CotBales_LotNo = Convert.ToInt32(txtLotNo.Text); recBales.CotBales_Mic = micraAvg; recBales.CotBales_Staple = stapleAvg; recBales.CotBales_Weight_Gross = Convert.ToDecimal(txtGrossAvgBaleWeight.Text); recBales.CotBales_Weight_Nett = Convert.ToDecimal(txtNetAvgBaleWeight.Text); recBales.CoBales_CottonSequence = Convert.ToInt32(txtGrnNumber.Text); context.TLSPN_CottonReceivedBales.Add(recBales); try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } if (success) { MessageBox.Show("Data stored to the database successfully"); int returnno = Convert.ToInt32(txtGrnNumber.Text); frmViewReport vRep = new frmViewReport(2, returnno); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); MandSelected = core.PopulateArray(MandatoryFields.Length, false); Setup(); } } }