private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool lAdd; bool lNoProblems = false; if (oBtn != null) { using (var context = new TTI2Entities()) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[0].Value != null) { lAdd = true; TLADM_ProductRating pr = new TLADM_ProductRating(); if (row.Cells[8].Value != null) { var index = (int)row.Cells[8].Value; pr = context.TLADM_ProductRating.Find(index); lAdd = false; } pr.PR_Style_FK = (int)row.Cells[0].Value; pr.PR_Quality = row.Cells[1].Value.ToString(); pr.Pr_Wieght = Convert.ToInt32(row.Cells[2].Value.ToString()); pr.Pr_Width = Convert.ToInt32(row.Cells[3].Value.ToString()); pr.Pr_Size_FK = Convert.ToInt32(row.Cells[4].Value.ToString()); pr.PR_Rating = Convert.ToDecimal(row.Cells[5].Value.ToString()); pr.PR_Yield = Convert.ToDecimal(row.Cells[6].Value.ToString()); pr.PR_PCS_Kg = Convert.ToDecimal(row.Cells[7].Value.ToString()); if (lAdd) { context.TLADM_ProductRating.Add(pr); } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); lNoProblems = true; } } } } if (!lNoProblems) { dataGridView1.Rows.Clear(); MessageBox.Show("All records stored to the database"); } } }
private void btnSaveTrims_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool updateSuccessful = true; if (formloaded && oBtn != null) { using (var context = new TTI2Entities()) { foreach (DataRow DRow in ProductRating.Rows) { TLADM_ProductRating pr = new TLADM_ProductRating(); if (!DRow.Field <bool>(10)) { pr = context.TLADM_ProductRating.Find(DRow.Field <int>(0)); } if (rbBody.Checked) { pr.Pr_BodyorRibbing = 1; pr.Pr_Size_FK = DRow.Field <int>(11); } else { pr.Pr_BodyorRibbing = 0; pr.Pr_Trim_FK = DRow.Field <int>(11); } var Cust = (TLADM_CustomerFile)cmbLabels.SelectedItem; if (Cust != null) { pr.Pr_Customer_FK = Cust.Cust_Pk; } var Style = (TLADM_Styles)cmbStyles.SelectedItem; if (Style != null) { pr.Pr_Style_FK = Style.Sty_Id; } pr.Pr_PowerN = DRow.Field <int>(9); pr.Pr_Discontinued = DRow.Field <bool>(2); pr.Pr_MultiMarker = DRow.Field <bool>(8); pr.Pr_Ratio = DRow.Field <decimal>(4); if (!DRow.Field <bool>(8)) { pr.Pr_Ratio = 1; } pr.Pr_Marker_Length = DRow.Field <decimal>(5); pr.Pr_numeric_Rating = DRow.Field <decimal>(6); pr.Pr_Display = DRow.Field <String>(1); if (!String.IsNullOrWhiteSpace(DRow.Field <string>(3))) { pr.Pr_Display += " / " + DRow.Field <string>(3); } if (DRow.Field <bool>(10)) { context.TLADM_ProductRating.Add(pr); } } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); updateSuccessful = false; } finally { if (updateSuccessful) { ProductRating.Rows.Clear(); MessageBox.Show("Records successfully updated"); } } } } }
private void datagridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { Util core = new Util(); var oDgv = sender as DataGridView; int pn = 0; List <int> xx = null; if (oDgv.Focused && oDgv.CurrentCell is DataGridViewButtonCell) { if (e.ColumnIndex == 1) { if (rbBody.Checked) { var Id = 1005; var RowPos = oDgv.CurrentRow.Index; pn = int.Parse(oDgv.CurrentRow.Cells[9].Value.ToString()); frmTLADMGardProp aprop = new frmTLADMGardProp(Id, pn, Listsizes); aprop.ShowDialog(); var sizes = aprop.TotalPN; if (sizes != 0) { StringBuilder desciption = new StringBuilder(); int a = Convert.ToInt32(sizes); using (var context = new TTI2Entities()) { xx = core.ExtrapNumber(a, context.TLADM_Sizes.Count()); } xx.Sort(); oDgv.CurrentRow.Cells[8].Value = false; if (xx.Count > 1) { oDgv.CurrentRow.Cells[8].Value = true; } foreach (var rw in xx) { bool First = true; foreach (var dd in Listsizes) { if (dd.SI_PowerN == rw) { if (First) { First = !First; oDgv.CurrentRow.Cells[11].Value = dd.SI_id; } if (desciption.Length == 0) { desciption.Append(dd.SI_Description); } else { desciption.Append(", " + dd.SI_Description); } } } } oDgv.CurrentRow.Cells[10].Value = false; if ((int)oDgv.CurrentRow.Cells[0].Value == 0) { oDgv.CurrentRow.Cells[10].Value = true; } oDgv.CurrentRow.Cells[1].Value = desciption; oDgv.CurrentRow.Cells[7].Value = "Ratio"; oDgv.CurrentRow.Cells[9].Value = sizes; } } else if (rbTrims.Checked) { var StyleSelected = (TLADM_Styles)cmbStyles.SelectedItem; if (StyleSelected != null) { var Id = 1007; int[] TrimKeys = new int[2]; // First Element is the style //====================================== TrimKeys[0] = StyleSelected.Sty_Id; // Second element is the Primary Key of the Trim //=============================================== TrimKeys[1] = (int)oDgv.Rows[e.RowIndex].Cells[11].Value; var RowPos = oDgv.CurrentRow.Index; pn = int.Parse(oDgv.CurrentRow.Cells[9].Value.ToString()); frmTLADMGardProp aprop = new frmTLADMGardProp(Id, TrimKeys, true); aprop.ShowDialog(); var sizes = aprop._TrimKeys; oDgv.CurrentRow.Cells[8].Value = false; oDgv.CurrentRow.Cells[10].Value = false; if ((int)oDgv.CurrentRow.Cells[0].Value == 0) { oDgv.CurrentRow.Cells[10].Value = true; } oDgv.CurrentRow.Cells[11].Value = sizes[1]; using (var context = new TTI2Entities()) { oDgv.CurrentRow.Cells[1].Value = context.TLADM_Trims.Find(sizes[1]).TR_Description; } oDgv.CurrentRow.Cells[7].Value = "Ratio"; oDgv.CurrentRow.Cells[9].Value = 0; } } } else { // Only available to body details //----------------------------------------------- if (!rbBody.Checked) { using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box { MessageBox.Show("Please select the body check box prior to selecting this option"); } return; } //Only available to multi sized markers //----------------------------------------------- var CurrentRow = oDgv.CurrentRow; if (!(bool)CurrentRow.Cells[8].Value) { using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box { MessageBox.Show("This option is only available to multi sized Markers"); return; } } else { var PNumber = (int)CurrentRow.Cells[9].Value; int PrimaryKey = (int)CurrentRow.Cells[0].Value; if (PrimaryKey == 0) { using (var context = new TTI2Entities()) { TLADM_ProductRating ProductRating = new TLADM_ProductRating(); context.TLADM_ProductRating.Add(ProductRating); try { context.SaveChanges(); PrimaryKey = ProductRating.Pr_Id; CurrentRow.Cells[0].Value = PrimaryKey; CurrentRow.Cells[10].Value = false; } catch (Exception ex) { MessageBox.Show(ex.InnerException.Message.ToString()); return; } } } frmTLADMProductRatingDetail prodDetail = new frmTLADMProductRatingDetail(PNumber, PrimaryKey); prodDetail.ShowDialog(this); if (prodDetail.ProductRatio != 0) { oDgv.Rows[e.RowIndex].Cells[4].Value = (decimal)prodDetail.ProductRatio; if (oDgv.Rows[e.RowIndex].Cells[5].Value != null) { var ML = (decimal)oDgv.Rows[e.RowIndex].Cells[5].Value; try { oDgv.Rows[e.RowIndex].Cells[6].Value = Math.Round(ML / prodDetail.ProductRatio, 4); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } } } } } }