void PopulateItems()
{
string sItemNo = txtItemNo.Text.Trim();
int iTM01_PRODUCTID = 0;
if (!string.IsNullOrEmpty(cmbItemName.Text.Trim()))
{
int.TryParse(cmbItemName.SelectedValue.ToString(), out iTM01_PRODUCTID);
if (iTM01_PRODUCTID > 0)
{
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_IDResult> lst = new List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_IDResult>();
lst = MyDa.USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_ID(iTM01_PRODUCTID.ToString()).ToList();
if (lst != null && lst.Count > 0)
{
dgItems.DataSource = lst;
//lblItemName.Text = lst[0].TM01_NAME.ToString();
dgItems.Columns["TM01_NAME"].Visible = false;
dgItems.Columns["TM01_TAX_RATE"].Visible = false;
dgItems.Columns["T006_STOCK"].HeaderText = "Stock";
dgItems.Columns["TM01_NAME"].HeaderText = "Item";
dgItems.Columns["TM02_SIZE"].HeaderText = "Finish";
dgItems.Columns["TM02_PRICE"].HeaderText = "Price";
dgItems.Columns["QTY"].HeaderText = "Qty";
dgItems.Columns["TM02_SIZE"].DisplayIndex = 1;
dgItems.Columns["T006_STOCK"].DisplayIndex = 2;
dgItems.Columns["TM02_PRICE"].DisplayIndex = 3;
dgItems.Columns["QTY"].DisplayIndex = 4;
dgItems.Columns["TM02_SIZE"].ReadOnly = true;
dgItems.Columns["T006_STOCK"].ReadOnly = true;
dgItems.Columns["TM01_PRODUCTID"].Visible = false;
dgItems.Columns["TM02_PRODUCTSIZEID"].Visible = false;
this.dgItems.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgItems.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
dgItems.EnableHeadersVisualStyles = false;
this.dgItems.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgItems.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dgItems.ColumnHeadersHeight = 30;
dgItems.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dgItems.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
dgItems.Columns["TM01_NAME"].Width = 350;
dgItems.Columns["TM02_SIZE"].Width = 120;
dgItems.Columns["T006_STOCK"].Width = 120;
dgItems.Columns["QTY"].Width = 150;
}
else
{
cmbItemName.Text = "";
Datalayer.InformationMessageBox(sItemNo + " not exist");
}
}
else
{
dgItems.DataSource = null;
}
}
else
{
dgItems.DataSource = null;
}
}
