private void BindWeeks() { DataSet dsGrp = new DataSet(); Whitfieldcore wUser = new Whitfieldcore(); DataSet ds = wUser.GetWeeks(); ddlWeek.DataSource = ds; //[week_number],[week_name]week_name ddlWeek.DataTextField = "week_name"; ddlWeek.DataValueField = "week_name"; ddlWeek.DataBind(); ddlWeek.Items.Insert(0, common.AddItemToList("Select Week", "0")); }
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()); } }