public frmGreigeProduction(TLKNI_Order KO) { InitializeComponent(); core = new Util(); txtKnitOrderWeight.KeyDown += core.txtWin_KeyDownOEM; txtKnitOrderWeight.KeyPress += core.txtWin_KeyPress; txtKOPieces.KeyDown += core.txtWin_KeyDown; txtKOPieces.KeyPress += core.txtWin_KeyPress; _KO = KO; SetUp(); }
private void frmKnitOrderAdjust_Load(object sender, EventArgs e) { FormLoaded = false; using (var context = new TTI2Entities()) { comboGreige.DataSource = context.TLADM_Griege.OrderBy(x => x.TLGreige_Description).ToList(); comboGreige.ValueMember = "TLGreige_Id"; comboGreige.DisplayMember = "TLGreige_Description"; comboGreige.SelectedValue = -1; var Department = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault(); if (Department != null) { comboMachine.DataSource = context.TLADM_MachineDefinitions.Where(x => x.MD_Department_FK == Department.Dep_Id).OrderBy(x => x.MD_AlternateDesc).ToList(); comboMachine.DisplayMember = "MD_AlternateDesc"; comboMachine.ValueMember = "MD_Pk"; comboMachine.SelectedValue = -1; KnitO = context.TLKNI_Order.Find(_KnitOrderPk); if (KnitO != null) { cbResetYarnAllocated.Checked = false; if (KnitO.KnitO_Closed) { rbClosed.Checked = true; } else { rbActive.Checked = true; } label5.Text = KnitO.KnitO_OrderNumber.ToString(); comboGreige.SelectedValue = KnitO.KnitO_Product_FK; label4.Text = KnitO.KnitO_NoOfPieces.ToString(); comboMachine.SelectedValue = KnitO.KnitO_Machine_FK; } } } FormLoaded = true; }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; TLKNI_Order KO = null; if (oBtn != null && formloaded) { if (Decimal.Parse(txtAdjustedWeight.Text) > 0) { Decimal Weight = Decimal.Parse(txtAdjustedWeight.Text); if (GreigeProd.GreigeP_weight - Weight >= 0) { using (var context = new TTI2Entities()) { var GP = context.TLKNI_GreigeProduction.Find(GreigeProd.GreigeP_Pk); if (GP != null) { if (GP.GreigeP_KnitO_Fk != null) { KO = context.TLKNI_Order.Find(GP.GreigeP_KnitO_Fk); if (KO != null) { //============================================ // Create an actual Production split record //============================================= TLKNI_ProductionSplit ProdSplit = new TLKNI_ProductionSplit(); ProdSplit.TLKNISP_FromStore_FK = (int)GreigeProd.GreigeP_Store_FK; if (radKNumber.Checked) { ProdSplit.TLKNISP_NewPieceNo = "K" + GreigeProd.GreigeP_PieceNo.ToString(); } else { ProdSplit.TLKNISP_NewPieceNo = "R" + GreigeProd.GreigeP_PieceNo.ToString(); } ProdSplit.TLKNISP_Date = DateTime.Now; ProdSplit.TLKNISP_OrigPieceNo = GreigeProd.GreigeP_PieceNo; ProdSplit.TLKNISP_Notes = txtReasons.Text; ProdSplit.TLKNISP_Mass = GP.GreigeP_weight - Weight; ProdSplit.TLKNISP_KnitOrder_FK = KO.KnitO_Pk; var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault(); if (Dept != null) { var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 2005).FirstOrDefault(); if (TranType != null) { ProdSplit.TLKNISP_ToStore_FK = (int)TranType.TrxT_ToWhse_FK; } } context.TLKNI_ProductionSplit.Add(ProdSplit); //================================================ // Now Adjust the actual GP record with new weight //========================================= GP.GreigeP_weight = Weight; GP.GreigeP_weightAvail = Weight; } } } try { context.SaveChanges(); MessageBox.Show("Data successfully saved to database"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { MessageBox.Show("Cannot split more than what was originally Knitted"); } } } }
private void cbResetYarnAllocated_CheckedChanged(object sender, EventArgs e) { CheckBox oChk = sender as CheckBox; if (oChk != null && FormLoaded) { if (oChk.Checked) { DialogResult res = MessageBox.Show("Please confirm this transaction", "Confimation Required", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (res == DialogResult.Yes) { using (var context = new TTI2Entities()) { if (KnitO == null) { KnitO = context.TLKNI_Order.Find(_KnitOrderPk); } if (KnitO != null && KnitO.KnitO_YarnAssigned) { KnitO.KnitO_YarnAssigned = false; var YarnAllocs = context.TLKNI_YarnAllocTransctions.Where(x => x.TLKYT_KnitOrder_FK == KnitO.KnitO_Pk).ToList(); foreach (var YarnAlloc in YarnAllocs) { var YarnPallet = context.TLKNI_YarnOrderPallets.Find(YarnAlloc.TLKYT_YOP_FK); if (YarnPallet != null) { YarnPallet.TLKNIOP_ReservedBy = 0; YarnPallet.TLKNIOP_NettWeightReserved = 0; YarnPallet.TLKNIOP_ConesReserved = 0; YarnPallet.TLKNIOP_ReservedDate = null; YarnPallet.TLKNIOP_AdditionalYarn = 0; YarnPallet.TLKNIOP_NettWeightReturned = 0; } } context.TLKNI_YarnAllocTransctions.RemoveRange(context.TLKNI_YarnAllocTransctions.Where(x => x.TLKYT_KnitOrder_FK == KnitO.KnitO_Pk)); try { context.SaveChanges(); MessageBox.Show("Data successfully saved to database"); return; } 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); } } else { MessageBox.Show("Unable to action request. No yarn currently assigned"); } } } } } }