private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool Add = false; TLCUT_CutSheetReceipt CSR = null; if (oBtn != null) { if (dataGridView1.Rows.Count < Convert.ToInt32(txtBundles.Text)) { MessageBox.Show("Please complete the form correctly"); return; } var selected = (TLCUT_CutSheet)cmboCutSheet.SelectedItem; if (selected != null) { var Machine = (TLADM_MachineDefinitions)cmboMachines.SelectedItem; if (Machine == null) { MessageBox.Show("Please select a machine on which this cutsheet was cut"); return; } using (var context = new TTI2Entities()) { var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CUT")).FirstOrDefault(); var CS = context.TLCUT_CutSheet.Find(selected.TLCutSH_Pk); if (CS != null) { CS.TLCutSH_WIPComplete = true; CS.TLCUTSH_AddNotes = string.Empty; } CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == selected.TLCutSH_Pk).FirstOrDefault(); if (CSR == null) { Add = true; CSR = new TLCUT_CutSheetReceipt(); } CSR.TLCUTSHR_Style_FK = selected.TLCutSH_Styles_FK; CSR.TLCUTSHR_CutSheet_FK = selected.TLCutSH_Pk; CSR.TLCUTSHR_Date = dtpTransDate.Value; CSR.TLCUTSHR_NoOfBundles = Convert.ToInt32(txtBundles.Text); CSR.TLCUTSHR_Machine_FK = Machine.MD_Pk; CSR.TLCUTSHR_InBundleStore = true; if (CSR.TLCUTSHR_InBundleStore) { var CutStore = context.TLADM_WhseStore.Where(x => x.WhStore_DepartmentFK == CS.TLCutSH_Department_FK && x.WhStore_BundleStore).FirstOrDefault(); if (CutStore != null) { CSR.TLCUTSHR_WhseBunStore_FK = CutStore.WhStore_Id; CSR.TLCUTSHR_DateIntoBunStore = dtpTransDate.Value; } } if (Add) { context.TLCUT_CutSheetReceipt.Add(CSR); } try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException en) { foreach (var eve in en.EntityValidationErrors) { MessageBox.Show("following validation errors: Type" + eve.Entry.Entity.GetType().Name.ToString() + "State " + eve.Entry.State.ToString()); foreach (var ve in eve.ValidationErrors) { MessageBox.Show("- Property" + ve.PropertyName + " Message " + ve.ErrorMessage); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[2].Value == null) { continue; } TLCUT_CutSheetReceiptDetail CSRD = new TLCUT_CutSheetReceiptDetail(); Add = true; if ((int)row.Cells[0].Value != 0) { var index = (int)row.Cells[0].Value; CSRD = context.TLCUT_CutSheetReceiptDetail.Find(index); if (CSRD != null) { Add = false; } else { CSRD = new TLCUT_CutSheetReceiptDetail(); } } CSRD.TLCUTSHRD_CutSheet_FK = CSR.TLCUTSHR_Pk; CSRD.TLCUTSHRD_Description = (String)row.Cells[1].Value; CSRD.TLCUTSHRD_Size_FK = (int)row.Cells[2].Value; CSRD.TLCUTSHRD_BundleQty = (int)row.Cells[3].Value; CSRD.TLCUTSHRD_InBundleStore = true; if (Dept != null) { var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 200).FirstOrDefault(); if (TranType != null) { CSRD.TLCUTSHRD_TransactionType = TranType.TrxT_Pk; CSRD.TLCUTSHRD_CurrentStore_FK = (int)TranType.TrxT_ToWhse_FK; } } if (Add) { context.TLCUT_CutSheetReceiptDetail.Add(CSRD); } } TLCUT_CutSheetReceiptBoxes CSRB = new TLCUT_CutSheetReceiptBoxes(); CSRB = context.TLCUT_CutSheetReceiptBoxes.Where(x => x.TLCUTSHB_CutSheet_FK == CSR.TLCUTSHR_Pk).FirstOrDefault(); Add = false; if (CSRB == null) { CSRB = new TLCUT_CutSheetReceiptBoxes(); Add = true; } CSRB.TLCUTSHB_CutSheet_FK = CSR.TLCUTSHR_Pk; if (!String.IsNullOrEmpty(txtAdultBoxes.Text)) { CSRB.TLCUTSHB_AdultBoxes = Convert.ToInt32(txtAdultBoxes.Text); } else { CSRB.TLCUTSHB_AdultBoxes = 0; } if (!String.IsNullOrEmpty(txtKidsBoxes.Text)) { CSRB.TLCUTSHB_KidBoxes = Convert.ToInt32(txtKidsBoxes.Text); } else { CSRB.TLCUTSHB_KidBoxes = 0; } if (!String.IsNullOrEmpty(txtBinding.Text)) { CSRB.TLCUTSHB_Binding = Convert.ToInt32(txtBinding.Text); } else { CSRB.TLCUTSHB_Binding = 0; } if (!String.IsNullOrEmpty(txtRibbing.Text)) { CSRB.TLCUTSHB_Ribbing = Convert.ToInt32(txtRibbing.Text); } else { CSRB.TLCUTSHB_Ribbing = 0; } if (Add) { context.TLCUT_CutSheetReceiptBoxes.Add(CSRB); } try { context.SaveChanges(); MessageBox.Show("Data saved successfully to database"); dataGridView1.Rows.Clear(); dataGridView2.Rows.Clear(); SetUp(); } catch (System.Data.Entity.Validation.DbEntityValidationException en) { foreach (var eve in en.EntityValidationErrors) { MessageBox.Show("following validation errors: Type" + eve.Entry.Entity.GetType().Name.ToString() + "State " + eve.Entry.State.ToString()); foreach (var ve in eve.ValidationErrors) { MessageBox.Show("- Property" + ve.PropertyName + " Message " + ve.ErrorMessage); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } }
private void btnSave_Click(object sender, EventArgs e) { bool Update = false; Button oBtn = sender as Button; if (oBtn != null && formloaded) { var selected = (TLCUT_CutSheet)cmboCutSheet.SelectedItem; if (selected == null) { MessageBox.Show("Please select a cut sheet from the drop down list "); return; } var WhseSelected = (TLADM_WhseStore)cmboRejectStore.SelectedItem; if (WhseSelected == null) { MessageBox.Show("Please select a reject store from the drop down list"); return; } if (String.IsNullOrEmpty(txtAuthorisedBy.Text)) { MessageBox.Show("Please complete the approved by details"); return; } using (var context = new TTI2Entities()) { var CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == selected.TLCutSH_Pk).FirstOrDefault(); CutReportOptions cropts = new CutReportOptions(); cropts.remarks = rtbNotes.Text; cropts.TransDate = dtpTransDate.Value; cropts.ApprovedBy = txtAuthorisedBy.Text; cropts.Pk = CSR.TLCUTSHR_Pk; cropts.CutSheetPk = selected.TLCutSH_Pk; cropts.ReturnedTo = context.TLADM_WhseStore.Find(WhseSelected.WhStore_Id).WhStore_Description; var cs = context.TLCUT_CutSheet.Find(selected.TLCutSH_Pk); if (cs != null) { cs.TLCutSH_Notes = rtbNotes.Text; } foreach (DataGridViewRow row in dataGridView1.Rows) { if ((bool)row.Cells[1].Value == false) { continue; } //------------------------------------------------------ // 1st Step reduce the SOH with what was written off //----------------------------------------------------------- var index = (int)row.Cells[0].Value; var CSRD = context.TLCUT_CutSheetReceiptDetail.Find(index); if (CSRD != null) { CSRD.TLCUTSHRD_RejectQty += (int)row.Cells[6].Value; CSRD.TLCUTSHRD_RejectDate = dtpTransDate.Value; CSRD.TLCUTSHRD_RejectReason = (int)row.Cells[5].Value; } //------------------------------------------------- // Now create a new Record of the written off value //--------------------------------------------------- TLCUT_CutSheetReceiptDetail NewCSR = new TLCUT_CutSheetReceiptDetail(); NewCSR.TLCUTSHRD_CutSheet_FK = CSR.TLCUTSHR_Pk; NewCSR.TLCUTSHRD_Description = row.Cells[2].Value.ToString() + "R"; NewCSR.TLCUTSHRD_Size_FK = (int)row.Cells[3].Value; NewCSR.TLCUTSHRD_BundleQty = (int)row.Cells[4].Value; NewCSR.TLCUTSHRD_BoxUnits = 0; NewCSR.TLCUTSHRD_TransactionType = 55; NewCSR.TLCUTSHRD_CurrentStore_FK = WhseSelected.WhStore_Id; NewCSR.TLCUTSHRD_PanelRejected = true; NewCSR.TLCUTSHRD_RejectDate = dtpTransDate.Value; NewCSR.TLCUTSHRD_RejectQty = (int)row.Cells[6].Value; NewCSR.TLCUTSHRD_RejectReason = (int)row.Cells[5].Value; context.TLCUT_CutSheetReceiptDetail.Add(NewCSR); Update = true; } //------------------------------------------------------- // //----------------------------------------------------------- string Mach_IP = Dns.GetHostEntry(Dns.GetHostName()) .AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork) .ToString(); var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CUT")).FirstOrDefault(); TLADM_DailyLog DailyLog = new TLADM_DailyLog(); DailyLog.TLDL_IPAddress = Mach_IP; DailyLog.TLDL_Dept_Fk = Dept.Dep_Id; DailyLog.TLDL_Date = DateTime.Now; DailyLog.TLDL_TransDetail = "Cutting Dept Panel Rejected"; DailyLog.TLDL_AuthorisedBy = txtAuthorisedBy.Text;; DailyLog.TLDL_Comments = rtbNotes.Text; context.TLADM_DailyLog.Add(DailyLog); //---------------------------------------------------------- if (Update) { try { context.SaveChanges(); MessageBox.Show("Data saved successfully to database"); frmCutViewRep vRep = new frmCutViewRep(3, cropts); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; TLCUT_CutSheetReceipt CSR = null; if (oBtn != null && formloaded) { using (var context = new TTI2Entities()) { var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CUT")).FirstOrDefault(); if (CutSheetSelected != 0) { CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == CutSheetSelected).FirstOrDefault(); if (CSR != null) { CSR.TLCUTSHR_InBundleStore = false; CSR.TLCUTSHR_InPanelStore = true; CSR.TLCUTSHR_DateIntoPanelStore = dtpTransActionDate.Value; var CS = context.TLCUT_CutSheet.Find(CSR.TLCUTSHR_CutSheet_FK); if (CS != null) { if (rtbAdditional.Text.Length != 0) { CS.TLCUTSH_AddNotes = rtbAdditional.Text; } CS.TLCUTSH_Completed_Date = DateTime.Now; CSR.TLCUTSHR_Colour_FK = CS.TLCutSH_Colour_FK; var CutStore = context.TLADM_WhseStore.Where(x => x.WhStore_DepartmentFK == CS.TLCutSH_Department_FK && x.WhStore_PanelStore).FirstOrDefault(); if (CutStore != null) { CSR.TLCUTSHR_WhsePanStore_FK = CutStore.WhStore_Id; CSR.TLCUTSHR_DateIntoPanelStore = dtpTransActionDate.Value; } } } } else { MessageBox.Show("Please select a cutsheet from the drop down box"); return; } foreach (DataGridViewRow row in dataGridView1.Rows) { TLCUT_CutSheetReceiptDetail CSRD = new TLCUT_CutSheetReceiptDetail(); var index = (int)row.Cells[0].Value; CSRD = context.TLCUT_CutSheetReceiptDetail.Find(index); if (CSRD != null) { CSRD.TLCUTSHRD_BoxNumber = dataGridView1.Rows[row.Index].Cells[3].Value.ToString(); if ((int)dataGridView1.Rows[row.Index].Cells[4].Value == 0) { continue; } CSRD.TLCUTSHRD_BoxUnits = (int)dataGridView1.Rows[row.Index].Cells[4].Value; CSRD.TLCUTSHRD_BoxType_FK = 1; // removed to speed up data capture (int)dataGridView1.Rows[row.Index].Cells[5].Value; CSRD.TLCUTSHRD_InBundleStore = false; CSRD.TLCUTSHRD_PanelDate = dtpTransActionDate.Value; if (Dept != null) { var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 600).FirstOrDefault(); if (TranType != null) { CSRD.TLCUTSHRD_TransactionType = TranType.TrxT_Pk; CSRD.TLCUTSHRD_CurrentStore_FK = (int)TranType.TrxT_ToWhse_FK; } } } } var CSB = context.TLCUT_CutSheetReceiptBoxes.Where(x => x.TLCUTSHB_Pk == CSR.TLCUTSHR_Pk).FirstOrDefault(); if (CSB != null) { int value = 0; if (int.TryParse(txtAdultBoxes.Text, out value)) { CSB.TLCUTSHB_AdultBoxes = value; } value = 0; if (int.TryParse(txtBinding.Text, out value)) { CSB.TLCUTSHB_Binding = value; } value = 0; if (int.TryParse(txtKidsBoxes.Text, out value)) { CSB.TLCUTSHB_KidBoxes = value; } value = 0; if (int.TryParse(txtRibbing.Text, out value)) { CSB.TLCUTSHB_Ribbing = value; } } try { context.SaveChanges(); MessageBox.Show("Data saved successfully to database"); dataGridView1.Rows.Clear(); //This form is the summary form for Mary in the accessories store //=================================================== frmCutViewRep vRep = new frmCutViewRep(11, CutSheetSelected); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(); //This form is the CMT Issued to line document //============================================================== vRep = new frmCutViewRep(14, CutSheetSelected); h = Screen.PrimaryScreen.WorkingArea.Height; w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(); } catch (System.Data.Entity.Validation.DbEntityValidationException en) { foreach (var eve in en.EntityValidationErrors) { MessageBox.Show("following validation errors: Type" + eve.Entry.Entity.GetType().Name.ToString() + "State " + eve.Entry.State.ToString()); foreach (var ve in eve.ValidationErrors) { MessageBox.Show("- Property" + ve.PropertyName + " Message " + ve.ErrorMessage); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }