void PopualteData()
{
string T001_ACCOUNTID = "";
int iT001_ACCOUNTID = 0;
if (!string.IsNullOrEmpty(cmbAccount.Text.Trim()))
{
int.TryParse(cmbAccount.SelectedValue.ToString(), out iT001_ACCOUNTID);
}
if (iT001_ACCOUNTID > 0)
{
T001_ACCOUNTID = iT001_ACCOUNTID.ToString();
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
List <USP_VP_GET_ORDERResult> lst = new List <USP_VP_GET_ORDERResult>();
lst = MyDa.USP_VP_GET_ORDER(null, T001_ACCOUNTID, null, null, Datalayer.iT001_COMPANYID.ToString()).ToList();
dgDisplayData.DataSource = lst;
dgDisplayData.Columns["T004_ORDERID"].Visible = false;
dgDisplayData.Columns["T001_ACCOUNTID"].Visible = false;
dgDisplayData.Columns["TM01_PRODUCTID"].Visible = false;
dgDisplayData.Columns["TM02_PRODUCTSIZEID"].Visible = false;
dgDisplayData.Columns["T001_NAME"].Visible = false;
dgDisplayData.Columns["T001_MOBILE1"].Visible = false;
dgDisplayData.Columns["T004_DATE"].HeaderText = "Date";
dgDisplayData.Columns["T004_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy";
dgDisplayData.Columns["TM01_NAME"].HeaderText = "ITEM";
dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Finish";
dgDisplayData.Columns["T004_QTY"].HeaderText = "Qty";
dgDisplayData.Columns["T004_IS_URGENT"].HeaderText = "Urgent";
dgDisplayData.Columns["T004_DETAILS"].HeaderText = "Details";
dgDisplayData.Columns["TM01_NO"].HeaderText = "No";
dgDisplayData.Columns["T004_DATE"].DisplayIndex = 1;
dgDisplayData.Columns["TM01_NO"].DisplayIndex = 2;
dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 3;
dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 4;
dgDisplayData.Columns["T004_QTY"].DisplayIndex = 5;
dgDisplayData.Columns["T004_IS_URGENT"].DisplayIndex = 6;
dgDisplayData.Columns["T004_DETAILS"].DisplayIndex = 7;
this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
dgDisplayData.EnableHeadersVisualStyles = false;
this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
// dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White;
dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dgDisplayData.ColumnHeadersHeight = 30;
dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
dgDisplayData.Columns["T004_DATE"].Width = 70;
dgDisplayData.Columns["TM01_NO"].Width = 70;
dgDisplayData.Columns["TM01_NAME"].Width = 120;
dgDisplayData.Columns["TM02_SIZE"].Width = 50;
dgDisplayData.Columns["T004_QTY"].Width = 50;
dgDisplayData.Columns["T004_IS_URGENT"].Width = 50;
dgDisplayData.Columns["T004_DETAILS"].Width = 350;
}
