protected void Page_Load(object sender, EventArgs e)
{
_log = new ClsChangeLog("MasterSchedule");
// FIX for hiding calendar when a date is selected
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "hideCalendar", "function hideCalendar(cb) { cb.hide(); }", true);
// FIX for css not loading when a calendar is inside of an updatepanel+multiview (+tabcontrol?)
string url = Page.ClientScript.GetWebResourceUrl(typeof(ClientCssResourceAttribute), "AjaxControlToolkit.Calendar.Calendar.css");
HtmlLink myHtmlLink = new HtmlLink();
myHtmlLink.Href = url;
myHtmlLink.Attributes.Add("rel", "stylesheet");
myHtmlLink.Attributes.Add("type", "text/css");
Page.Header.Controls.Add(myHtmlLink);
rowFilter = "Select * From ChangeLog_Report ORDER BY DateSubmitted";
if (!Page.IsPostBack)
{
DataSet ds = _log.FillDs();
//gvNeedsApproval.DataSource = ds.Tables[0].DefaultView;
//lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
//gvNeedsApproval.DataBind();
BindLists(ds);
CreateFilteredReport();
currentPageNumber = 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ClsChangeLog log = new ClsChangeLog("MasterSchedule");
log.LogId = int.Parse(Request.QueryString["changelogid"]);
DataView view = log.FillDs().Tables[0].DefaultView;
view.RowFilter = "LogID = " + Request.QueryString["changelogid"];
this.gvNeedsApproval.DataSource = view;
this.gvNeedsApproval.DataBind();
}
private void CreateFilteredReport()
{
try
{
ClsDivisionProcessing dp = new ClsDivisionProcessing();
List <string> rowFilters = new List <string>();
if (ddlTermFilter.SelectedValue != "All")
{
rowFilters.Add("Term = '" + ddlTermFilter.SelectedValue + "' ");
}
if (ddlCourse.SelectedValue != "All")
{
rowFilters.Add("CourseNumber LIKE '" + ddlCourse.SelectedValue.Trim() + "%' ");
}
if (ddlSubmittedByFilter.SelectedValue != "All")
{
rowFilters.Add("SubmittedBy = '" + ddlSubmittedByFilter.SelectedValue.Trim() + "' ");
}
if (!string.IsNullOrEmpty(txtFrom.Text))
{
DateTime from = DateTime.Parse(txtFrom.Text);
rowFilters.Add("DateSubmitted >=#" + from.ToShortDateString() + "#");
}
if (!string.IsNullOrEmpty(txtTo.Text))
{
DateTime to = DateTime.Parse(txtTo.Text);
to = to.AddDays(1);
rowFilters.Add("DateSubmitted <= #" + to.ToShortDateString() + "#");
}
if (ddlDivision.SelectedValue != "All")
{
rowFilters.Add(dp.GetDepartments(ddlDivision.SelectedValue));
}
StringBuilder sb = new StringBuilder();
string a = "";
foreach (string filter in rowFilters)
{
sb.Append(a);
sb.Append(filter);
a = " AND ";
}
rowFilter = sb.ToString();
DataSet ds = _log.FillDs();
DataTable dt = new DataTable();
dt = ds.Tables[0].Clone();
DataView view = ds.Tables[0].DefaultView;
view.RowFilter = rowFilter;
DataTable cacheTable = view.ToTable();
int counter = ((currentPageNumber - 1) * PAGE_SIZE);
for (int i = counter; i < (PAGE_SIZE + counter); i++)
{
dt.ImportRow(cacheTable.Rows[i]);
if (i == (view.Count - 1))
{
break;
}
}
double totalRows = view.Count;
lblTotalPages.Text = CalculateTotalPages(totalRows).ToString();
lblCurrentPage.Text = currentPageNumber.ToString();
if (currentPageNumber == 1)
{
Btn_Previous.Enabled = false;
if (Int32.Parse(lblTotalPages.Text) > 1)
{
Btn_Next.Enabled = true;
}
else
{
Btn_Next.Enabled = false;
}
}
else
{
Btn_Previous.Enabled = true;
if (currentPageNumber == Int32.Parse(lblTotalPages.Text))
{
Btn_Next.Enabled = false;
}
else
{
Btn_Next.Enabled = true;
}
}
lblRecordCount.Text = view.Count.ToString();
gvNeedsApproval.DataSource = dt;
gvNeedsApproval.DataBind();
}
catch (Exception ex)
{
gvNeedsApproval.DataSource = null;
gvNeedsApproval.DataBind();
}
}
