protected void ReportResultView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
SumChart.Visible = false;
ReportResultView.DataSource = ViewState["ReportResultView"] as DataTable;
ReportResultView.PageIndex = e.NewPageIndex;
ReportResultView.DataBind();
// ViewState["ReportResultView"] = ReportResultView.DataSource as DataTable;
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
scriptManager.RegisterPostBackControl(this.ExcelBtn);
if (!IsPostBack)
{
startLabel.Text = DateTime.Now.ToString("dd/MM/yyyy");
endLabel.Text = DateTime.Now.ToString("dd/MM/yyyy");
staCalendar.SelectedDate = DateTime.Today.Date;
endCalendar.SelectedDate = DateTime.Today.Date;
bindGroupList();
bindReportList();
bindTime();
bindmonthlyreport();
if (ViewState["ReportResultView"] != null)
{
ReportResultView.DataSource = ViewState["ReportResultView"] as DataTable;
ReportResultView.DataBind();
}
}
}
private void bindreportgrid()
{
DataTable dt = new DataTable();
if (ReportList.SelectedValue != "-1")
{
errorLabel.Visible = false;
grpPanel.Visible = true;
reportPanel.Visible = true;
ReportResultView.Visible = true;
SumChart.Visible = false;
ExcelBtn.Visible = true;
ReportNameLabel.Text = ReportList.SelectedItem.Text;
int stahrs = Convert.ToInt32(StaTime.SelectedValue);
int endhrs = Convert.ToInt32(EndTime.SelectedValue);
DateTime st_date = staCalendar.SelectedDate.AddHours(stahrs); // Convert.ToDateTime(startLabel.Text);
DateTime end_date = endCalendar.SelectedDate.AddHours(endhrs); //Convert.ToDateTime(endLabel.Text).AddHours(24);
if (end_date < st_date)
{
end_date = st_date;
EndTime.SelectedValue = StaTime.SelectedValue;
}
OracleQuery2 cc2 = new OracleQuery2();
string groupid = GroupList.SelectedValue;
if (ReportList.SelectedValue == "1")
{
dt = cc2.LoadAllSMSReport(st_date, end_date, groupid);
}
else if (ReportList.SelectedValue == "2")
{
dt = cc2.LoadSMSReport(st_date, end_date, 1, groupid);
}
else if (ReportList.SelectedValue == "3")
{
dt = cc2.LoadSMSReport(st_date, end_date, 0, groupid);
}
else if (ReportList.SelectedValue == "5")
{
dt = cc2.LoadManualSMSReport(st_date, end_date);
}
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Add("SEND_DATE_STR");
foreach (DataRow r in dt.Rows)
{
r["SEND_DATE_STR"] = ((DateTime)r["SEND_DATE"]).ToString("dd/MM/yyyy HH:mm:ss");
}
ReportResultView.DataSource = dt;
ReportResultView.DataBind();
NodataLabel.Visible = false;
}
else
{
ReportResultView.DataSource = null;
ReportResultView.DataBind();
NodataLabel.Visible = true;
}
}
else
{
errorLabel.Visible = true;
}
ViewState["ReportResultView"] = dt;
}