private void DisplayProductionSchedule()
{
plSchedule.Controls.Clear();
try
{
whitfield_prod_reports wSchedule = new whitfield_prod_reports();
Whitfieldcore wWeek = new Whitfieldcore();
//Fetch the General week Number for the outer loop
//Fetch the Production schedule Dataset by passing the YEAR, MONTH and Week and bind the DataGrid. Continue for other Weeks.
DataSet dsWeek = wWeek.GetWeeks();
if (dsWeek.Tables[0].Rows.Count > 0)
{
foreach (DataRow dRow in dsWeek.Tables[0].Rows)
{
String _weekName = dRow["week_name"].ToString();
DataSet dsProdSchedule = wSchedule.GetProductionScheduleForDates(ddlMonth.SelectedItem.Value, ddlYear.SelectedItem.Value, _weekName);
Int32 resultCountProd = 0;
if (dsProdSchedule.Tables.Count > 0)
resultCountProd = dsProdSchedule.Tables[0].Rows.Count;
if (resultCountProd > 0)
{
// Label lblTxt = new Label();
// lblTxt.CssClass = "header1";
// lblTxt.Text = _weekName;
DataGrid dGrid = new DataGrid();
dGrid.ID = "grd" + ddlMonth.SelectedItem.Value + ddlYear.SelectedItem.Value + _weekName;
dGrid.HorizontalAlign = HorizontalAlign.Left;
dGrid.CssClass="data";
dGrid.HeaderStyle.Font.Bold=true;
dGrid.HeaderStyle.HorizontalAlign= HorizontalAlign.Center;
dGrid.HeaderStyle.BackColor = System.Drawing.Color.LightBlue;
dGrid.HeaderStyle.CssClass="subnav";
//dGrid.Width=Unit.Pixel(500);
//dGrid.AllowPaging=false;
//dGrid.AutoGenerateColumns=false;
//dGrid.SelectedItemStyle.BackColor=System.Drawing.Color.LightGray;
//dGrid.ShowFooter=true;
dGrid.Caption = _weekName;
dGrid.CaptionAlign = TableCaptionAlign.Left;
dGrid.ItemStyle.Wrap = true;
dGrid.DataSource = dsProdSchedule.Tables[0];
dGrid.DataBind();
//plSchedule.Controls.Add(lblTxt);
plSchedule.Controls.Add(dGrid);
}
}
}
}
catch (Exception exp)
{
Response.Write(exp.Message.ToString());
}
}
