protected void btnFinalize_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = ddlDeptHead.SelectedValue.ToString(); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 1; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = ddlDivHead.SelectedValue.ToString(); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 2; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); } Response.Redirect("EmployeeJournalList.aspx"); } } }
protected void btnApprove_Click(object sender, EventArgs e) { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { //objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalACode = EmployeeJournalApproval.GetForApprovalJournalACode(objEmployeeJournal.EmployeeJournalCode); objEmployeeJournalApproval.JournalAStatus = "A"; if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 1) { objEmployeeJournalApproval.Remarks = txtDepartmentHeadsRemarks.Text; } else if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 2) { objEmployeeJournal.JournalStatus = "A"; objEmployeeJournal.UpdateStatus(); objEmployeeJournalApproval.Remarks = txtDivisionHeadsRemarks.Text; } if (objEmployeeJournalApproval.UpdateStatus() > 0) { Response.Redirect("EmployeeJournalListA.aspx"); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { txtDepartmentHeadsRemarks.Visible = true; txtDivisionHeadsRemarks.Visible = true; txtDepartmentHeadsRemarks.Enabled = false; txtDivisionHeadsRemarks.Enabled = false; txtDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); txtDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1").ToString() == Request.Cookies["Speedo"]["UserName"].ToString()) { txtDepartmentHeadsRemarks.Enabled = true; btnApprove.Text = "Approved"; } if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2").ToString() == Request.Cookies["Speedo"]["UserName"].ToString()) { txtDivisionHeadsRemarks.Enabled = true; btnApprove.Text = "Read and Commented"; } } }
protected void LoadUpdates() { string strWrite = ""; string strStatus = ""; string strLink = ""; string strPreview = ""; string strJournalStatus = ""; string strEmployeeStatDate = ""; string strDepHeadStatus = ""; string strDivHeadStatus = ""; foreach (DataRow drJournal in EmployeeJournal.GetDSG(Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString()).Rows) { if (drJournal["JournalStatus"].ToString() == "S" && drJournal["LockStatus"].ToString() == "0") { strJournalStatus = "Draft"; strEmployeeStatDate = "(Last Log on " + drJournal["ModifiedOn"].ToString() + ")"; strDepHeadStatus = ""; strDivHeadStatus = ""; } else if (drJournal["JournalStatus"].ToString() == "F") { strJournalStatus = "For Approval"; strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")"; if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "1") == "A") { strDepHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "1") + ")"; } else { strDepHeadStatus = "(Not Yet Approved)"; } if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "2") == "A") { strDivHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "2") + ")"; } else { strDivHeadStatus = "(Not Yet Approved)"; } } else if (drJournal["JournalStatus"].ToString() == "A") { strJournalStatus = "Approved"; strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")"; strDepHeadStatus = ""; strDivHeadStatus = ""; } strLink = "JournalViewer"; strWrite = strWrite + "<tr>" + "<td class='GridRows'>" + clsEmployee.GetName(drJournal["CreatedBy"].ToString()) + "<br />" + strEmployeeStatDate + "</td>" + "<td class='GridRows'>" + strJournalStatus + "</td>" + "<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "1") + "<br />" + strDepHeadStatus + "</td>" + //"<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "2") + "<br />" + strDivHeadStatus + "</td>" + "</tr>"; } //Response.Write(strWrite); lblWrite.Text = strWrite; }
protected void Page_Load(object sender, EventArgs e) { lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")"; lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); lblDivApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + ")"; lblDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); }
protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); if (!Page.IsPostBack) { string strDeptDetails = "", strDivDetails = ""; string strDeptStatus = "", strDivStatus = ""; lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); this.LoadContent(); //lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")"; try { lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F") { strDeptStatus = "For Review"; } else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "A") { strDeptStatus = "Reviewed"; } else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F") { strDeptStatus = "Disapproved"; } strDeptDetails = "Reviewer: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + "<br />" + "Status: " + strDeptStatus + "<br />" + "Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); lblDepartmentHeadsRemarks.Text = strDeptDetails; } catch { } //if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F") //{ // strDivStatus = "For Approval"; //} //else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "A") //{ // strDivStatus = "Approved"; //} //else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F") //{ // strDivStatus = "Disapproved"; //} //strDivDetails = "Approver: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + "<br />" + // "Status: " + strDivStatus + "<br />" + // "Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); //lblDivisionHeadsRemarks.Text = strDivDetails; } }
protected void btnFinalize_Click(object sender, EventArgs e) { ViewState["JournalCode"] = Request.QueryString["JournalCode"]; if (lblReviewer.ForeColor == Color.Black) { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes") { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.JournalStatus = "F"; objEmployeeJournal.LockStatus = "1"; objEmployeeJournal.Enabled = "1"; objEmployeeJournal.Contents = ckeContents.Text.Replace("style=\"display: none\"", ""); objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); if (objEmployeeJournal.UpdateStatus() > 0) { using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval()) { objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode; objEmployeeJournalApproval.JournalApprover = EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournalApproval.JournalAStatus = "F"; objEmployeeJournalApproval.JournalAOrder = 1; objEmployeeJournalApproval.JournalADate = DateTime.Now; objEmployeeJournalApproval.Insert(); objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledAcknowledgementRequestor, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString())); objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledNotificationApprover, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString())); } Response.Redirect("EmployeeJournalList.aspx"); } } } else { using (EmployeeJournal objEmployeeJournal = new EmployeeJournal()) { objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]); objEmployeeJournal.Contents = ckeContents.Text; objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString(); objEmployeeJournal.ModifiedOn = DateTime.Now; if (objEmployeeJournal.Update() > 0) { Response.Redirect("JournalEncoding.aspx?JournalCode=" + Request.QueryString["JournalCode"]); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + ")"; this.MakeCart(); lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")"; lblDeptRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1"); lblDivApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + ")"; lblDivRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2"); ViewState["JournalCode"] = Request.QueryString["JournalCode"].ToString(); } }
/////////////////////////////////////////////////////// ///// REMOVE DUE TO HEAVY LOAD ON WEBPAGE ////// ///// UNUSED METHODS ////// ///// BY: calvin cavite Feb 20, 2018 ////// /////////////////////////////////////////////////////// //private string LoadLatestScheduleTeams(int gameID, int eventID) //{ // string strReturn = ""; // List<EventGameTeam> eventGameTeamList = new List<EventGameTeam>(); // using (PortalDataContext pdc = new PortalDataContext()) // { // eventGameTeamList = (from egt in pdc.EventGameTeams // where egt.GameID == gameID // orderby egt.Rank.Value // select egt).ToList(); // } // foreach (EventGameTeam egt in eventGameTeamList) // { // strReturn += (strReturn == "" ? "" : "<tr><td style='color:Red;border-color: #FFFFFF;'> <b>Versus </b></td></tr>") + // "<tr><td style='border-color: #FFFFFF;font-size:15px; line-height:15px'><b><a href='../Synergy/TeamDetails.aspx?teamid=" + egt.TeamID + "'>" + DALPortal.GetTeamName(egt.TeamID) + "</a></b></td></tr>"; // } // return "<tr><td style='border-color: #FFFFFF;'><table align='center' style='border-color: #FFFFFF;'>" + strReturn + "</table></td></tr>"; //} //protected void LoadLatestSchedule() //{ // string strWrite = ""; // int intCountEvents = 0; // int intCount = 0; // DateTime latestDate = DALPortal.GetLatestGameDate(); // if (latestDate != DateTime.MinValue) // { // DateTime latestDateStart = clsDateTime.ChangeTimeToStart(latestDate); // DateTime latestDateEnd = clsDateTime.ChangeTimeToEnd(latestDate); // List<EventGame> eventGamesList = new List<EventGame>(); // using (PortalDataContext pdc = new PortalDataContext()) // { // eventGamesList = (from eg in pdc.EventGames // where eg.IsActive == true && eg.StartDate >= latestDateStart && eg.IsFinished == false // orderby eg.StartDate // select eg).ToList(); // } // intCount = eventGamesList.Count; // foreach (EventGame eg in eventGamesList) // { // if (intCountEvents > 4) // { break; } // strWrite += "<div class='GridBorder' style='text-align:center;border-color: #FFFFFF; font-size: 11px; line-height:5px'>" + // "<table style='width:100%;border-color: #FFFFFF;'>" + // "<tr><td style='border-color: #FFFFFF;'><b><a href='" + clsSystemConfigurations.PortalRootURL + "/Synergy/EventDetails.aspx?eventid=" + eg.EventID.ToString() + "'>" + DALPortal.GetEventName(eg.EventID) + "</a></b></td></tr>" + // "<tr><td style='border-color: #FFFFFF;'>" + DALPortal.GetGamePhaseName(eg.GamePhase.ToString()) + "</td></tr>" + // this.LoadLatestScheduleTeams(eg.GameID, eg.EventID) + // "<tr><td style='color:Black;border-color: #FFFFFF;'>" + eg.StartDate.ToString("hh:mm tt ddd, MMM dd") + "</td></tr>" + // "<tr><td style='color:Black;border-color: #FFFFFF;'>@ " + eg.Location + "</td></tr>" + // "</table><hr/>" + // "</div>"; // intCountEvents++; // } // } // if (intCount > 0) // { // masterlitLatestSchedule.Text = "<div class='' ><div class='' style='font-weight:bold'>Game Schedule</div><div class='masterpanelspace'></div>" + strWrite + "</div>"; // } //} protected void LoadNotification() { string strWrite = ""; int intpMrcfUnread = 0; int intpRequisitionUnread = 0; int intpCrs = 0; int intpTransmittal = 0; string strpUserName = Request.Cookies["Speedo"]["UserName"].ToString(); //imgpnlavatar.ImageUrl = "~/pictures/realpicture/" + clsSpeedo.GetRealPicture(strpUserName) + ".jpg"; int intpNotificationUnread = clsMessage.CountUnRead(strpUserName); ///Petty Cash - Rollie int intpPCAS = clsPCASApproval.CountForPCASApproval(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpPCAS > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/Finance/PCASH/PettyCashRequestMenu.aspx'> Petty Cash (" + intpPCAS + ")</a></div>"; } int intpPCASCustodian = clsPCASRequestCustodian.CountForApproval(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpPCASCustodian > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/Finance/PCASH/PettyCashRequestCashierMenu.aspx'> Petty Cash (" + intpPCASCustodian + ")</a></div>"; } int intpPCASFPC1 = clsPCASApproval.CountForPCASApproval(clsPCASFPCApprover.GetUsername(1)); if (intpPCASFPC1 > 0 && clsPCASFPCApprover.IsExisting(Request.Cookies["Speedo"]["UserName"].ToString()) == true) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/Finance/PCASH/PettyCashRequestFinanceMenu.aspx'> Petty Cash - FPC (" + intpPCASFPC1 + ")</a></div>"; } ////// //Transmittal intpTransmittal = Convert.ToInt16(clsTransmittal.CountForApproval(Request.Cookies["Speedo"]["UserName"].ToString())); if (intpTransmittal > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/CIS/Transmittal/TranMenu.aspx'> Transmittal (" + intpTransmittal + ")</a></div>"; //lnkpnllftATW.Text = "<b>Authority to Work (" + intpATW + ")</b>"; //lnkpnllftATW.Font.Bold = true; } int intpATW = clsATW.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpATW > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/ATW/ATWMenu.aspx'> Authority To Work (" + intpATW + ")</a></div>"; //lnkpnllftATW.Text = "<b>Authority to Work (" + intpATW + ")</b>"; //lnkpnllftATW.Font.Bold = true; } int intGroupUpdate = GroupUpdateApproval.GetCountForModification(Request.Cookies["Speedo"]["UserName"].ToString()) + GroupUpdateApproval.GetCountForApprovalLevel1(Request.Cookies["Speedo"]["UserName"].ToString()) + GroupUpdateApproval.GetCountForApprovalLevel2(Request.Cookies["Speedo"]["UserName"].ToString()); if (intGroupUpdate > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/GroupUpdate/GroupUpdateMain.aspx'> Group Update (" + intGroupUpdate + ")</a></div>"; //lnkpnllftATW.Text = "<b>Authority to Work (" + intpATW + ")</b>"; //lnkpnllftATW.Font.Bold = true; } int intpIAR = clsIAR.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpIAR > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/IAR/IARMenu.aspx'> Internet Request (" + intpIAR + ")</a></div>"; //lnkpnllftIAR.Text = "<b>Internet Request (" + intpIAR + ")</b>"; //lnkpnllftIAR.Font.Bold = true; } using (SqlConnection cnp = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString())) { SqlCommand cmdp = cnp.CreateCommand(); cmdp.CommandText = "SELECT COUNT(mrcfcode) FROM CIS.Mrcf WHERE (username='******' AND status='M') OR (sprvcode='" + strpUserName + "' AND sprvstat='F') OR (headcode='" + strpUserName + "' AND headstat='F' AND sprvstat IN ('A','X','N')) OR (proccode='" + strpUserName + "' AND procstat='F' AND ((sprvstat='A' AND headstat='N') OR (headstat='A')))"; cnp.Open(); intpMrcfUnread = (int)cmdp.ExecuteScalar(); //Updated by charlie bachiller //Updated due to voided transaction on requisition still counted //cmdp.CommandText = "SELECT COUNT(requcode) FROM CIS.Requisition WHERE (username='******' AND status='M') OR (sprvcode='" + strpUserName + "' AND sprvstat='F') OR (headcode='" + strpUserName + "' AND headstat='F' AND sprvstat IN ('A','X','N')) OR (suppcode='" + strpUserName + "' AND (suppstat='F' OR suppstat='P'))"; cmdp.CommandText = "SELECT COUNT(requcode) FROM CIS.Requisition WHERE ((username='******' AND status='M') OR (sprvcode='" + strpUserName + "' AND sprvstat='F' AND status='F') OR (headcode='" + strpUserName + "' AND headstat='F' AND sprvstat IN ('A','X','N') AND status='F') OR (suppcode='" + strpUserName + "' AND (suppstat='F' OR suppstat='P') AND status IN ('A','P')))"; intpRequisitionUnread = (int)cmdp.ExecuteScalar(); //cmdp.CommandText = "SELECT COUNT(username) FROM Users.Users WHERE DATEPART(mm,brthdate)='" + DateTime.Now.Month + "' AND DATEPART(dd,brthdate)='" + DateTime.Now.Day + "' AND pstatus='1'"; //intpCelebrants = (int)cmdp.ExecuteScalar(); cmdp.CommandText = "SELECT COUNT(crscode) FROM CM.Crs WHERE (cmhname='" + strpUserName + "' AND crscode IN (SELECT DISTINCT crscode FROM CM.CrsDetails WHERE pstatus='F')) OR (ccname='" + strpUserName + "' AND crscode IN (SELECT DISTINCT crscode FROM CM.CrsDetails WHERE pstatus='E' OR pstatus='P'))"; intpCrs = (int)cmdp.ExecuteScalar(); } if (intpMrcfUnread > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/CIS/MRCF/MRCFMenu.aspx'> MRCF (" + intpMrcfUnread + ")</a></div>"; //lnkpnllftMRCF.Text = "<b>MRCF (" + intpMrcfUnread + ")</b>"; } if (intpRequisitionUnread > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/CIS/Requisition/RequMenu.aspx'> Requisition (" + intpRequisitionUnread + ")</a></div>"; //lnkpnllftRequisition.Text = "<b>Requisition (" + intpRequisitionUnread + ")</b>"; //lnkpnllftRequisition.Font.Bold = true; } int intpCATA = 0; int intCtrCATA = 0; //Added by charlie for cata //add by charlie DataTable tblEndorserApproval = clsCATAApproval.GetDSGForApprovalEndorser(Request.Cookies["Speedo"]["UserName"]); DataTable tblAuthorizeApproval = clsCATAApproval.GetDSGForApprovalAuthorize(Request.Cookies["Speedo"]["UserName"]); intCtrCATA = tblEndorserApproval.Rows.Count + tblAuthorizeApproval.Rows.Count; if (intCtrCATA > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/Finance/CATA/FinanceCataMenu.aspx'> Request For CATA (" + intCtrCATA + ")</a></div>"; } ////cata for approvals //Added by charlie for RFP int intpRFP = 0; int intCtrRFP = 0; DataTable tblRFP = clsRFPRequest.GetDSGMainFormApprover(Request.Cookies["Speedo"]["UserName"]); foreach (DataRow drw in tblRFP.Rows) { if (clsFinanceApprover.IsAuthoritary(Request.Cookies["Speedo"]["UserName"], "ctrlnmbr", drw["ControlNumber"].ToString(), "RFPRequest")) { if (drw["Endorsed1Status"].ToString().Trim() == "2" && drw["Endorsed2Status"].ToString().Trim() == "") { continue; } else if (drw["Endorsed1Status"].ToString().Trim() == "2" && drw["Endorsed2Status"].ToString().Trim() == "2") { continue; } else if (drw["Endorsed1Status"].ToString().Trim() == "2" && drw["Endorsed2Status"].ToString().Trim() == "1") { continue; } else if (drw["Endorsed1Status"].ToString().Trim() == "1" && drw["Endorsed2Status"].ToString().Trim() == "2") { continue; } else { intpRFP += 1; } } else if (clsFinanceApprover.IsEndorder1(Request.Cookies["Speedo"]["UserName"], "ctrlnmbr", drw["ControlNumber"].ToString(), "RFPRequest")) { if (drw["Endorsed1Status"].ToString().Trim() != "2") { continue; } else { intpRFP += 1; } } else if (clsFinanceApprover.IsEndorder2(Request.Cookies["Speedo"]["UserName"], "ctrlnmbr", drw["ControlNumber"].ToString(), "RFPRequest")) { if (drw["Endorsed2Status"].ToString().Trim() != "2") { continue; } else { intpRFP += 1; } } else { intpRFP += 1; } intCtrRFP++; } if (intCtrRFP > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/Finance/RFP/RFPMenu.aspx'> Request For Payment (" + intpRFP + ")</a></div>"; } ////////////////////////// ////// HRMS Summary ////// ////////////////////////// int intpLeave = clsLeave.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpLeave > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/Leave/LeaveMenu.aspx'> Leave (" + intpLeave + ")</a></div>"; } int intpOvertime = clsOvertime.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpOvertime > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/Overtime/OvertimeMenu.aspx'> Overtime (" + intpOvertime + ")</a></div>"; } int intpOB = clsOB.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"]); if (intpOB > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/OB/OBMenu.aspx'> Official Business (" + intpOB + ")</a></div>"; } int intpUndertime = clsUndertime.GetTotalForAttention(Request.Cookies["Speedo"]["UserName"].ToString()); if (intpUndertime > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/HR/HRMS/Undertime/UndertimeMenu.aspx'> Undertime (" + intpUndertime + ")</a></div>"; } ///////////////////////////////////// // UNUSED // // By Calvin Cavite Feb 20, 2018 // ///////////////////////////////////// ////Reward Points Notification //string strUsername = Request.Cookies["Speedo"]["UserName"].ToString(); //if (clsRewardApproval.IsEncoder(strUsername) || clsRewardApproval.IsApproverHR(strUsername)) //{ // int intReward = 0; // if (clsRewardApproval.IsEncoder(strUsername)) // { // intReward = clsRewardApproval.ForModification(); // } // if (clsRewardApproval.IsApproverHR(strUsername)) // { // intReward = clsRewardApproval.GetDSGForApprovalLevel1(strUsername).Rows.Count + clsRewardApproval.GetDSGForApprovalLevel2(strUsername).Rows.Count; // } // if (intReward > 0) // { // strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/RewardPoint/TransactionMain.aspx'> Rewards Point (" + intReward + ")</a></div>"; // } //} ////////////////////////// ////// MRCF Assign /////// ////////////////////////// int intAssignMRCF = clsMRCFAssign.GetTotalAssigned(Request.Cookies["Speedo"]["UserName"].ToString()); if (intAssignMRCF > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/CIS/MRCF/MRCFMenu.aspx'> Assigned MRCF (" + intAssignMRCF + ")</a></div>"; } ////////////////////////// ////// Journal Approval /////// ////////////////////////// int intJournalCount = EmployeeJournalApproval.GetApprovalCount(Request.Cookies["Speedo"]["UserName"].ToString()); if (intJournalCount > 0) { strWrite += "<div class='masterpanelcontent'><a href='" + clsSystemConfigurations.PortalRootURL + "/EmployeeJournal/EmployeeJournalListFApproval.aspx'> Journal (" + intJournalCount + ")</a></div>"; } if (strWrite.Length > 0) { divNotification.Visible = true; ltNotification.Text = strWrite; } else { divNotification.Visible = false; } }