private void ReBindGrid() { if (Session["WeeklySMVSummary"] == null) { return; } WeeklySMVSummaryRedGrid.DataSource = (List <WeeklySmvSummariesModel>)Session["WeeklySMVSummary"]; WeeklySMVSummaryRedGrid.DataBind(); }
private void PopulateDataGrid() { dvEmptyContent.Visible = false; dvDataContent.Visible = false; dvNoSearchResult.Visible = false; var startYear = ddlYear.SelectedItem.Value; if (string.IsNullOrWhiteSpace(startYear)) { startYear = Convert.ToString(DateTime.Now.Year); } var startMonth = ddlMonth.SelectedItem.Value; if (string.IsNullOrWhiteSpace(startMonth)) { startMonth = Convert.ToString(DateTime.Now.Month); } using ( var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { connection.Open(); var spResult = connection.Query <WeeklySmvSummariesModel>( string.Format("EXEC [dbo].[SPC_GetWeeklySummariesForSMV] {0}, {1}", startMonth, startYear)).ToList(); if (spResult.Count < 1) { dvEmptyContent.Visible = true; connection.Close(); return; } WeeklySMVSummaryRedGrid.AllowPaging = (spResult.Count > WeeklySMVSummaryRedGrid.PageSize); WeeklySMVSummaryRedGrid.DataSource = spResult; WeeklySMVSummaryRedGrid.DataBind(); Session["WeeklySMVSummary"] = spResult; dvDataContent.Visible = true; } //var daysTillMonday = (int)DateTime.Today.DayOfWeek - (int)DayOfWeek.Monday; //var monday = DateTime.Today.AddDays(-daysTillMonday); //if (ddlMonth.SelectedIndex <= -1 || ddlYear.SelectedIndex <= -1) return; //var dt = new DateTime(int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), 1); //dt = dt.AddDays(1); //var searchText = txtSearch.Text.ToLower().Trim(); //var objProductionCapacity = new WeeklyProductionCapacityBO(); //var lstProductionCapacity = new List<WeeklyProductionCapacityBO>(); //if ((searchText != string.Empty) && (searchText != "search")) //{ // lstProductionCapacity = // (from o in // objProductionCapacity.SearchObjects() // .AsQueryable() // .Where( // o => // o.WeekendDate >= monday && // o.WeekendDate.ToString(CultureInfo.InvariantCulture).Contains(searchText)) // .OrderBy(SortExpression).ToList() // select o).ToList(); //} //else //{ // if (ddlYear.SelectedIndex > -1) // { // if (int.Parse(ddlMonth.SelectedValue) == DateTime.Now.Month) // { // lstProductionCapacity = // objProductionCapacity.SearchObjects() // .AsQueryable() // .Where( // o => // o.WeekendDate >= monday && // o.WeekendDate.Year >= int.Parse(ddlYear.SelectedItem.Text)) // .OrderBy(SortExpression) // .ToList(); // } // } // else if (ddlYear.SelectedIndex == -1) // { // lstProductionCapacity = // objProductionCapacity.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList(); // } // else // { // lstProductionCapacity = // objProductionCapacity.SearchObjects() // .AsQueryable() // .Where(o => o.WeekendDate.Date >= monday) // .OrderBy(SortExpression) // .ToList(); // } //} //if (ddlMonth.SelectedIndex > -1) //{ // if (int.Parse(ddlMonth.SelectedValue) != DateTime.Now.Month) // { // lstProductionCapacity = // objProductionCapacity.SearchObjects() // .AsQueryable() // .Where(o => o.WeekendDate >= dt) // .OrderBy(o => o.WeekendDate) // .ToList(); // } //} //else if (ddlMonth.SelectedIndex == -1) //{ // lstProductionCapacity = lstProductionCapacity.ToList(); //} //if (lstProductionCapacity.Count > 0) //{ // WeeklySMVSummaryRedGrid.AllowPaging = (lstProductionCapacity.Count > // WeeklySMVSummaryRedGrid.PageSize); // WeeklySMVSummaryRedGrid.DataSource = lstProductionCapacity; // WeeklySMVSummaryRedGrid.DataBind(); // Session["WeeklySMVSummary"] = lstProductionCapacity; // dvDataContent.Visible = true; //} //else if ((searchText != string.Empty && searchText != "search") || (ddlYear.SelectedIndex > -1) || // (ddlMonth.SelectedIndex > -1)) //{ // lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty); // dvDataContent.Visible = true; // dvNoSearchResult.Visible = true; //} //else //{ // dvEmptyContent.Visible = true; //} //WeeklySMVSummaryRedGrid.Visible = (lstProductionCapacity.Count > 0); }