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