private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { var ErrM = core.returnMessage(MandSelected, false, MandatoryFields); if (!String.IsNullOrEmpty(ErrM)) { MessageBox.Show(ErrM); return; } using (var context = new TTI2Entities()) { if (Add) { var LNU = context.TLADM_LastNumberUsed.Find(3); if (LNU != null) { LNU.col4 += 1; } } TLDYE_ComDyeBatch cb = new TLDYE_ComDyeBatch(); if (!Add) { var Prev = (TLDYE_ComDyeBatch)cmboPrevBatches.SelectedItem; if (Prev != null) { cb = context.TLDYE_ComDyeBatch.Find(Prev.DYEBC_Pk); } } cb.DYEBC_BatchDate = dtpBatchDate.Value; cb.DYEBC_BatchNo = txtBatchNo.Text; cb.DYEBC_DateOrder = dtpDateOrdered.Value; cb.DYEBC_DateRequired = dtpDateOrdered.Value; cb.DYEBC_Greige_FK = (int)cmboGreige.SelectedValue; cb.DYEBC_Trim_Fk = (int)cmboTrims.SelectedValue; cb.DYEBC_Customer_FK = (int)cmboCustomer.SelectedValue; cb.DYEBC_Colour_FK = (int)cmboColours.SelectedValue; var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("DYE")).FirstOrDefault(); if (Dept != null) { var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 300).FirstOrDefault(); if (TranType != null) { cb.DYEBC_TransactionType = TranType.TrxT_Pk; } } if (Add) { context.TLDYE_ComDyeBatch.Add(cb); 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) { var exceptionMessages = new StringBuilder(); do { exceptionMessages.Append(ex.Message); ex = ex.InnerException; }while (ex != null); MessageBox.Show(exceptionMessages.ToString()); } } foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value.ToString() == bool.FalseString) { continue; } var index = (int)row.Cells[0].Value; TLKNI_GreigeCommissionTransctions rec = context.TLKNI_GreigeCommissionTransctions.Find(index); if (rec != null) { rec.GreigeCom_Batched = true; rec.GreigeCom_DyeBatch_FK = cb.DYEBC_Pk; } TLDYE_ComDyeBatchDetails cdb = new TLDYE_ComDyeBatchDetails(); cdb.TLCDD_PieceNo_FK = rec.GreigeCom_PK; cdb.TLCDD_ComDyeBatch_FK = cb.DYEBC_Pk; context.TLDYE_ComDyeBatchDetails.Add(cdb); } try { context.SaveChanges(); MessageBox.Show("Data saved to database successfully"); frmDyeViewReport vrep = new frmDyeViewReport(9, cb.DYEBC_Pk); vrep.ShowDialog(this); 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) { var exceptionMessages = new StringBuilder(); do { exceptionMessages.Append(ex.Message); ex = ex.InnerException; }while (ex != null); MessageBox.Show(exceptionMessages.ToString()); } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; int CLNU = 0; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandatorySelected, false, MandatoryFields); if (!String.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } using (var context = new TTI2Entities()) { var LNU = context.TLADM_LastNumberUsed.Find(2); if (LNU != null) { LNU.col8 += 1; } var custSelected = (TLADM_CustomerFile)cmbCommissionC.SelectedItem; var store = (TLADM_WhseStore)cmbStore.SelectedItem; if (custSelected != null) { CLNU = custSelected.Cust_LastNumberUsed; custSelected = context.TLADM_CustomerFile.Find(custSelected.Cust_Pk); custSelected.Cust_LastNumberUsed = CLNU + 1; } foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[0].Value == null) { continue; } TLKNI_GreigeCommissionTransctions comTrans = new TLKNI_GreigeCommissionTransctions(); comTrans.GreigeCom_Custdoc = txtCustDeliveryDoc.Text; comTrans.GreigeCom_Customer_FK = custSelected.Cust_Pk; comTrans.GreigeCom_Comments = txtComments.Text; comTrans.GreigeCom_CustOrderNo = (string)row.Cells[4].Value; comTrans.GreigeCom_Grade = (string)row.Cells[3].Value; comTrans.GreigeCom_GrnNo = CLNU; comTrans.GreigeCom_NettWeight = (decimal)row.Cells[5].Value; comTrans.GreigeCom_PieceNo = row.Cells[0].Value.ToString(); comTrans.GreigeCom_ProductType_FK = (int)row.Cells[2].Value; comTrans.GreigeCom_Transdate = dateTimePicker1.Value; comTrans.GreigeCom_TTSNo = (string)row.Cells[1].Value; comTrans.GreigeCom_Store_FK = store.WhStore_Id; comTrans.GreigeCom_Display = CLNU.ToString() + " " + txtCustDeliveryDoc.Text; context.TLKNI_GreigeCommissionTransctions.Add(comTrans); try { context.SaveChanges(); } catch (Exception ex) { } //we need to store further information in a separate file for the processing in the Dye Module TLKNI_GreigeProduction gp = new TLKNI_GreigeProduction(); gp.GreigeP_Captured = true; //----------------------------------------------------------- // gp.GreigeP_KnitO_Fk = CLNU; //------------------------------------------------------ gp.GreigeP_KnitO_Fk = comTrans.GreigeCom_PK; gp.GreigeP_CommisionCust = true; gp.GreigeP_CommissionCust_FK = custSelected.Cust_Pk; gp.GreigeP_Grade = (string)row.Cells[3].Value; gp.GreigeP_InspDate = DateTime.Now; gp.GreigeP_Inspected = true; gp.GreigeP_Meas1 = 0; gp.GreigeP_Meas2 = 0; gp.GreigeP_Meas3 = 0; gp.GreigeP_Meas4 = 0; gp.GreigeP_Meas5 = 0; gp.GreigeP_Meas6 = 0; gp.GreigeP_Meas7 = 0; gp.GreigeP_Meas8 = 0; gp.GreigeP_PDate = DateTime.Now; gp.GreigeP_PieceNo = (string)row.Cells[0].Value; gp.GreigeP_weight = (decimal)row.Cells[5].Value; gp.GreigeP_weightAvail = (decimal)row.Cells[5].Value; gp.GreigeP_Store_FK = store.WhStore_Id; gp.GreigeP_Greige_Fk = (int)row.Cells[2].Value; gp.GreigeP_CommissionGrn = CLNU; context.TLKNI_GreigeProduction.Add(gp); } try { context.SaveChanges(); MessageBox.Show("Data successfully saved to the database"); frmKnitViewRep vRep = new frmKnitViewRep(13, CLNU); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); dataGridView1.Rows.Clear(); SetUp(false); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }