private void microAvailYes_CheckedChanged(object sender, EventArgs e) { RadioButton oRb = sender as RadioButton; if (oRb != null && formloaded) { if (oRb.Checked) { var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); } else { TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); cotTrans.cotrx_LotNo = Convert.ToInt32(txtLotNo.Text); cotTrans.cotrx_Return_No = Convert.ToInt32(txtGrnNumber.Text); cotTrans.cotrx_GrossAveBaleWeight = Convert.ToDecimal(txtGrossAvgBaleWeight.Text); cotTrans.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNetAvgBaleWeight.Text); cotTrans.cotrx_NoBales = Convert.ToInt32(txtNoOfBales.Text); frmCottonBales cb = new frmCottonBales(cotTrans); cb.ShowDialog(this); } } } }
private void cmbContractNo_SelectedIndexChanged(object sender, EventArgs e) { ComboBox oCmbo = sender as ComboBox; ; if (oCmbo != null && formloaded) { dataGridView1.Rows.Clear(); cmbLotNo.SelectedValue = 0; using (var context = new TTI2Entities()) { var selectedRecord = (TLADM_CottonContracts)oCmbo.SelectedItem; if (selectedRecord != null) { IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>(); dataGridView1.Rows.Clear(); var existing = context.SelectCottonRecords1(selectedRecord.CottonCon_Pk, selectedRecord.CottonCon_ConSupplier_FK); foreach (var row in existing) { TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions(); cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk; cr.cotrx_Customer_FK = row.cotrx_Customer_FK; cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight; cr.cotrx_GrossWeight = row.cotrx_GrossWeight; cr.cotrx_LotNo = row.cotrx_LotNo; cr.cotrx_NettPerWB = row.cotrx_NettPerWB; cr.cotrx_NetWeight = row.cotrx_NetWeight; cr.cotrx_NoBales = row.cotrx_NoBales; cr.cotrx_Notes = row.cotrx_Notes; cr.cotrx_pk = row.cotrx_pk; cr.cotrx_Return_No = row.cotrx_Return_No; cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK; cr.cotrx_TransDate = row.cotrx_TransDate; cr.cotrx_TranType = row.cotrx_TranType; cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty; cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull; cr.cotrx_WriteOff = row.cotrx_WriteOff; cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight; cotreceived.Add(cr); } cmbLotNo.DataSource = cotreceived.ToList(); //cmbLotNo.DataSource = context.TLSPN_CottonReceived.Where(x => x.CotRec_Contract_FK == selectedRecord.CottonCon_Pk).ToList(); cmbLotNo.ValueMember = "cotrx_LotNo"; cmbLotNo.DisplayMember = "cotrx_LotNo"; 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; } } } } }
public frmCottonBalesInStock() { InitializeComponent(); using (var context = new TTI2Entities()) { var existing = context.AltSelectCottonRecords().OrderBy(x => x.cotrx_LotNo).ToList(); foreach (var row in existing) { cotreceived = new TLSPN_CottonTransactions(); cotreceived.cotrx_pk = row.cotrx_pk; cotreceived.cotrx_LotNo = row.cotrx_LotNo; comboLotNo.Items.Add(cotreceived); } comboLotNo.ValueMember = "cotrx_LotNo"; comboLotNo.DisplayMember = "cotrx_LotNo"; } }
private void button1_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); frmCottonBales cb = new frmCottonBales(cotTrans); cb.ShowDialog(this); } }
private void btnSave_Click(object sender, EventArgs e) { bool success = true; Button oBtn = sender as Button; TLSPN_CottonReceivedBales bales; TLADM_TranactionType trantypes = new TLADM_TranactionType(); if (oBtn != null) { var cnt = RowsSelected.Where(x => x == false).Count(); if (cnt == RowsSelected.Count()) { MessageBox.Show("Please select at least one row from the grid as shown"); return; } var errorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM); return; } var CottonContract = (TLADM_CottonContracts)cmbContractNo.SelectedItem; var CottonTrans = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; var Supplier = (TLADM_Cotton)cmbSupplierDetails.SelectedItem; //Dont forget last number used //---------------------------------------------- using (var context = new TTI2Entities()) { //Hard Coded at the moment // See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department //-------------------------------------------------------------------------------------------------- var DeptDetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); if (DeptDetails != null) { trantypes = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 200 && x.TrxT_Department_FK == DeptDetails.Dep_Id).FirstOrDefault(); } var Haulier = (TLADM_CottonHauliers)cmbTransporter.SelectedItem; var TransDet = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; int noBales = 0; //------------------------------------------------------------------------------------------- // Up date the records from DataGridView....If Not in Edit Mode //-------------------------------------------------- if (!_EditMode) { var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col2 += 1; } foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false) { continue; } bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { if ((bool)row.Cells[1].Value == true) { bales.CoBales_CottonReturned = true; bales.CoBales_CottonSequence = Convert.ToInt32(txtReturnNoteNumber.Text); noBales += 1; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } } } } else { foreach (DataGridViewRow row in dataGridView1.Rows) { if ((bool)row.Cells[1].Value == false) { bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { bales.CoBales_CottonReturned = false; bales.CoBales_CottonSequence = 0; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } } else { noBales += 1; } } } //---------------------------------------------------------------- // Now onto the main transaction // Edit Mode plays a role!!!!! //------------------------------------------------------------------- TLSPN_CottonTransactions CTS = new TLSPN_CottonTransactions(); if (_EditMode) { var prev = (TLSPN_CottonTransactions)cmbPrevious.SelectedItem; if (prev != null) { CTS = context.TLSPN_CottonTransactions.Find(prev.cotrx_pk); } } //------------------------------------------------------------------ CTS.cotrx_ContractNo_Fk = CottonContract.CottonCon_Pk; CTS.cotrx_Customer_FK = null; CTS.cotrx_GrossAveBaleWeight = (Convert.ToDecimal(txtGrossWeightReturned.Text) / noBales); CTS.cotrx_GrossWeight = Convert.ToDecimal(txtGrossWeightReturned.Text); CTS.cotrx_LotNo = TransDet.cotrx_LotNo; CTS.cotrx_NetWeight = Convert.ToDecimal(txtNettWeightReturned.Text); CTS.cotrx_NoBales = noBales; CTS.cotrx_Notes = string.Empty; CTS.cotrx_Haulier_FK = Haulier.Haul_Pk; CTS.cotrx_Return_No = Convert.ToInt32(txtReturnNoteNumber.Text); CTS.cotrx_Supplier_FK = Supplier.Cotton_Pk; CTS.cotrx_TransDate = dtpDateReturned.Value; CTS.cotrx_TranType = trantypes.TrxT_Pk; CTS.cotrx_VehReg = txtVehReg.Text; CTS.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeEmpty.Text); CTS.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeFull.Text); CTS.cotrx_WriteOff = true; CTS.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNettWeightReturned.Text) / noBales; CTS.cotrx_NettPerWB = CTS.cotrx_WeighBridgeFull - CTS.cotrx_WeighBridgeEmpty; //---------------------------------------------------------------------------------- if (!_EditMode) { context.TLSPN_CottonTransactions.Add(CTS); } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } //---------------------------------------------------------------------- } if (success) { MessageBox.Show("Records stored to database successfully"); var ReturnNo = Convert.ToInt32(txtReturnNoteNumber.Text); frmViewReport vRep = new frmViewReport(3, ReturnNo); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); SetUp(); } } }
//------------------------------------------------------------------------------------------------- public frmCottonBales(TLSPN_CottonTransactions cts) { InitializeComponent(); _CTrns = cts; SetUp(); }
private void btnSave_Click(object sender, EventArgs e) { TLSPN_CottonReceivedBales bales; Button oBtn = sender as Button; if (oBtn != null & formloaded) { if (RowsSelected != null && rbWriteOff.Checked) { var cnt = RowsSelected.Where(x => x == false).Count(); if (cnt == RowsSelected.Count()) { MessageBox.Show("Please select at least one row from the grid as shown"); return; } } var errorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM); return; } var LotDetails = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; //dont forget last number used //------------------------------------------- using (var context = new TTI2Entities()) { var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col3 += 1; } // 0 // 1 Selected // 2 Bales Numeric // 3 MIC Decimal // 4 kgs (NETT) Decimal // 5 Staple Decimal // 6 kgs (GROSS) decimal int NoBales = 0; decimal NettMass = 0M; decimal GrossMass = 0M; var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false) { continue; } NoBales += 1; NettMass += (decimal)row.Cells[4].Value; GrossMass += (decimal)row.Cells[6].Value; if (rbWriteOn.Checked) { TLSPN_CottonReceivedBales Bales = new TLSPN_CottonReceivedBales(); Bales.CotBales_BaleNo = (int)row.Cells[2].Value; Bales.CotBales_Mic = (decimal)row.Cells[3].Value; Bales.CotBales_Staple = (decimal)row.Cells[5].Value; Bales.CotBales_Weight_Nett = (decimal)row.Cells[4].Value; Bales.CotBales_LotNo = LotDetails.cotrx_LotNo; Bales.CotBales_Weight_Gross = (decimal)row.Cells[6].Value; Bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text); context.TLSPN_CottonReceivedBales.Add(Bales); } else { bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { if ((bool)row.Cells[1].Value == true) { bales.CoBales_CottonReturned = true; bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text); try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } //---------------------------------------------------------------------------- // //------------------------------------------------------------------------------ TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); cotTrans.cotrx_TransDate = dateTimePicker1.Value; cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk; cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue); cotTrans.cotrx_NetWeight = NettMass; cotTrans.cotrx_GrossWeight = GrossMass; cotTrans.cotrx_NoBales = NoBales; //cotTrans.cotrx_VehReg_FK = null; cotTrans.cotrx_WeighBridgeFull = 0; cotTrans.cotrx_WeighBridgeEmpty = 0; cotTrans.cotrx_NettPerWB = 0; cotTrans.cotrx_Return_No = Convert.ToInt32(txtAdjustmentNumber.Text); cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK; cotTrans.cotrx_Notes = rtbNotes.Text; //------------------------------------------------------------------------- // Consult Table TLADM_TranTypes //---------------------------------------------------------------------------- var DepDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); if (DepDetail != null) { var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 400 && x.TrxT_Department_FK == DepDetail.Dep_Id).FirstOrDefault(); if (Trantype != null) { cotTrans.cotrx_TranType = Trantype.TrxT_Pk; } } if (rbWriteOff.Checked) { cotTrans.cotrx_WriteOff = true; } else { cotTrans.cotrx_WriteOff = false; } //------------------------------------------------------------------------ context.TLSPN_CottonTransactions.Add(cotTrans); //----------------------------------------------------------- // //------------------------------------------------------------ string Mach_IP = Dns.GetHostEntry(Dns.GetHostName()) .AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork) .ToString(); TLADM_DailyLog DailyLog = new TLADM_DailyLog(); DailyLog.TLDL_IPAddress = Mach_IP; DailyLog.TLDL_Dept_Fk = DepDetail.Dep_Id; DailyLog.TLDL_Date = DateTime.Now; DailyLog.TLDL_TransDetail = "Cotton Adjustment"; DailyLog.TLDL_AuthorisedBy = txtAdjustmentNumber.Text; DailyLog.TLDL_Comments = txtAdjustmentNumber.Text; context.TLADM_DailyLog.Add(DailyLog); try { context.SaveChanges(); var Retno = Convert.ToInt32(txtAdjustmentNumber.Text); frmViewReport vRep = new frmViewReport(4, Retno); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); SetUp(); MessageBox.Show("Data saved to database successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; bool success = true; if (oBtn != null) { var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; using (var context = new TTI2Entities()) { //Hard Coded at the moment // See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department //-------------------------------------------------------------------------------------------------- var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 500 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault(); var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col5 += 1; } var NoBales = 0; var GrossWeight = 0M; var NettWeight = 0M; foreach (DataGridViewRow rw in dataGridView1.Rows) { if (rw.Cells[1].Value == null || (bool)rw.Cells[1].Value == false) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)rw.Cells[0].Value); if (bales != null) { bales.CoBales_IssuedToProd = true; bales.CoBales_BlowRoomPosition = 0; bales.CoBales_CottonSequence = Convert.ToInt32(txtIssueToProdNo.Text); NoBales += 1; NettWeight += (decimal)rw.Cells[5].Value; GrossWeight += (decimal)rw.Cells[7].Value; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } } //------------------------------------------------------------------ TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); cotTrans.cotrx_TransDate = dtpTransDate.Value; cotTrans.cotrx_Supplier_FK = CottonRec.cotrx_Supplier_FK; cotTrans.cotrx_Return_No = Convert.ToInt32(txtIssueToProdNo.Text); cotTrans.cotrx_ContractNo_Fk = CottonRec.cotrx_ContractNo_Fk; cotTrans.cotrx_LotNo = CottonRec.cotrx_LotNo; cotTrans.cotrx_NoBales = NoBales; cotTrans.cotrx_GrossWeight = GrossWeight; cotTrans.cotrx_NetWeight = NettWeight; cotTrans.cotrx_WeighBridgeFull = 0M; cotTrans.cotrx_WeighBridgeEmpty = 0M; cotTrans.cotrx_NettPerWB = 0M; cotTrans.cotrx_GrossAveBaleWeight = (GrossWeight / NoBales); cotTrans.cottrx_NettAveBaleWeight = (NettWeight / NoBales); cotTrans.cotrx_TranType = TranType.TrxT_Pk; cotTrans.cotrx_WriteOff = true; //--------------------------------------------- // Need to store this to the laydown file //----------------------------------------------------------- TLSPN_YarnOrderLayDown ld = new TLSPN_YarnOrderLayDown(); ld.YarnLD_BaleAvgWeight = cotTrans.cottrx_NettAveBaleWeight; ld.YarnLD_Date = dtpTransDate.Value; ld.YarnLD_LayDownNo = Convert.ToInt32(txtIssueToProdNo.Text); ld.YarnLD_LotNo = CottonRec.cotrx_LotNo; ld.YarnLD_NoOfBales = NoBales; ld.YarnLD_WeightKg = NettWeight; try { context.TLSPN_CottonTransactions.Add(cotTrans); context.TLSPN_YarnOrderLayDown.Add(ld); context.SaveChanges(); SetUp(); } catch (Exception ex) { MessageBox.Show(ex.Message); success = false; } } if (success) { MessageBox.Show("Records stored successfully to database"); } } }
void SetUp() { formloaded = false; IndexPos = 0; dataGridView1.Rows.Clear(); using (var context = new TTI2Entities()) { IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>(); var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { txtIssueToProdNo.Text = LastNumber.col5.ToString(); } var existing = context.AltSelectCottonRecords().ToList(); foreach (var row in existing) { TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions(); cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk; cr.cotrx_Customer_FK = row.cotrx_Customer_FK; cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight; cr.cotrx_GrossWeight = row.cotrx_GrossWeight; cr.cotrx_LotNo = row.cotrx_LotNo; cr.cotrx_NettPerWB = row.cotrx_NettPerWB; cr.cotrx_NetWeight = row.cotrx_NetWeight; cr.cotrx_NoBales = row.cotrx_NoBales; cr.cotrx_Notes = row.cotrx_Notes; cr.cotrx_pk = row.cotrx_pk; cr.cotrx_Return_No = row.cotrx_Return_No; cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK; cr.cotrx_TransDate = row.cotrx_TransDate; cr.cotrx_TranType = row.cotrx_TranType; //cr.cotrx_VehReg_FK = row.cotrx_VehReg_FK; cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty; cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull; cr.cotrx_WriteOff = row.cotrx_WriteOff; cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight; cotreceived.Add(cr); } cmbLotNo.DataSource = cotreceived.OrderBy(x => x.cotrx_LotNo).ToList(); cmbLotNo.ValueMember = "cotrx_LotNo"; cmbLotNo.DisplayMember = "cotrx_LotNo"; cmbLotNo.SelectedValue = -1; } oChk = new DataGridViewCheckBoxColumn(); //1 oChk.HeaderText = "Select"; oChk.ValueType = typeof(Boolean); oTxtBoxA = new DataGridViewTextBoxColumn(); oTxtBoxA.Visible = false; oTxtBoxB = new DataGridViewTextBoxColumn(); //2 oTxtBoxB.HeaderText = "Lay down position"; oTxtBoxB.ValueType = typeof(int); oTxtBoxB.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxB.Width = 50; oTxtBoxC = new DataGridViewTextBoxColumn(); //3 oTxtBoxC.HeaderText = "Bale No"; oTxtBoxC.ValueType = typeof(int); oTxtBoxC.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxC.ReadOnly = true; oTxtBoxD = new DataGridViewTextBoxColumn(); //4 oTxtBoxD.HeaderText = "Mic"; oTxtBoxD.ValueType = typeof(Decimal); oTxtBoxD.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxD.ReadOnly = true; oTxtBoxE = new DataGridViewTextBoxColumn(); //5 oTxtBoxE.HeaderText = "Kgs (NETT)"; oTxtBoxE.ValueType = typeof(Decimal); oTxtBoxE.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxE.ReadOnly = true; oTxtBoxF = new DataGridViewTextBoxColumn(); //6 oTxtBoxF.HeaderText = "Staple"; oTxtBoxF.ValueType = typeof(Decimal); oTxtBoxF.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxF.ReadOnly = true; oTxtBoxG = new DataGridViewTextBoxColumn(); //7 oTxtBoxG.HeaderText = "Kgs (GROSS)"; oTxtBoxG.ValueType = typeof(Decimal); oTxtBoxG.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxG.ReadOnly = true; oTxtBoxH = new DataGridViewTextBoxColumn(); //7 oTxtBoxH.HeaderText = "Lot No"; oTxtBoxH.ValueType = typeof(string); oTxtBoxH.ReadOnly = true; dataGridView1.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dataGridView1_EditingControlShowing); dataGridView1.Columns.Add(oTxtBoxA); // 0 Index Pk value dataGridView1.Columns.Add(oChk); // 1 Selected dataGridView1.Columns.Add(oTxtBoxB); // 2 Lay Down Position dataGridView1.Columns.Add(oTxtBoxC); // 3 Bales Numeric dataGridView1.Columns.Add(oTxtBoxD); // 4 MIC Decimal dataGridView1.Columns.Add(oTxtBoxE); // 5 kgs (NETT) Decimal dataGridView1.Columns.Add(oTxtBoxF); // 6 Staple Decimal dataGridView1.Columns.Add(oTxtBoxG); // 7 Kgs S(GROSS) Decimal dataGridView1.Columns.Add(oTxtBoxH); // 8 Lot No formloaded = true; }
private void cmbPrevious_SelectedIndexChanged(object sender, EventArgs e) { ComboBox oCmbo = sender as ComboBox; if (oCmbo != null) { var CTS = (TLSPN_CottonTransactions)oCmbo.SelectedItem; if (CTS != null) { txtDeliveryNo.Text = CTS.cotrx_Return_No.ToString(); txtCustOrderNo.Text = CTS.cotrx_Notes; cmbCustomerName.SelectedValue = CTS.cotrx_Customer_FK; cmbContractNo.SelectedValue = CTS.cotrx_ContractNo_Fk; dtpDateDelivered.Value = CTS.cotrx_TransDate; using (var context = new TTI2Entities()) { var cust = context.TLADM_CustomerFile.Where(x => x.Cust_Pk == CTS.cotrx_Customer_FK).FirstOrDefault(); if (cust != null) { rtbCustomerAddress.Text = cust.Cust_Address1; } IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>(); var existing = context.SelectCottonRecords1(CTS.cotrx_ContractNo_Fk, CTS.cotrx_Supplier_FK).ToList(); if (existing != null) { foreach (var row in existing) { TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions(); cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk; cr.cotrx_Customer_FK = row.cotrx_Customer_FK; cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight; cr.cotrx_GrossWeight = row.cotrx_GrossWeight; cr.cotrx_LotNo = row.cotrx_LotNo; cr.cotrx_NettPerWB = row.cotrx_NettPerWB; cr.cotrx_NetWeight = row.cotrx_NetWeight; cr.cotrx_NoBales = row.cotrx_NoBales; cr.cotrx_Notes = row.cotrx_Notes; cr.cotrx_pk = row.cotrx_pk; cr.cotrx_Return_No = row.cotrx_Return_No; cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK; cr.cotrx_TransDate = row.cotrx_TransDate; cr.cotrx_TranType = row.cotrx_TranType; cr.cotrx_VehReg = row.cotrx_VehReg; cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty; cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull; cr.cotrx_WriteOff = row.cotrx_WriteOff; cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight; cotreceived.Add(cr); } cmbLotNo.DataSource = cotreceived; cmbLotNo.DisplayMember = "Cotrx_LotNo"; cmbLotNo.ValueMember = "Cotrx_LotNo"; } cmbLotNo.SelectedValue = CTS.cotrx_LotNo; } comboTransporter.SelectedValue = CTS.cotrx_Haulier_FK; txtVehReg.Text = CTS.cotrx_VehReg; txtWeighBridgeFull.Text = Math.Round(CTS.cotrx_WeighBridgeFull, 1).ToString(); txtWeighBridgeEmpty.Text = Math.Round(CTS.cotrx_WeighBridgeEmpty, 1).ToString(); } } }
private void btnSave_Click(object sender, EventArgs e) { Button oBtn = sender as Button; if (oBtn != null && formloaded) { var errorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(errorM)) { MessageBox.Show(errorM); return; } var cnt = RowsSelected.Where(x => x == false).Count(); if (cnt == RowsSelected.Count()) { MessageBox.Show("Please select at least one row from the grid as shown"); return; } var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem; var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem; var CustomerDetails = (TLADM_CustomerFile)cmbCustomerName.SelectedItem; //Dont forget last number used //---------------------------------------------- using (var context = new TTI2Entities()) { //Hard Coded at the moment // See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department //-------------------------------------------------------------------------------------------------- var SequenceNo = Convert.ToInt32(txtDeliveryNo.Text); var LastNumber = context.TLADM_LastNumberUsed.Find(1); if (LastNumber != null) { LastNumber.col4 += 1; } // 0 // 1 Selected // 2 Bales Numeric // 3 MIC Decimal // 4 kgs Decimal // 5 Staple Decimal int NoBales = 0; decimal Mass = 0.00M; decimal Gross = 0.00M; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false) { continue; } TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value); if (bales != null) { bales.CoBales_CottonSold = true; bales.CoBales_CottonSequence = SequenceNo; NoBales += 1; Mass += (decimal)row.Cells[4].Value; Gross += (decimal)row.Cells[6].Value; try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions(); var haul = (TLADM_CottonHauliers)comboTransporter.SelectedItem; cotTrans.cotrx_TransDate = dtpDateDelivered.Value; cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk; cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue); cotTrans.cotrx_NetWeight = Mass; cotTrans.cotrx_GrossWeight = Mass; cotTrans.cotrx_NoBales = NoBales; cotTrans.cotrx_Haulier_FK = haul.Haul_Pk; cotTrans.cotrx_VehReg = txtVehReg.Text; cotTrans.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeFull.Text); cotTrans.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeEmpty.Text); cotTrans.cotrx_NettPerWB = cotTrans.cotrx_WeighBridgeFull - cotTrans.cotrx_WeighBridgeEmpty; cotTrans.cottrx_NettAveBaleWeight = Mass / NoBales; cotTrans.cotrx_GrossAveBaleWeight = Gross / NoBales; cotTrans.cotrx_Return_No = SequenceNo; cotTrans.cotrx_Customer_FK = CustomerDetails.Cust_Pk; cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK; cotTrans.cotrx_Notes = txtCustOrderNo.Text; cotTrans.cotrx_WriteOff = true; //------------------------------------------------------------------------- // Consult Table TLADM_TranTypes //---------------------------------------------------------------------------- var DeptDetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 300 && x.TrxT_Department_FK == DeptDetails.Dep_Id).FirstOrDefault(); if (Trantype != null) { cotTrans.cotrx_TranType = Trantype.TrxT_Pk; } try { if (!_EditMode) { context.TLSPN_CottonTransactions.Add(cotTrans); } context.SaveChanges(); Setup(); frmViewReport vRep = new frmViewReport(5, SequenceNo); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); MessageBox.Show("Data saved to database successfully"); btnPickList.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } } btnSave.Enabled = false; } }
private void btnSave_Click(object sender, EventArgs e) { bool success = true; Button oBtn = sender as Button; if (oBtn != null && formloaded) { var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields); if (!string.IsNullOrEmpty(ErrorM)) { MessageBox.Show(ErrorM); return; } using (var context = new TTI2Entities()) { TLSPN_CottonReceived cotrec = new TLSPN_CottonReceived(); var Contract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem; var Supplier = (TLADM_Cotton)cmbCottonSuppliers.SelectedItem; var Haulier = (TLADM_CottonHauliers)cmbHaulier.SelectedItem; var NoOfBales = Convert.ToInt32(txtNoOfBales.Text); //--------------------------------------------------------------------------------------------------- //Unfortunately hard coded at the moment //-------------------------------------------------------------------------------------------------- var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault(); var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 100 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault(); if (TranType != null) { cotrec.CotReC_TranType_FK = TranType.TrxT_Pk; var CountTrx = context.TLSPN_CottonTransactions.Count(); if (CountTrx == 0) { //-------------------------------------------- //this means that this transaction is being run for the first time ie add a record of zeros to the Opening Balance table // This table will cater for future yearend //-------------------------------------------------------------------------------- TLSPN_OpenBalance openBal = new TLSPN_OpenBalance(); openBal.OpenBal_Store_FK = (int)TranType.TrxT_FromWhse_FK; openBal.OpenBal_GrossBaleWeight = 0M; openBal.OpenBal_NettBaleWeight = 0M; openBal.OpenBal_NoOfBales = 0; context.TLSPN_OpenBalance.Add(openBal); } } //---------------------------------------------------------------- // Now onto the main transaction //------------------------------------------------------------------- TLSPN_CottonTransactions CTS = new TLSPN_CottonTransactions(); CTS.cotrx_ContractNo_Fk = Contract.CottonCon_Pk; CTS.cotrx_Customer_FK = null; CTS.cotrx_GrossWeight = Convert.ToDecimal(txtSuppplierGrossWeight.Text); CTS.cotrx_LotNo = Convert.ToInt32(txtLotNo.Text); CTS.cotrx_NettPerWB = Convert.ToDecimal(txtCottonNettWeight.Text); CTS.cotrx_NetWeight = Convert.ToDecimal(txtSupplierNettWeight.Text); CTS.cotrx_NoBales = NoOfBales; CTS.cotrx_Notes = string.Empty; CTS.cotrx_Return_No = Convert.ToInt32(txtGrnNumber.Text); CTS.cotrx_Supplier_FK = Supplier.Cotton_Pk; CTS.cotrx_TransDate = dtpDateReceived.Value; CTS.cotrx_TranType = TranType.TrxT_Pk; CTS.cotrx_VehReg = txtVehReg.Text; CTS.cotrx_Haulier_FK = Haulier.Haul_Pk; CTS.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeNett.Text); CTS.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeGross.Text); CTS.cotrx_WriteOff = false; CTS.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNetAvgBaleWeight.Text); CTS.cotrx_GrossAveBaleWeight = Convert.ToDecimal(txtGrossAvgBaleWeight.Text); context.TLSPN_CottonTransactions.Add(CTS); //-------------------------------------------------------------------------------- var lastNumber = context.TLADM_LastNumberUsed.Find(1); if (lastNumber != null) { lastNumber.col1 += 1; lastNumber.col12 += 1; } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (microAvailNo.Checked) { decimal micraFrom = 0.00M; decimal micraTo = 0.00M; decimal micraAvg = 0.00M; decimal staplefrom = 0.00M; decimal stapleto = 0.00M; decimal stapleAvg = 0.00M; var CottonContract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem; if (CottonContract != null) { micraFrom = CottonContract.CottonCon_MicraFrom; micraTo = CottonContract.CottonCon_MicraTo; staplefrom = CottonContract.CottonCon_StapleFrom; stapleto = CottonContract.CottonCon_StapleTo; if (micraFrom > 0 && micraTo > 0) { micraAvg = (micraFrom + micraTo) / 2; } else { micraAvg = 1; } if (staplefrom != 0 && stapleto != 0) { stapleAvg = (staplefrom + stapleto) / 2; } else { stapleAvg = 1; } } var n = 0; while (++n <= CTS.cotrx_NoBales) { TLSPN_CottonReceivedBales recBales = new TLSPN_CottonReceivedBales(); recBales.CotBales_BaleNo = n; recBales.CotBales_CotReceived_FK = cotrec.CotRec_Pk; recBales.CotBales_LotNo = Convert.ToInt32(txtLotNo.Text); recBales.CotBales_Mic = micraAvg; recBales.CotBales_Staple = stapleAvg; recBales.CotBales_Weight_Gross = Convert.ToDecimal(txtGrossAvgBaleWeight.Text); recBales.CotBales_Weight_Nett = Convert.ToDecimal(txtNetAvgBaleWeight.Text); recBales.CoBales_CottonSequence = Convert.ToInt32(txtGrnNumber.Text); context.TLSPN_CottonReceivedBales.Add(recBales); try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } if (success) { MessageBox.Show("Data stored to the database successfully"); int returnno = Convert.ToInt32(txtGrnNumber.Text); frmViewReport vRep = new frmViewReport(2, returnno); int h = Screen.PrimaryScreen.WorkingArea.Height; int w = Screen.PrimaryScreen.WorkingArea.Width; vRep.ClientSize = new Size(w, h); vRep.ShowDialog(this); MandSelected = core.PopulateArray(MandatoryFields.Length, false); Setup(); } } }
void SetUp() { using (var context = new TTI2Entities()) { IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>(); var existing = context.AltSelectCottonRecords().ToList(); foreach (var row in existing) { TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions(); cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk; cr.cotrx_Customer_FK = row.cotrx_Customer_FK; cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight; cr.cotrx_GrossWeight = row.cotrx_GrossWeight; cr.cotrx_LotNo = row.cotrx_LotNo; cr.cotrx_NettPerWB = row.cotrx_NettPerWB; cr.cotrx_NetWeight = row.cotrx_NetWeight; cr.cotrx_NoBales = row.cotrx_NoBales; cr.cotrx_Notes = row.cotrx_Notes; cr.cotrx_pk = row.cotrx_pk; cr.cotrx_Return_No = row.cotrx_Return_No; cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK; cr.cotrx_TransDate = row.cotrx_TransDate; cr.cotrx_TranType = row.cotrx_TranType; //cr.cotrx_VehReg_FK = row.cotrx_VehReg_FK; cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty; cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull; cr.cotrx_WriteOff = row.cotrx_WriteOff; cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight; cotreceived.Add(cr); } cmbLotNo.DataSource = cotreceived.OrderBy(x => x.cotrx_LotNo).ToList(); cmbLotNo.ValueMember = "cotrx_LotNo"; cmbLotNo.DisplayMember = "cotrx_LotNo"; cmbLotNo.SelectedValue = 0; oChk = new DataGridViewCheckBoxColumn(); //1 oChk.HeaderText = "Confirmed"; oChk.ValueType = typeof(Boolean); oTxtBoxA = new DataGridViewTextBoxColumn(); oTxtBoxA.Visible = false; oTxtBoxC = new DataGridViewTextBoxColumn(); //3 oTxtBoxC.HeaderText = "Bale No"; oTxtBoxC.ValueType = typeof(int); oTxtBoxC.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxC.ReadOnly = true; oTxtBoxD = new DataGridViewTextBoxColumn(); //4 oTxtBoxD.HeaderText = "Mic"; oTxtBoxD.ValueType = typeof(Decimal); oTxtBoxD.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxD.ReadOnly = true; oTxtBoxE = new DataGridViewTextBoxColumn(); //5 oTxtBoxE.HeaderText = "Kgs (NETT)"; oTxtBoxE.ValueType = typeof(Decimal); oTxtBoxE.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxE.ReadOnly = true; oTxtBoxF = new DataGridViewTextBoxColumn(); //6 oTxtBoxF.HeaderText = "Staple"; oTxtBoxF.ValueType = typeof(Decimal); oTxtBoxF.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxF.ReadOnly = true; oTxtBoxG = new DataGridViewTextBoxColumn(); //6 oTxtBoxG.HeaderText = "Kgs (GROSS)"; oTxtBoxG.ValueType = typeof(Decimal); oTxtBoxG.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; oTxtBoxG.ReadOnly = true; oTxtBoxG.Visible = false; dataGridView1.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dataGridView1_EditingControlShowing); dataGridView1.Columns.Add(oTxtBoxA); // 0 Index Pk value dataGridView1.Columns.Add(oChk); // 1 Selected dataGridView1.Columns.Add(oTxtBoxC); // 2 Bales Numeric dataGridView1.Columns.Add(oTxtBoxD); // 3 MIC Decimal dataGridView1.Columns.Add(oTxtBoxE); // 4 kgs (NETT) Decimal dataGridView1.Columns.Add(oTxtBoxF); // 5 Staple Decimal dataGridView1.Columns.Add(oTxtBoxG); // 6 Kgs Gross formloaded = true; groupBox1.Enabled = false; } }