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";
}
}
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;
}
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;
}
}