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