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