protected void LoadPage()
{
string strWrite = "";
string strKeyword = "";
lblQueryResult.Visible = false;
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string username = Request.Cookies["Speedo"]["UserName"];
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
else
{
strKeyword = "";
}
using (clsPagination objPagination = new clsPagination())
{
objPagination.CurrentPage = string.IsNullOrEmpty(Request.QueryString["Page"]) == true ? 1 : Request.QueryString["Page"].ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = clsEFormsReport.RFPCountArchives(username, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), Request.QueryString["Status"].ToString(), strKeyword);
string strDateStart = dtStartDate.ToString("MMMddyyyy");
string strDateEnd = dtEndDate.ToString("MMMddyyyy");
ddlPages.Items.Clear();
for (int i = 1; i <= objPagination.TotalPage(); i++)
{
ListItem l = new ListItem(i.ToString(), i.ToString(), true);
l.Selected = l.Value == objPagination.CurrentPage.ToString() ? true : false;
ddlPages.Items.Add(l);
}
}
lblPage.Text = strWrite;
}
protected void LoadFilter()
{
string strWrite = "";
lblQueryResult.Visible = false;
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string strCategory = "";
string strKeyword = "";
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["Category"]))
{
strCategory = Request.QueryString["Category"].ToString();
}
else
{
strCategory = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
using (clsPagination objPagination = new clsPagination())
{
//objPagination.CurrentPage = string.IsNullOrEmpty(Request.QueryString["Page"]) == true ? 1 : Request.QueryString["Page"].ToInt();
objPagination.CurrentPage = ddlPages.SelectedValue.ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = DALThread.GetThreadArchiveCount(strCategory, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strKeyword);
DataTable tblResult = DALThread.GetThreadArchiveArchives(strCategory, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), objPagination.PagePerForm, objPagination.Offset(), strKeyword);
if (tblResult.Rows.Count > 0)
{
lblQueryResult.Visible = true;
}
if (tblResult.Rows.Count == 0)
{
strWrite = strWrite + "<tr><td class='GridRows'>No record found</td></tr>";
}
else
{
strWrite = strWrite + "<tr><td class='GridRows'>[ About " + tblResult.Rows.Count + " results found ]</td></tr>";
}
foreach (DataRow drw in tblResult.Rows)
{
strWrite = strWrite + "<tr>" +
"<td class='GridRows'>" +
"<a href='Thread.aspx?threadid=" + drw["ThreadID"].ToString() + "&page=1' style='font-size:medium;'>" + DALThread.GetTitle(drw["ThreadID"].ToString().ToInt()) + "</a><br/>" +
"<font style='font-size: x-small; font-weight: normal; font-style: italic'>Posted By: <a href='../../../Userpage/UserPage.aspx?username="******"PostedBy"] + "'>" + clsEmployee.GetName(drw["PostedBy"].ToString()) + "</a> (" + Convert.ToDateTime(drw["PostedDate"].ToString()).ToString("MMM dd, yyyy hh:mm tt") + ")<br/>" +
DALThread.GetDescription(drw["ThreadID"].ToString().ToInt()) +
"</td>" +
"</tr>";
}
lblQueryResult.Text = strWrite;
}
}
protected void LoadPage()
{
string strWrite = "";
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string strCategory = "";
string strKeyword = "";
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["Category"]))
{
strCategory = Request.QueryString["Category"].ToString();
}
else
{
strCategory = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
using (clsPagination objPagination = new clsPagination())
{
objPagination.CurrentPage = string.IsNullOrEmpty(Request.QueryString["Page"]) == true ? 1 : Request.QueryString["Page"].ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = DALThread.GetThreadArchiveCount(strCategory, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strKeyword);
string strDateStart = dtStartDate.ToString("MMMddyyyy");
string strDateEnd = dtEndDate.ToString("MMMddyyyy");
//if (objPagination.TotalPage() > 1)
//{
// if (objPagination.HasPreviousPage())
// {
// strWrite += "<a href='ThreadQueryResult.aspx?Page=" + objPagination.PreviousPage() + "&Category=" + strCategory + "&DateStart=" + strDateStart + "&DateEnd=" + strDateEnd + "'> «Previous</a>";
// }
// int i = 0;
// for (i = 1; i <= objPagination.TotalPage(); i++)
// {
// if (i == objPagination.CurrentPage)
// {
// strWrite += "<span><b>" + i + "</b></span>";
// }
// else
// {
// strWrite += "<a href='ThreadQueryResult.aspx?Page=" + i + "&Category=" + strCategory + "&DateStart=" + strDateStart + "&DateEnd=" + strDateEnd + "'>" + i + "</a> ";
// }
// }
// if (objPagination.HasNextPage())
// {
// strWrite += "<a href='ThreadQueryResult.aspx?Page=" + objPagination.NextPage() + "&Category=" + strCategory + "&DateStart=" + strDateStart + "&DateEnd=" + strDateEnd + "'> Next »</a>";
// }
//}
ddlPages.Items.Clear();
for (int i = 1; i <= objPagination.TotalPage(); i++)
{
ListItem l = new ListItem(i.ToString(), i.ToString(), true);
l.Selected = l.Value == objPagination.CurrentPage.ToString() ? true : false;
ddlPages.Items.Add(l);
}
}
//lblPage.Text = strWrite;
}
protected void LoadApprovedDisapproved()
{
string strWrite = "";
string strKeyword = "";
string strStatus = "";
lblQueryResult.Visible = false;
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string username = Request.Cookies["Speedo"]["UserName"];
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["Status"]))
{
strStatus = Request.QueryString["Status"].ToString();
}
else
{
strStatus = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
else
{
strKeyword = "";
}
using (clsPagination objPagination = new clsPagination())
{
objPagination.CurrentPage = ddlPages.SelectedValue.ToString().ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = clsEFormsReport.RFPCountArchives(username, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strStatus, strKeyword);
DataTable tblResult = clsEFormsReport.RFPDSGArchives(username, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strStatus, objPagination.PagePerForm, objPagination.Offset(), strKeyword);
int intFirstItem = 0;
int intLastItem = 0;
if (tblResult.Rows.Count > 0)
{
DataRow drFirstRow = tblResult.Rows[0];
intFirstItem = drFirstRow["RowNum"].ToString().ToInt();
DataRow drLastRow = tblResult.Rows[tblResult.Rows.Count - 1];
intLastItem = drLastRow["RowNum"].ToString().ToInt();
lblQueryResult.Visible = true;
}
if (tblResult.Rows.Count == 0)
{
strWrite = strWrite + "<tr><td class='GridRows'>No record found</td></tr>";
}
else
{
strWrite = strWrite + "<tr><td class='GridRows'>[ Showing results " + intFirstItem + " to " + intLastItem + " of " + objPagination.TotalCount + " ]</td></tr>";
}
foreach (DataRow drw in tblResult.Rows)
{
strWrite = strWrite + "<tr>" +
"<td class='GridRows'>" +
"<a href='../Finance/RFP/RFPDetails.aspx?ControlNumber=" + drw["ctrlnmbr"].ToString() + "&Username="******"' style='font-size:medium;' target='_blank'>" + drw["ctrlnmbr"].ToString() + "</a><br/><font style='normal: small; font-weight: normal;'><b>Request For:</b> " + drw["rqstfor"].ToString() + "</font><br/><font style='normal: small; font-weight: normal;'><b>Project Title:</b> " + drw["projttle"].ToString() +
"<font style='font-size:normal; font-weight: normal;'><b><br/>Submitted By:</b> <a href='../../../Userpage/UserPage.aspx?username="******"createby"] + "'>" + clsEmployee.GetName(drw["createby"].ToString()) + "</a> (" + Convert.ToDateTime(drw["createon"].ToString()).ToString("MMM dd, yyyy hh:mm tt") + ")" +
"<br/><b>Status:</b> " + clsEFormsReport.RFPStatus(username, drw["ctrlnmbr"].ToString()) + "</font>" +
"</td>" +
"</tr>";
}
lblQueryResult.Text = strWrite;
}
}
public void LoadLeave()
{
string strWrite = "";
string strKeyword = "";
string strStatus = "";
lblQueryResult.Visible = false;
lblQueryResult.Text = "";
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string username = Request.Cookies["Speedo"]["UserName"];
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["Status"]))
{
strStatus = Request.QueryString["Status"].ToString();
}
else
{
strStatus = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
else
{
strKeyword = "";
}
using (clsPagination objPagination = new clsPagination())
{
objPagination.CurrentPage = ddlPages.SelectedValue.ToString().ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = clsEFormsReport.GetLeave(dtStartDate, dtEndDate, strKeyword, strStatus, username).Rows.Count;
DataTable tblResult = clsEFormsReport.GetLeave(dtStartDate, dtEndDate, strKeyword, strStatus, username);
int intFirstItem = 0;
int intLastItem = 0;
int intStart = 0;
int intEnd = 0;
if (tblResult.Rows.Count > 0)
{
intFirstItem = 0;
intLastItem = 0;
lblQueryResult.Visible = true;
if (ddlPages.SelectedItem.Text.ToInt() == 1)
{
intStart = 0;
intFirstItem = intStart + 1;
intLastItem = intStart + tblResult.Rows.Count;
intEnd = objPagination.PagePerForm * ddlPages.SelectedItem.Text.ToInt();
}
else
{
intStart = objPagination.PagePerForm * ddlPages.SelectedItem.Text.ToInt() - objPagination.PagePerForm;
intFirstItem = intStart + 1;
if (ddlPages.SelectedItem.Text == ddlPages.Items[ddlPages.Items.Count - 1].Text)
{
intLastItem = tblResult.Rows.Count;
}
else
{
intLastItem = intStart + 10;
}
intEnd = objPagination.PagePerForm * ddlPages.SelectedItem.Text.ToInt();
}
}
if (tblResult.Rows.Count == 0)
{
strWrite = strWrite + "<tr><td class='GridRows'>No record found</td></tr>";
}
else
{
strWrite = strWrite + "<tr><td class='GridRows'>[ Showing results " + intFirstItem + " to " + intLastItem + " of " + objPagination.TotalCount + " ]</td></tr>";
}
lblPage.Text = strWrite;
foreach (DataRow dr in clsEFormsReport.GetLeave(dtStartDate, dtEndDate, strKeyword, strStatus, username).Rows)
{
if (intStart == intEnd)
{
break;
}
if (intStart == tblResult.Rows.Count)
{
break;
}
lblQueryResult.Visible = true;
strWrite = "<tr><td class='GridRows'><font style='font-size:normal; font-weight: normal;'><a style='font-size:medium; font-weight:bold;' href='LeaveDetailsReport.aspx?leavcode=" + dr.Table.Rows[intStart]["leavcode"].ToString() + "'>" + dr.Table.Rows[intStart]["leavcode"].ToString() + "</a>" +
"<br><b>Submitted by: </b><a href='../Userpage/UserPage.aspx?username="******"username"].ToString() + "'>" + clsEmployee.GetName(dr["username"].ToString()) + "</a></br>" +
"<b>Reason: </b>" + clsString.CutString(dr.Table.Rows[intStart]["reason"].ToString(), 80).ToString() +
"<br><b>Approver: </b> <a href='../Userpage/UserPage.aspx?username="******"username"].ToString() + "'>" + clsEmployee.GetName(dr["apphname"].ToString()) + "</a></br>" +
"<b>Date Filed: </b>" + Convert.ToDateTime(dr.Table.Rows[intStart]["DateFiled"].ToString()).ToString("MMM dd, yyyy hh:mm tt") + "</font></td></tr>";
intStart++;
lblQueryResult.Text += strWrite;
}
}
}
protected void LoadFilter()
{
string strWrite = "";
lblQueryResult.Visible = false;
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string strDivisionCode = "";
string strDepartmentCode = "";
string strKeyword = "";
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["DivisionCode"]))
{
strDivisionCode = Request.QueryString["DivisionCode"].ToString();
}
else
{
strDivisionCode = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["DepartmentCode"]))
{
strDepartmentCode = Request.QueryString["DepartmentCode"].ToString();
}
else
{
strDepartmentCode = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
using (clsPagination objPagination = new clsPagination())
{
// objPagination.CurrentPage = string.IsNullOrEmpty(Request.QueryString["Page"]) == true ? 1 : Request.QueryString["Page"].ToInt();
objPagination.CurrentPage = ddlPages.SelectedValue.ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = clsGroupUpdate.GetDSGArchives(strDivisionCode, strDepartmentCode, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strKeyword).Rows.Count;
DataTable tblResult = clsGroupUpdate.GetDSGArchives(strDivisionCode, strDepartmentCode, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), objPagination.PagePerForm, objPagination.Offset(), strKeyword);
int intFirstItem = 0;
int intLastItem = 0;
if (tblResult.Rows.Count > 0)
{
DataRow drFirstRow = tblResult.Rows[0];
intFirstItem = drFirstRow["RowNum"].ToString().ToInt();
DataRow drLastRow = tblResult.Rows[tblResult.Rows.Count - 1];
intLastItem = drLastRow["RowNum"].ToString().ToInt();
lblQueryResult.Visible = true;
}
if (tblResult.Rows.Count == 0)
{
strWrite = strWrite + "<tr><td class='GridRows'>No record found</td></tr>";
}
else
{
strWrite = strWrite + "<tr><td class='GridRows'>[ Showing results " + intFirstItem + " to " + intLastItem + " of " + objPagination.TotalCount + " ]</td></tr>";
foreach (DataRow drw in tblResult.Rows)
{
strWrite = strWrite + "<tr>" +
"<td class='GridRows'>" +
"<a href='GroupUpdateView.aspx?GroupUpdateCode=" + drw["GroupUpdateCode"].ToString() + "&DivisionCode=" + drw["DivisionCode"].ToString() + "&DepartmentCode=" + drw["DepartmentCode"].ToString() + "' style='font-size:medium;' target='_blank'>" + clsGroupUpdate.GetTitle(drw["GroupUpdateCode"].ToString().ToInt()) + "</a><br/>" +
"<font style='font-size: x-small; font-weight: normal; font-style: italic'>Contributor: " + drw["Contributor"].ToString() + "<br/>Posted By: <a href='../../../Userpage/UserPage.aspx?username="******"CreateBy"] + "'>" + clsEmployee.GetName(drw["CreateBy"].ToString()) + "</a> (" + Convert.ToDateTime(drw["CreateOn"].ToString()).ToString("MMM dd, yyyy hh:mm tt") + ")<br/>" +
clsGroupUpdate.GetDescription(drw["GroupUpdateCode"].ToString().ToInt()) +
"</td>" +
"</tr>";
}
}
lblQueryResult.Text = strWrite;
}
}
protected void LoadPage()
{
string strWrite = "";
DateTime dtStartDate = new DateTime();
DateTime dtEndDate = new DateTime();
string strDivisionCode = "";
string strDepartmentCode = "";
string strKeyword = "";
if (!string.IsNullOrEmpty(Request.QueryString["DateStart"]))
{
dtStartDate = DateTime.ParseExact(Request.QueryString["DateStart"].ToString(), "MMMddyyyy", null);
}
else
{
dtStartDate = DateTime.Parse("1/1/1990");
}
if (!string.IsNullOrEmpty(Request.QueryString["DateEnd"]))
{
dtEndDate = DateTime.ParseExact(Request.QueryString["DateEnd"].ToString(), "MMMddyyyy", null);
}
else
{
dtEndDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(Request.QueryString["DivisionCode"]))
{
strDivisionCode = Request.QueryString["DivisionCode"].ToString();
}
else
{
strDivisionCode = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["DepartmentCode"]))
{
strDepartmentCode = Request.QueryString["DepartmentCode"].ToString();
}
else
{
strDepartmentCode = "ALL";
}
if (!string.IsNullOrEmpty(Request.QueryString["Keyword"]))
{
strKeyword = Request.QueryString["Keyword"].ToString();
}
using (clsPagination objPagination = new clsPagination())
{
objPagination.CurrentPage = string.IsNullOrEmpty(Request.QueryString["Page"]) == true ? 1 : Request.QueryString["Page"].ToInt();
objPagination.PagePerForm = 10;
objPagination.TotalCount = clsGroupUpdate.GetDSGArchives(strDivisionCode, strDepartmentCode, DateTime.Parse(dtStartDate.ToShortDateString() + " 1:00 AM"), DateTime.Parse(dtEndDate.ToShortDateString() + " 11:59 PM"), strKeyword).Rows.Count;
string strDateStart = dtStartDate.ToString("MMMddyyyy");
string strDateEnd = dtEndDate.ToString("MMMddyyyy");
ddlPages.Items.Clear();
for (int i = 1; i <= objPagination.TotalPage(); i++)
{
ListItem l = new ListItem(i.ToString(), i.ToString(), true);
l.Selected = l.Value == objPagination.CurrentPage.ToString() ? true : false;
ddlPages.Items.Add(l);
}
}
lblPage.Text = strWrite;
}
