private void PopulateGrid(string startDate = null, string endDate = null)
{
List <WeeklyBackordersSummaryModel> data;
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
if (!string.IsNullOrWhiteSpace(endDate) && !string.IsNullOrWhiteSpace(startDate))
{
data = connection.Query <WeeklyBackordersSummaryModel>(string.Format("EXEC [dbo].[SPC_GetBackOrdersWeeklySummary" +
"] '{0}', '{1}'", startDate, endDate)).ToList();
}
else if (!string.IsNullOrWhiteSpace(startDate))
{
data = connection.Query <WeeklyBackordersSummaryModel>(string.Format("EXEC [dbo].[SPC_GetBackOrdersWeeklySummary] '{0}'", startDate)).ToList();
}
else
{
data = connection.Query <WeeklyBackordersSummaryModel>(string.Format("EXEC [dbo].[SPC_GetBackOrdersWeeklySummary]")).ToList();
}
}
if (data.Count < 1)
{
dvEmptyContent.Visible = true;
dvDataContent.Visible = false;
}
else
{
dvDataContent.Visible = true;
SummariesGrid.DataSource = data;
SummariesGrid.DataBind();
Session["WeeklySummaryBackOrders"] = data;
}
}
private void RebindGrid()
{
if (Session["WeeklySummaryBackOrders"] == null)
{
return;
}
SummariesGrid.DataSource = (List <WeeklyBackordersSummaryModel>)Session["PatternDetailsView"];
SummariesGrid.DataBind();
}
