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);
}
