private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && FormLoaded) { var Selected = (TLADM_WhseStore)cmboWarehouses.SelectedItem; if (Selected == null) { MessageBox.Show("Please select a warehouse from the combobox provided"); return; } using (var context = new TTI2Entities()) { foreach (DataGridViewRow Row in dataGridView1.Rows) { if (Row.Cells[0].Value == null) { continue; } var RWComplete = core.RowComplete(Row, MandatoryFields); var cnt = RWComplete.Where(x => x == false).Count(); if (cnt == MandatoryFields.Length) { continue; } if (cnt != 0) { var errorM = core.returnMessage(RWComplete, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM, "Error Message for Line No" + (Row.Index + 1).ToString()); return; } } TLCSV_StockOnHand SOH = new TLCSV_StockOnHand(); var Style_FK = (int)Row.Cells[1].Value; var Colour_FK = (int)Row.Cells[2].Value; var Size_FK = (int)Row.Cells[3].Value; TLADM_Styles Styles = context.TLADM_Styles.Find(Style_FK); TLADM_Colours Colours = context.TLADM_Colours.Find(Colour_FK); TLADM_Sizes Sizes = context.TLADM_Sizes.Find(Size_FK); SOH.TLSOH_PastelNumber = Styles.Sty_PastelNo + Colours.Col_FinishedCode + "NG" + Sizes.SI_PastelNo; SOH.TLSOH_BoxNumber = Row.Cells[0].Value.ToString(); SOH.TLSOH_Style_FK = (int)Row.Cells[1].Value; SOH.TLSOH_Colour_FK = (int)Row.Cells[2].Value; SOH.TLSOH_Size_FK = (int)Row.Cells[3].Value; SOH.TLSOH_CMT_FK = (int)Row.Cells[4].Value; SOH.TLSOH_Weight = (decimal)Row.Cells[5].Value; SOH.TLSOH_BoxedQty = Convert.ToInt32(Row.Cells[6].Value.ToString()); SOH.TLSOH_Grade = Row.Cells[7].Value.ToString().ToUpper().Trim(); SOH.TLSOH_BoxType = 1; SOH.TLSOH_DateIntoStock = dtpTransdate.Value; SOH.TLSOH_WareHouse_FK = Selected.WhStore_Id; if (SOH.TLSOH_Grade.Contains("A")) { SOH.TLSOH_Is_A = true; } var Cwork = context.TLCMT_CompletedWork.Where(x => x.TLCMTWC_BoxNumber == SOH.TLSOH_BoxNumber).FirstOrDefault(); if (Cwork != null) { SOH.TLSOH_CutSheet_FK = Cwork.TLCMTWC_CutSheet_FK; } var Already = context.TLCSV_StockOnHand.Where(x => x.TLSOH_BoxNumber == SOH.TLSOH_BoxNumber).FirstOrDefault(); if (Already != null) { if (!Already.TLSOH_Write_Off) { continue; } } context.TLCSV_StockOnHand.Add(SOH); } try { context.SaveChanges(); MessageBox.Show("Data successfully save to the database"); cmboWarehouses.SelectedItem = -1; dataGridView1.Rows.Clear(); frmStockTakeOn_Load(this, null); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } } }
private void cmboCMTLine_SelectedIndexChanged(object sender, EventArgs e) { ComboBox oCmbo = sender as ComboBox; if (oCmbo != null && formloaded) { var selected = (int)oCmbo.SelectedValue; if (selected != 0) { formloaded = false; dataGridView1.Rows.Clear(); dataGridView2.Rows.Clear(); formloaded = true; txtDifference.Text = "0"; txtTotAGrade.Text = "0"; txtTotBGrade.Text = "0"; txtTPIssued.Text = "0"; txtTPPanels.Text = "0"; txtNoBoxes.Text = "0"; using (var context = new TTI2Entities()) { var LI = context.TLCMT_LineIssue.Find(selected); if (LI != null) { CS = context.TLCUT_CutSheet.Find(LI.TLCMTLI_CutSheet_FK); if (CS != null) { CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == CS.TLCutSH_Pk).FirstOrDefault(); if (CSR == null) { MessageBox.Show("Technical error encounted. Qoute number 1400"); frmCompleted_Load(this, null); return; } //------------------------------------------------------- //We have to check that all the BFA Data has been recorded //-------------------------------------------------------------------- int BFACount = context.TLCMT_AuditMeasureRecorded.Where(x => x.TLBFAR_CutSheet_FK == CS.TLCutSH_Pk).Count(); if (BFACount == 0) { MessageBox.Show("Please enter the BFA Audit information" + Environment.NewLine + "using the facility provided"); frmCompleted_Load(this, null); return; } //------------------------------------------------------ // We have to now //========================================= var ExpectUnits = context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == CS.TLCutSH_Pk).ToList(); foreach (var Unit in ExpectUnits) { TLADM_Sizes Size = new TLADM_Sizes(); Size.SI_Description = context.TLADM_Sizes.Find(Unit.TLCUTE_Size_FK).SI_Description; Size.SI_id = Unit.TLCUTE_Size_FK; oCmboA.Items.Add(Size); } //--------------------------------------------------------------- //If expected units data not available, for what ever reason, go back to the original order //========================================================================== if (oCmboA.Items.Count == 0) { var CutSheetDetail = context.TLCUT_CutSheetReceiptDetail.Where(x => x.TLCUTSHRD_CutSheet_FK == CSR.TLCUTSHR_Pk).GroupBy(x => x.TLCUTSHRD_Size_FK); foreach (var Grouped in CutSheetDetail) { var Size_Pk = Grouped.FirstOrDefault().TLCUTSHRD_Size_FK; TLADM_Sizes Size = new TLADM_Sizes(); Size.SI_Description = context.TLADM_Sizes.Find(Size_Pk).SI_Description; Size.SI_id = Size_Pk; oCmboA.Items.Add(Size); } } oCmboA.DisplayMember = "SI_Description"; oCmboA.ValueMember = "SI_Id"; txtCutSheet.Text = CS.TLCutSH_No; var DB = context.TLDYE_DyeBatch.Find(CS.TLCutSH_DyeBatch_FK); if (DB != null) { var DO = context.TLDYE_DyeOrder.Find(DB.DYEB_DyeOrder_FK); if (DO != null) { var dt = core.FirstDateOfWeek(DO.TLDYO_OrderDate.Year, DO.TLDYO_CMTReqWeek); txtDateRequired.Text = dt.AddDays(5).ToString("dd/MM/yyyy"); } } Styles = context.TLADM_Styles.Find(CS.TLCutSH_Styles_FK); Colours = context.TLADM_Colours.Find(CS.TLCutSH_Colour_FK); StyleGrades = context.TLADM_StylesGrades.Where(x => x.TLSG_Style_Fk == CS.TLCutSH_Styles_FK).FirstOrDefault(); var Existing = context.TLCUT_CutSheetReceiptDetail.Where(x => x.TLCUTSHRD_CutSheet_FK == CSR.TLCUTSHR_Pk).ToList(); /* if (Existing != null) * { * Sizes = context.TLADM_Sizes.Find(Existing.FirstOrDefault().TLCUTSHRD_Size_FK); * }*/ foreach (var row in Existing) { var index = dataGridView1.Rows.Add(); this.dataGridView1.Rows[index].Cells[0].Value = row.TLCUTSHRD_BoxNumber; this.dataGridView1.Rows[index].Cells[1].Value = Styles.Sty_Description; this.dataGridView1.Rows[index].Cells[2].Value = Colours.Col_Display; this.dataGridView1.Rows[index].Cells[3].Value = row.TLCUTSHRD_BoxUnits; } txtTPIssued.Text = Existing.Sum(x => x.TLCUTSHRD_BoxUnits).ToString(); // 0 Box No datagridView2 // 1 Code datagridView2 // 2 Size datagridView2 // 3 Grade datagridView2 // 4 Qty datagridView2 // 5 Weight dataGridView2 // 6 FK CutSheetSheet Receipt Detail datagridView2 formloaded = false; foreach (var row in Existing) { var index = dataGridView2.Rows.Add(); this.dataGridView2.Rows[index].Cells[0].Value = row.TLCUTSHRD_BoxNumber; this.dataGridView2.Rows[index].Cells[1].Value = string.Empty; this.dataGridView2.Rows[index].Cells[2].Value = null; // string.Empty; this.dataGridView2.Rows[index].Cells[3].Value = string.Empty; this.dataGridView2.Rows[index].Cells[4].Value = 0; this.dataGridView2.Rows[index].Cells[5].Value = 0.00M; this.dataGridView2.Rows[index].Cells[6].Value = row.TLCUTSHRD_Pk; } formloaded = true; if (this.dataGridView2.Rows.Count != 0) { this.dataGridView2.CurrentCell = this.dataGridView2.Rows[0].Cells[1]; this.dataGridView2.BeginEdit(true); } } } } } } }
private void cmboFabric_SelectedIndexChanged(object sender, EventArgs e) { ComboBox oCmbo = sender as ComboBox; if (oCmbo != null && formloaded) { var selected = (TLADM_Griege)cmboFabric.SelectedItem; if (selected != null) { var result = (from u in MandatoryFields where u[0] == oCmbo.Name select u).FirstOrDefault(); if (result != null) { int nbr = Convert.ToInt32(result[2].ToString()); MandSelected[nbr] = true; } foreach (DataGridViewRow row in dataGridView1.Rows) { row.Cells[1].Value = 0.00M; row.Cells[2].Value = 0.00M; row.Cells[3].Value = 0.00M; } using (var context = new TTI2Entities()) { var FabWeight = context.TLADM_FabricWeight.Find(selected.TLGreige_FabricWeight_FK); var FabWidth = context.TLADM_FabWidth.Find(selected.TLGreige_FabricWidth_FK); FabricYield = core.FabricYield(FabWeight.FWW_Calculation_Value, FabWidth.FW_Calculation_Value); if (FabricYield != 0) { txtYieldFactor.Text = Math.Round(FabricYield, 4).ToString(); } var FabQual = context.TLADM_GreigeQuality.Where(x => x.GQ_Pk == selected.TLGreige_Quality_FK).FirstOrDefault(); if (FabQual != null) { var ExistingData = context.TLDYE_RecipeDefinition.ToList(); if (ExistingData != null) { IList <TLADM_Colours> Cols = new List <TLADM_Colours>(); foreach (var row in ExistingData) { TLADM_Colours cl = context.TLADM_Colours.Find(row.TLDYE_ColorChart_FK); Cols.Add(cl); } cmboColors.DataSource = context.TLADM_Colours.OrderBy(x => x.Col_Display).ToList(); cmboColors.ValueMember = "Col_Id"; cmboColors.DisplayMember = "Col_Display"; } } } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; TLADM_Colours SelectedColour = null; bool lAdd = false; if (lNew) { lAdd = true; } if (rbStandard.Checked) { SelectedColour = (TLADM_Colours)cmboColours.SelectedItem; if (SelectedColour == null) { MessageBox.Show("Please select a colour from the drop down box provided"); return; } if (QueryParms.FabricQualities.Count == 0) { MessageBox.Show("Please add a Quality"); return; } } if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandSelected, false, MandatoryFields); if (!String.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } foreach (DataGridViewRow dr in dataGridView1.Rows) { if (rbStandard.Checked) { var tst = fieldEntered.Find(x => x.rownumber == dr.Index); if (tst.fieldComplete == null) { continue; } tst.fieldComplete[1] = true; var cnt = tst.fieldComplete.Where(x => x == false).Count(); if (cnt == MandatoryRows.Length) { continue; } cnt = tst.fieldComplete.Where(x => x == true).Count(); } } // 0 index of the main record // 1 ConsumablesDC // 2 Grams Per Litre // 3 Ratios // 4 Liquid Ratios using (var context = new TTI2Entities()) { TLDYE_RecipeDefinition rd = new TLDYE_RecipeDefinition(); if (!lAdd) { var selected = (TLDYE_RecipeDefinition)cmboProductCodes.SelectedItem; if (selected != null) { rd = context.TLDYE_RecipeDefinition.Find(selected.TLDYE_DefinePk); } } rd.TLDYE_DefineCode = txtProductCode.Text; if (rbStandard.Checked) { rd.TLDYE_DefineDescription = txtProductCode.Text + " " + SelectedColour.Col_Display; } else { rd.TLDYE_DefineDescription = txtProductCode.Text; } if (rbStandard.Checked) { rd.TLDYE_ProgramLoad = Convert.ToInt32(txtProgramLoad.Text); rd.TLDYE_LiquidLoad = Convert.ToInt32(txtProgramVolume.Text); rd.TLDYE_ColorChart_FK = SelectedColour.Col_Id; rd.TLDYE_StandardReceipe = true; } else { rd.TLDYE_LiquidLoad = 0; rd.TLDYE_ProgramLoad = 0; rd.TLDYE_ColorChart_FK = null; rd.TLDYE_StandardReceipe = false; } if (lAdd) { context.TLDYE_RecipeDefinition.Add(rd); } try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { MessageBox.Show("Property: " + validationError.PropertyName + " Error " + validationError.ErrorMessage); } return; } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } // 0 index of the main record // 1 ConsumablesDC // 2 Grams Per Litre // 3 Ratios // 4 Liquid Ratios foreach (DataGridViewRow dr in dataGridView1.Rows) { if (dr.Cells[1].Value == null) { continue; } var tst = fieldEntered.Find(x => x.rownumber == dr.Index); if (tst.fieldComplete == null) { continue; } tst.fieldComplete[1] = true; var cnt = tst.fieldComplete.Where(x => x == false).Count(); if (cnt == MandatoryRows.Length) { continue; } lAdd = false; if (dr.Cells[0].Value == null) { lAdd = true; } cnt = tst.fieldComplete.Where(x => x == true).Count(); if (cnt == MandatoryRows.Length) { TLDYE_DefinitionDetails defdet = new TLDYE_DefinitionDetails(); if (!lAdd) { var index = Convert.ToInt32(dr.Cells[0].Value.ToString()); defdet = context.TLDYE_DefinitionDetails.Find(index); } defdet.TLDYED_Cosumables_FK = (int)dr.Cells[1].Value; if (dr.Cells[2].Value != null) { if ((bool)dr.Cells[2].Value == true) { defdet.TLDYED_LiqCalc = true; } else { defdet.TLDYED_LiqCalc = false; } } else { defdet.TLDYED_LiqCalc = false; } defdet.TLDYED_MELFC = (decimal)dr.Cells[3].Value; defdet.TLDYED_LiqRatio = (int)dr.Cells[4].Value; defdet.TLDYED_Receipe_FK = rd.TLDYE_DefinePk; if (lAdd) { context.TLDYE_DefinitionDetails.Add(defdet); } } } //--------------------------------------------------------- // //---------------------------------------------------------------- if (rbStandard.Checked) { //------------------------------------------------------------------------------------ // First we must ensure that any previous records that may exist are deleted and that we start with a clean slate //--------------------------------------------------------------------------- context.TLDYE_ReceipeGreigeQual.RemoveRange(context.TLDYE_ReceipeGreigeQual.Where(x => x.TLGQ_ReceipeDef_FK == rd.TLDYE_DefinePk)); //------------------------------------------------------ // new development //---------------------------------------------------------- foreach (var Qual in QueryParms.FabricQualities) { TLDYE_ReceipeGreigeQual repQual = new TLDYE_ReceipeGreigeQual(); repQual.TLGQ_GreigeQuality_FK = Qual.GQ_Pk; repQual.TLGQ_ReceipeDef_FK = rd.TLDYE_DefinePk; context.TLDYE_ReceipeGreigeQual.Add(repQual); } } try { context.SaveChanges(); MessageBox.Show("Data saved to database successfully"); } catch (Exception ex) { // MessageBox.Show(ex.Message); MessageBox.Show(ex.InnerException.ToString()); } finally { this.cmboGreigeQuality.Items.Clear(); dataGridView1.Rows.Clear(); SetUp(); } } } }