private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; TLADM_CustomerFile CommissionCust; TLKNI_YarnTransaction yarnT; TLKNI_YarnTransactionDetails yarnTD; //TLKNI_YarnStatus yarnStat; TLADM_TranactionType TranType = null; TLKNI_YarnOrderPallets PalletStore; int LastNumberUsed = 0; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandSelected, false, MandatoryFields); if (!String.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } if (dataGridView1.RowCount == 0) { MessageBox.Show("Please enter a least one row in the datagrid"); return; } CommissionCust = (TLADM_CustomerFile)cmbCommissionCustomers.SelectedItem; using (var context = new TTI2Entities()) { //------------------------- // Yarn Header Record //---------------------------------------- yarnT = new TLKNI_YarnTransaction(); yarnT.KnitY_TransactionDate = dtpDateReceived.Value; yarnT.KnitY_Customer_FK = CommissionCust.Cust_Pk; yarnT.KnitY_Notes = rtbComments.Text; yarnT.KnitY_TransactionDoc = txtCustomerDoc.Text; yarnT.KnitY_ThirdParty = false; yarnT.KnitY_RTS = false; var LastNumber = context.TLADM_LastNumberUsed.Find(2); if (LastNumber != null) { LastNumberUsed = LastNumber.col1; yarnT.KnitY_GRNNumber = LastNumberUsed; LastNumber.col1 += 1; } var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault(); if (Dept != null) { TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 100).FirstOrDefault(); } try { context.TLKNI_YarnTransaction.Add(yarnT); context.SaveChanges(); foreach (DataGridViewRow dr in dataGridView1.Rows) { if (dr.Cells[1].Value == null) { continue; } var PalletNo = (int)dr.Cells[0].Value; PalletStore = new TLKNI_YarnOrderPallets(); PalletStore.TLKNIOP_CommisionCust = true; PalletStore.TLKNIOP_Cones = (int)dr.Cells[7].Value; PalletStore.TLKNIOP_DatePacked = dtpDateReceived.Value; PalletStore.TLKNIOP_Grade = string.Empty; PalletStore.TLKNIOP_GrossWeight = (decimal)dr.Cells[5].Value; PalletStore.TLKNIOP_TareWeight = 0.00M; PalletStore.TLKNIOP_NettWeight = (decimal)dr.Cells[6].Value; PalletStore.TLKNIOP_YarnType_FK = (int)dr.Cells[1].Value; PalletStore.TLKNIOP_PalletNo = PalletNo; PalletStore.TLKNIOP_Store_FK = (int)TranType.TrxT_ToWhse_FK; PalletStore.TLKNIOP_NettWeightReserved = 0.00M; PalletStore.TLKNIOP_HeaderRecord_FK = yarnT.KnitY_Pk; PalletStore.TLKNIOP_ConesReserved = 0; context.TLKNI_YarnOrderPallets.Add(PalletStore); context.SaveChanges(); yarnTD = new TLKNI_YarnTransactionDetails(); yarnTD.KnitYD_KnitY_FK = yarnT.KnitY_Pk; yarnTD.KnitYD_YarnType_FK = (int)dr.Cells[1].Value; yarnTD.KnitYD_PalletNo_FK = PalletStore.TLKNIOP_Pk; yarnTD.KnitYD_GrossWeight = (decimal)dr.Cells[5].Value; yarnTD.KnitYD_NettWeight = (decimal)dr.Cells[6].Value; yarnTD.KnitYD_NoOfCones = (int)dr.Cells[7].Value; yarnTD.KnitYD_TransactionDate = dtpDateReceived.Value; yarnTD.KnitYD_RTS = false; yarnTD.KnitYD_TransactionNumber = LastNumberUsed; if (TranType != null) { yarnTD.KnitYD_TransactionType = TranType.TrxT_Pk; } yarnTD.KnitYD_RTS = false; context.TLKNI_YarnTransactionDetails.Add(yarnTD); } context.SaveChanges(); dataGridView1.Rows.Clear(); MessageBox.Show("Records stored successfully to database"); frmKnitViewRep vRep = new frmKnitViewRep(1, yarnT.KnitY_Pk); vRep.ShowDialog(this); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void btnSave_Click(object sender, EventArgs e) { TLSPN_YarnOrder YO = null; TLKNI_YarnTransaction YO3rdP = null; Button oBtn = sender as Button; if (oBtn != null && FormLoaded) { var KO = (TLKNI_Order)cmboKnitOrders.SelectedItem; using (var context = new TTI2Entities()) { if (rbOwnYarn.Checked) { YO = (TLSPN_YarnOrder)cmboYarnOrders.SelectedItem; } else { YO3rdP = (TLKNI_YarnTransaction)cmboYarnOrders.SelectedItem; } foreach (DataGridViewRow Row in dataGridView1.Rows) { if ((bool)Row.Cells[1].Value == false) { continue; } bool lSplit = false; TLKNI_YarnOrderPallets yarnStat = new TLKNI_YarnOrderPallets(); var _Key = (int)Row.Cells[0].Value; yarnStat = context.TLKNI_YarnOrderPallets.Find(_Key); if ((decimal)Row.Cells[4].Value > (decimal)Row.Cells[6].Value) { // We now need to start recording as and when a pallet is across orders //--------------------------------------------------------------------- DialogResult res = MessageBox.Show("Please confirm split transaction", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.Yes) { TLKNI_YarnOrderPallets YarnSplit = new TLKNI_YarnOrderPallets(); YarnSplit.TLKNIOP_CommisionCust = yarnStat.TLKNIOP_CommisionCust; YarnSplit.TLKNIOP_Cones = yarnStat.TLKNIOP_Cones; YarnSplit.TLKNIOP_DatePacked = yarnStat.TLKNIOP_DatePacked; YarnSplit.TLKNIOP_Grade = yarnStat.TLKNIOP_Grade; YarnSplit.TLKNIOP_GrossWeight = yarnStat.TLKNIOP_GrossWeight; YarnSplit.TLKNIOP_HeaderRecord_FK = yarnStat.TLKNIOP_HeaderRecord_FK; YarnSplit.TLKNIOP_NettWeight = yarnStat.TLKNIOP_NettWeight; YarnSplit.TLKNIOP_SplitPallet = true; YarnSplit.TLKNIOP_ReservedBy = KO.KnitO_Pk; YarnSplit.TLKNIOP_ReservedDate = dtpTransactionDate.Value; YarnSplit.TLKNIOP_OrderConfirmed = yarnStat.TLKNIOP_OrderConfirmed; YarnSplit.TLKNIOP_OwnYarn = yarnStat.TLKNIOP_OwnYarn; YarnSplit.TLKNIOP_PalletNo = yarnStat.TLKNIOP_PalletNo; YarnSplit.TLKNIOP_Store_FK = yarnStat.TLKNIOP_Store_FK; YarnSplit.TLKNIOP_TareWeight = yarnStat.TLKNIOP_TareWeight; YarnSplit.TLKNIOP_YarnOrder_FK = yarnStat.TLKNIOP_YarnOrder_FK; YarnSplit.TLKNIOP_YarnType_FK = yarnStat.TLKNIOP_YarnType_FK; YarnSplit.TLKNIOP_NettWeight = (decimal)Row.Cells[6].Value; YarnSplit.TLKNIOP_ConesReserved = (int)Row.Cells[5].Value; YarnSplit.TLKNIOP_NettWeightReserved = (decimal)Row.Cells[6].Value; YarnSplit.TLKNIOP_Cones = (int)Row.Cells[5].Value; context.TLKNI_YarnOrderPallets.Add(YarnSplit); lSplit = true; } else { return; } } yarnStat.TLKNIOP_ConesReserved += (int)Row.Cells[5].Value; yarnStat.TLKNIOP_NettWeightReserved += (decimal)Row.Cells[6].Value; if (!lSplit) { yarnStat.TLKNIOP_ReservedBy = KO.KnitO_Pk; yarnStat.TLKNIOP_ReservedDate = dtpTransactionDate.Value; } } // Note for the file //----------------------------------- // The Yarn Order Number is either TTL own Yarn or that received // from a Third Party //---------------------------------------------------------------- var KnitOrder = context.TLKNI_Order.Find(KO.KnitO_Pk); if (KnitOrder != null) { KnitOrder.KnitO_YarnAssigned = true; if (rbOwnYarn.Checked) { KnitOrder.KnitO_YarnO_FK = YO.YarnO_Pk; } else { KnitOrder.KnitO_YarnO_FK = YO3rdP.KnitY_Pk; } } try { context.SaveChanges(); MessageBox.Show("Data saved to the database successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } dataGridView1.Rows.Clear(); FormLoaded = false; cmboKnitOrders.SelectedItem = -1; cmboYarnOrders.SelectedItem = -1; FormLoaded = true; btnSave.Enabled = false; } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; int RecCount = 0; int LastNumberUsed = 0; TLADM_Suppliers CommissionCust; TLKNI_YarnTransaction yarnT; TLKNI_YarnTransactionDetails yarnTD; TLADM_TranactionType TranType = null; TLKNI_YarnOrderPallets PalletStore; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandFieldsSelected, false, MandatoryFields); if (!String.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } if (dataGridView1.RowCount == 0) { MessageBox.Show("Please enter a least one row in the datagrid"); return; } foreach (DataGridViewRow dr in dataGridView1.Rows) { var tst = fieldEntered.Find(x => x.rownumber == dr.Index); if (tst.fieldComplete == null) { continue; } var cnt = tst.fieldComplete.Where(x => x == false).Count(); if (cnt == MandatoryRows.Length) { continue; } cnt = tst.fieldComplete.Where(x => x == true).Count(); if (cnt != MandatoryRows.Length) { MessageBox.Show("Line " + (1 + dr.Index).ToString() + " Has not been completed correctly"); return; } } CommissionCust = (TLADM_Suppliers)cmbCommissionCustomers.SelectedItem; using (var context = new TTI2Entities()) { yarnT = new TLKNI_YarnTransaction(); yarnT.KnitY_TransactionDate = dtpDateReceived.Value; yarnT.KnitY_Customer_FK = CommissionCust.Sup_Pk; yarnT.KnitY_Notes = rtbComments.Text; yarnT.KnitY_TransactionDoc = txtCustomerDoc.Text; yarnT.KnitY_ThirdParty = true; var LastNumber = context.TLADM_LastNumberUsed.Find(2); if (LastNumber != null) { LastNumberUsed = LastNumber.col2; yarnT.KnitY_GRNNumber = LastNumberUsed; LastNumber.col2 += 1; } var YarnLastNumber = context.TLADM_LastNumberUsed.Find(1); var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault(); if (Dept != null) { TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 200).FirstOrDefault(); } try { context.TLKNI_YarnTransaction.Add(yarnT); context.SaveChanges(); StringBuilder sb = null; int Counter = 0; foreach (DataGridViewRow dr in dataGridView1.Rows) { var tst = fieldEntered.Find(x => x.rownumber == dr.Index); if (tst.fieldComplete == null) { continue; } var cnt = tst.fieldComplete.Where(x => x == false).Count(); if (cnt == MandatoryRows.Count()) { continue; } var PalletNo = (int)dr.Cells[0].Value; PalletStore = new TLKNI_YarnOrderPallets(); PalletStore.TLKNIOP_CommisionCust = false; sb = new StringBuilder(); sb.Append(YarnLastNumber.col6.ToString()); sb.Append(" - "); sb.Append((++Counter).ToString()); PalletStore.TLKNIOP_TLPalletNo = sb.ToString(); PalletStore.TLKNIOP_Cones = (int)dr.Cells[7].Value; PalletStore.TLKNIOP_DatePacked = dtpDateReceived.Value; PalletStore.TLKNIOP_Grade = string.Empty; PalletStore.TLKNIOP_GrossWeight = (decimal)dr.Cells[5].Value; PalletStore.TLKNIOP_TareWeight = 0.00M; PalletStore.TLKNIOP_NettWeight = (decimal)dr.Cells[6].Value; PalletStore.TLKNIOP_YarnType_FK = (int)dr.Cells[1].Value; PalletStore.TLKNIOP_PalletNo = PalletNo; PalletStore.TLKNIOP_Store_FK = (int)TranType.TrxT_ToWhse_FK; PalletStore.TLKNIOP_NettWeightReserved = 0.00M; PalletStore.TLKNIOP_HeaderRecord_FK = yarnT.KnitY_Pk; PalletStore.TLKNIOP_ConesReserved = 0; context.TLKNI_YarnOrderPallets.Add(PalletStore); context.SaveChanges(); yarnTD = new TLKNI_YarnTransactionDetails(); yarnTD.KnitYD_KnitY_FK = yarnT.KnitY_Pk; yarnTD.KnitYD_YarnType_FK = (int)dr.Cells[1].Value; yarnTD.KnitYD_PalletNo_FK = PalletStore.TLKNIOP_Pk; yarnTD.KnitYD_GrossWeight = (decimal)dr.Cells[5].Value; yarnTD.KnitYD_NettWeight = (decimal)dr.Cells[6].Value; yarnTD.KnitYD_NoOfCones = (int)dr.Cells[7].Value; yarnTD.KnitYD_TransactionDate = dtpDateReceived.Value; yarnTD.KnitYD_RTS = false; yarnTD.KnitYD_TransactionNumber = LastNumberUsed; if (TranType != null) { yarnTD.KnitYD_TransactionType = TranType.TrxT_Pk; } yarnTD.KnitYD_RTS = false; context.TLKNI_YarnTransactionDetails.Add(yarnTD); RecCount += 1; } YarnLastNumber = context.TLADM_LastNumberUsed.Find(1); if (YarnLastNumber != null) { YarnLastNumber.col6 += 1; } context.SaveChanges(); formloaded = false; dataGridView1.Rows.Clear(); formloaded = true; MessageBox.Show("Records stored successfully to database"); frmKnitViewRep vRep = new frmKnitViewRep(3, yarnT.KnitY_Pk); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); SetUp(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }