private void cmbCotton_SelectedIndexChanged(object sender, EventArgs e) { ComboBox oCmb = sender as ComboBox; if (oCmb != null && formloaded) { var cotton = (TLADM_Cotton)cmbCotton.SelectedItem; if (cotton != null) { using (var context = new TTI2Entities()) { TLADM_Cotton newcotton = context.TLADM_Cotton.Find(cotton.Cotton_Pk); txtCode.Text = newcotton.Cotton_Code; txtDescription.Text = newcotton.Cotton_Description; txtGrade.Text = newcotton.Cotton_Grade; txtRol.Text = Math.Round(newcotton.Cotton_ROL, 2).ToString(); txtRoq.Text = Math.Round(newcotton.Cotton_ROQ, 2).ToString(); txtContact.Text = newcotton.Cotton_Contact; if (newcotton.Cotton_ShowQty) { rbShowQtyYes.Checked = true; txtUnits.Visible = true; } else { rbShowQtyNo.Checked = true; txtUnits.Visible = false; } if (newcotton.Cotton_ShowStdCost) { rbShowCostYes.Checked = true; txtStdCost.Visible = true; } else { rbShowQtyNo.Checked = true; txtStdCost.Visible = false; } txtStdCost.Text = Math.Round(newcotton.Cotton_StdCost, 2).ToString(); txtUnits.Text = newcotton.Cotton_Units.ToString(); rtbNotes.Text = newcotton.Cotton_Notes; cmbOrigin.SelectedValue = newcotton.Cotton_Origin_FK; cmbStore.SelectedValue = newcotton.Cotton_Store_FK; cmbUOM.SelectedValue = newcotton.Cotton_UOM_Fk; cmbStockType.SelectedValue = newcotton.Cotton_StockType_FK; cmbCottonAgent.SelectedValue = newcotton.Cotton_Agent_FK; FldEntered = core.PopulateArray(FldNames.Length, true); } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool lSuccess = true; if (oBtn != null && formloaded) { var Mess = returnMessage(FldEntered); if (!string.IsNullOrEmpty(Mess)) { MessageBox.Show(Mess); return; } using (var context = new TTI2Entities()) { TLADM_Cotton ctn = new TLADM_Cotton(); if (!addRecord) { var cotton = (TLADM_Cotton)cmbCotton.SelectedItem; if (cotton != null) { ctn = context.TLADM_Cotton.Find(cotton.Cotton_Pk); } } ctn.Cotton_Code = txtCode.Text; ctn.Cotton_Description = txtDescription.Text; ctn.Cotton_Grade = txtGrade.Text; ctn.Cotton_ROL = Convert.ToDecimal(txtRol.Text); ctn.Cotton_ROQ = Convert.ToDecimal(txtRoq.Text); if (rbShowCostYes.Checked) { ctn.Cotton_ShowStdCost = true; } else { ctn.Cotton_ShowStdCost = false; } if (rbShowQtyYes.Checked) { ctn.Cotton_ShowQty = true; } else { ctn.Cotton_ShowQty = false; } ctn.Cotton_Contact = txtContact.Text; ctn.Cotton_Units = Convert.ToInt32(txtUnits.Text); ctn.Cotton_StdCost = Math.Round(Convert.ToDecimal(txtStdCost.Text), 2); ctn.Cotton_Notes = rtbNotes.Text; //---------------------------------------------------------- var uom = (TLADM_UOM)cmbUOM.SelectedItem; if (uom != null) { ctn.Cotton_UOM_Fk = uom.UOM_Pk; } else { ctn.Cotton_UOM_Fk = 1; } //--------------------------------------------------------------------- var store = (TLADM_WhseStore)cmbStore.SelectedItem; if (store != null) { ctn.Cotton_Store_FK = store.WhStore_Id; } else { ctn.Cotton_Store_FK = 1; } //-------------------------------------------------------------------- var stock = (TLADM_StockTypes)cmbStockType.SelectedItem; if (stock != null) { ctn.Cotton_StockType_FK = stock.ST_Id; } else { ctn.Cotton_StockType_FK = 1; } //----------------------------------------------------------------------- var origin = (TLADM_CottonOrigin)cmbOrigin.SelectedItem; if (origin != null) { ctn.Cotton_Origin_FK = origin.CottonOrigin_Pk; } else { ctn.Cotton_Origin_FK = 1; } //----------------------------------------------------------------------- var agents = (TLADM_CottonAgent)cmbCottonAgent.SelectedItem; if (agents != null) { ctn.Cotton_Agent_FK = agents.CottonAgent_Pk; } else { ctn.Cotton_Agent_FK = 1; } if (addRecord) { context.TLADM_Cotton.Add(ctn); } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); lSuccess = false; } } if (lSuccess) { MessageBox.Show("Records saved to database successfully"); Setup(false); } } }