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; } } } } }
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(); } } }