protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!clsLeave.AuthenticateAccess(Request.Cookies["Speedo"]["UserName"], Request.QueryString["leavcode"].ToString()))
{
Response.Redirect("~/AccessDenied.aspx");
}
if (!Page.IsPostBack)
{
clsLeave.AuthenticateAccessForm(LeaveUsers.Requestor, Request.Cookies["Speedo"]["UserName"], Request.QueryString["leavcode"].ToString());
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
txtLeaveCode.Text = leave.LeaveCode;
txtLeaveType.Text = clsLeaveType.GetDescription(leave.LeaveType);
txtDateFiled.Text = leave.DateFile.ToString("MMM dd, yyyy hh:mm tt");
txtRequestorName.Text = clsUsers.GetName(leave.UserName);
txtStatus.Text = clsLeave.ToLeaveStatusDesc(leave.Status);
txtDateFrom.Text = leave.DateStart.ToString("MMM dd, yyyy hh:mm tt");
txtDateTo.Text = leave.DateEnd.ToString("MMM dd, yyyy hh:mm tt");
txtUnits.Text = leave.Units.ToString();
txtReason.Text = leave.Reason;
txtApproverName.Text = clsUsers.GetName(leave.ApproverName);
txtApproverDate.Text = clsValidator.CheckMinDateTime(leave.ApproverDate);
txtApproverRemarks.Text = leave.ApproverRemarks;
btnCancel.Visible = clsLeave.ToLeaveStatus(leave.Status) == LeaveStatus.ForApproval;
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Cancel();
Response.Redirect("LeaveMenu.aspx");
}
protected void btnApprove_Click(object sender, EventArgs e)
{
float fltRemainingBalance = clsLeaveBalance.GetRemainingBalance(hdnLeaveTypeCode.Value, hdnRequestor.Value);
bool blnHasBalance = clsLeaveType.IsHasBalance(hdnLeaveTypeCode.Value);
if (!blnHasBalance || (fltRemainingBalance >= clsValidator.CheckFloat(txtUnits.Text)))
{
if (blnHasBalance)
{
clsLeaveBalance.DeductLeaveBalance(float.Parse(txtUnits.Text), hdnRequestor.Value, hdnLeaveTypeCode.Value);
}
using (clsLeave leave = new clsLeave())
{
leave.LeaveCode = Request.QueryString["leavcode"].ToString();
leave.Fill();
leave.ApproverRemarks = txtApproverRemarks.Text;
leave.ApproverDate = DateTime.Now;
if (leave.Approve())
{
//ADDED by CALVIN CAVITE FEB 15, 2018
ScriptManager.RegisterStartupScript(this, this.GetType(), "none", "ModalSuccess();", true);
}
}
}
else
{
lblErrMsg.Text = "Not enough balance.";
divError.Visible = true;
}
}
protected void LoadLeaveBalance() //added by charlie function
{
string strWrite = "";
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
DataTable tblLeaveBalance = clsLeaveBalance.GetActiveLeaveBalanceWOP(leave.UserName);
foreach (DataRow drow in tblLeaveBalance.Rows)
{
if (drow["hasbal"].ToString() == "1")
{
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../../../Support/" + "flgApp2.png" + "' alt='' /></td>" +
"<td class='GridRows'>" + drow["ltdesc"] + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + (drow["hasbal"].ToString() == "1" ? drow["maxbal"] : "-") + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + (drow["hasbal"].ToString() == "1" ? drow["pused"] : "-") + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + (drow["hasbal"].ToString() == "1" ? drow["pbalance"] : "-") + "</td>" +
"</tr>";
}
else
{
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../../../Support/" + "flgCancel.png" + "' alt='' /></td>" +
"<td class='GridRows'>" + drow["ltdesc"] + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + "-" + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + drow["pbalance"].ToString() + "</td>" +
"<td class='GridRows' style='text-align:right;'>" + "-" + "</td>" +
"</tr>";
}
}
Response.Write(strWrite);
}
protected void btnSend_Click(object sender, EventArgs e)
{
string strErrorMessage = "";
DateTime dteFrom = Convert.ToDateTime(dtpFrom.SelectedDate.ToString("M/d/yyyy") + " " + ddlFromTime.SelectedItem.Text);
DateTime dteTo = Convert.ToDateTime(dtpTo.SelectedDate.ToString("M/d/yyyy") + " " + ddlToTime.SelectedItem.Text);
if (dteFrom >= dteTo)
{
strErrorMessage += "<br>You entered an invalid date bracket.";
}
if (ddlType.Items.Count == 0)
{
strErrorMessage += "<br>Please select leave type.";
}
if (clsLeave.HasExistingApplication(Request.Cookies["Speedo"]["UserName"], dteFrom, dteTo))
{
strErrorMessage += "<br>You already filed an application within this date bracket.";
}
if (!clsLeave.HasEnoughBalance(clsValidator.CheckFloat(txtUnits.Text), _strUsername, ddlType.SelectedValue))
{
strErrorMessage += "<br>Not enough balance.";
}
if (strErrorMessage.Length == 0)
{
clsLeave leave = new clsLeave();
leave.LeaveType = ddlType.SelectedValue;
leave.UserName = _strUsername;
leave.DateFile = DateTime.Now;
leave.DateStart = Convert.ToDateTime(dtpFrom.SelectedDate.ToString("M/d/yyyy") + " " + ddlFromTime.SelectedItem.Text);
leave.DateEnd = Convert.ToDateTime(dtpTo.SelectedDate.ToString("M/d/yyyy") + " " + ddlToTime.SelectedItem.Text);
leave.Units = float.Parse(txtUnits.Text);
leave.Reason = txtReason.Text;
leave.ApproverName = ddlApprover.SelectedValue;
leave.Insert();
//ADDED by CALVIN CAVITE FEB 15, 2018
ScriptManager.RegisterStartupScript(this, this.GetType(), "none", "ModalSuccess();", true);
//ScriptManager.RegisterStartupScript(this, GetType(), "Success!", "alert('Your Leave has been filed and under for approval'); window.location='" + Request.ApplicationPath + "HR/HRMS/Leave/LeaveMenu.aspx';", true);
//Response.Redirect("LeaveMenu.aspx");
}
else
{
divError.Visible = true;
lblErrMsg.Text = strErrorMessage;
}
}
protected void btnDisApprove_Click(object sender, EventArgs e)
{
using (clsLeave leave = new clsLeave())
{
leave.LeaveCode = Request.QueryString["leavcode"].ToString();
leave.Fill();
leave.ApproverRemarks = txtApproverRemarks.Text;
leave.ApproverDate = DateTime.Now;
if (leave.Disapprove())
{
//ADDED by CALVIN CAVITE FEB 15, 2018
ScriptManager.RegisterStartupScript(this, GetType(), "Success!", "ModalDisapprove();", true);
}
}
}
public void LoadLeaveTypeByDLL()
{
string strPicture = "";
string strWrite = "";
string strLeaveDescription = txtLeaveType.Text.ToUpper();
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
DataTable tblLeaveBalance = clsLeave.GetRecord(leave.UserName, ddlLeaveType.SelectedValue.ToString());
foreach (DataRow drow in tblLeaveBalance.Rows)
{
if (drow["leavstat"].ToString() == "A")
{
strPicture = "approved.png";
}
else if (drow["leavstat"].ToString() == "D")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "C")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "F")
{
strPicture = "Approval.png";
}
strWrite = strWrite + "<tr>" +
"<td class='GridRows' style='text-align:left;'>" + Convert.ToDateTime(drow["datefile"].ToString()).ToLongDateString() + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + drow["units"].ToString() + "</td>" +
"<td class='GridRows' style='text-align:left;'>" + clsString.CutString(drow["reason"].ToString(), 70) + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + clsUsers.GetName(drow["apphname"].ToString()) + "</td>" +
"<td class='GridRows' align='center'><img src='../../../Support/" + strPicture + "' alt='' align='middle' /></td>" +
"</tr>";
}
lblWriteLeaveTypeList.Text = strWrite;
}
public void Gridauthorbind()
{
try
{
objauth = new clsLeave();
objdt = new DataTable();
// objds = new DataSet();
objauth.Action = "Grid";
objauth.SchoolCode = Convert.ToString(Session["SchoolCode"]);
objauth.UserCode = Convert.ToString(Session["UserCode"]);
objdt = objauth.Insert_LeavesDetails();
if (objdt.Rows.Count > 0)
{
if (objdt.Rows[0]["Status1"].ToString() == "Staff")
{
gridAuthor.DataSource = objdt;
gridAuthor.DataBind();
}
else if (objdt.Rows[0]["Status1"].ToString() == "Co-Ordinator")
{
gridAuthor.DataSource = objdt;
gridAuthor.DataBind();
}
else
{
gridAuthor.DataSource = objdt;
gridAuthor.DataBind();
}
}
else
{
gridAuthor.DataSource = null;
gridAuthor.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
ViewState["PreviousURL"] = Page.Request.UrlReferrer.ToString();
//clsLeave.AuthenticateAccessForm(LeaveUsers.Requestor, Request.Cookies["Speedo"]["UserName"], Request.QueryString["leavcode"].ToString());
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
txtLeaveCode.Text = leave.LeaveCode;
txtLeaveType.Text = clsLeaveType.GetDescription(leave.LeaveType);
txtDateFiled.Text = leave.DateFile.ToString("MMM dd, yyyy hh:mm tt");
txtRequestorName.Text = clsUsers.GetName(leave.UserName);
txtStatus.Text = clsLeave.ToLeaveStatusDesc(leave.Status);
txtDateFrom.Text = leave.DateStart.ToString("MMM dd, yyyy hh:mm tt");
txtDateTo.Text = leave.DateEnd.ToString("MMM dd, yyyy hh:mm tt");
txtUnits.Text = leave.Units.ToString();
txtReason.Text = leave.Reason;
txtApproverName.Text = clsUsers.GetName(leave.ApproverName);
txtApproverDate.Text = clsValidator.CheckMinDateTime(leave.ApproverDate);
txtApproverRemarks.Text = leave.ApproverRemarks;
}
}
protected void grdAuthor_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "EditRow")
{
objauth = new clsLeave();
objdt = new DataTable();
DataTable Temp = new DataTable();
objauth.SchoolCode = Convert.ToString(Session["SchoolCode"]);
objauth.id = Convert.ToInt32(e.CommandArgument.ToString());
objauth.UserCode = Convert.ToString(Session["UserCode"]);
objauth.Action = "Gridbyid";
objds = objauth.Grid_LeavesDetails();
if (objds.Tables.Count > 0)
{
if (objds.Tables[0].Rows.Count > 0)
{
Temp = objds.Tables[0];
hdn.Value = e.CommandArgument.ToString();
DDLteacher.SelectedValue = Temp.Rows[0]["Teacher_Code"].ToString();
// DropdownTeacher_SelectedIndexChanged(sender, null);
//TextLessionDetails.Text = Temp.Rows[0]["LessonDetails"].ToString();
// txttopics.Text = Temp.Rows[0]["Topics"].ToString();
TextBoxToDate.Text = Temp.Rows[0]["To_Date"].ToString();
TextBoxFromDate.Text = Temp.Rows[0]["From_date"].ToString();
rbltype.SelectedValue = Temp.Rows[0]["type"].ToString();
txtReason.Text = Temp.Rows[0]["Reason_type"].ToString();
RblPri.SelectedValue = Temp.Rows[0]["Prin_Status"].ToString();
RblCo.SelectedValue = Temp.Rows[0]["Co_status"].ToString();
RblVfy.SelectedValue = Temp.Rows[0]["Coordinator_Verify"].ToString();
if (Temp.Rows[0]["User_Status"].ToString() == "True")
{
trstatus.Visible = false;
trPrinstatus.Visible = true;
}
else if (Temp.Rows[0]["User_Status"].ToString() == "false")
{
trstatus.Visible = false;
trPrinstatus.Visible = false;
}
else
{
trstatus.Visible = true;
tr4.Visible = true;
trPrinstatus.Visible = false;
}
// RadioButtonListStatus.SelectedValue = Temp.Rows[0]["Status"].ToString();
DivAddNew.Visible = true;
DDLteacher.Enabled = false;
ddlGame.Enabled = false;
trfromTo.Visible = true;
trTo.Visible = true;
TextBoxFromDate.Enabled = false;
TextBoxToDate.Enabled = false;
//hdn.Value = "";
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSaveSubmit_Click(object sender, EventArgs e)
{
try
{
if (validation() == 1)
{
objauth = new clsLeave();
objdt = new DataTable();
// objds = new DataSet();
objauth.SchoolCode = Convert.ToString(Session["SchoolCode"]);
objauth.UserCode = Convert.ToString(Session["UserCode"]);
// gridrecipt1.
objauth.type = rbltype.SelectedValue;
objauth.Reason_type = txtReason.Text;
objauth.Co_status = RblCo.SelectedValue;
objauth.Prin_Status = RblPri.SelectedValue;
if (TextBoxFromDate.Text != "")
{
try
{
objauth.From_Date = Convert.ToDateTime(TextBoxFromDate.Text);
}
catch (Exception)
{
objauth.From_Date = DateTime.Parse(TextBoxFromDate.Text);
}
}
else
{
TextBoxFromDate.Text = "";
}
if (TextBoxToDate.Text != "")
{
try
{
objauth.To_Date = Convert.ToDateTime(TextBoxToDate.Text);
}
catch (Exception)
{
objauth.To_Date = DateTime.Parse(TextBoxToDate.Text);
}
}
else
{
TextBoxToDate.Text = "";
}
objauth.Leave_Type = ddlGame.SelectedValue;
objauth.Staff_Code = DDLteacher.SelectedValue;
objauth.Coordinator_Verify = RblVfy.SelectedValue;
// objFeePay.BankName = TextBoxBankName.Text;
if (hdn.Value == "")
{
objauth.Action = "Insert";
objdt = objauth.Insert_LeavesDetails();
if (objdt.Rows.Count > 0)
{
if (objdt.Rows[0][0].ToString() == "1")
{
ShowMsg("Data Insert Successfully");
// Gridauthorbind();
DivAddNew.Visible = false;
Gridauthorbind();
// DivGrid.Visible = true;
// Gridauthorbind();
// ButtonAddNew.Visible = true;
// ButtonView.Visible = false;
// clear();
}
}
}
else
{
objauth.Action = "Update";
objauth.id = Convert.ToInt32(hdn.Value);
objdt = objauth.Insert_LeavesDetails();
if (objdt.Rows.Count > 0)
{
if (objdt.Rows[0][0].ToString() == "1")
{
ShowMsg("Data Update Successfully");
// clear();
DivAddNew.Visible = false;;
DivGrid.Visible = true;
Gridauthorbind();
// ButtonAddNew.Visible = true;
//ButtonView.Visible = false;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!clsLeave.AuthenticateAccess(Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["leavcode"].ToString()))
{
Response.Redirect("~/AccessDenied.aspx");
}
if (!Page.IsPostBack)
{
ddlLeaveType.DataSource = clsLeaveType.DdlDs();
ddlLeaveType.DataValueField = "pvalue";
ddlLeaveType.DataTextField = "ptext";
ddlLeaveType.DataBind();
try
{
ddlLeaveType.SelectedValue = clsLeave.getLeaveType(Request.QueryString["leavcode"].ToString());
}
catch { }
clsLeave.AuthenticateAccessForm(LeaveUsers.Approver, Request.Cookies["Speedo"]["UserName"], Request.QueryString["leavcode"].ToString());
clsLeave leave = new clsLeave();
leave.LeaveCode = Request.QueryString["leavcode"].ToString();
leave.Fill();
txtLeaveCode.Text = leave.LeaveCode;
txtRequestorName.Text = clsUsers.GetName(leave.UserName);
hdnRequestor.Value = leave.UserName;
txtLeaveType.Text = clsLeaveType.GetDescription(leave.LeaveType);
hdnLeaveTypeCode.Value = leave.LeaveType;
txtDateFiled.Text = leave.DateFile.ToString("MMM dd, yyyy hh:mm tt");
txtDateFrom.Text = leave.DateStart.ToString("MMM dd, yyyy hh:mm tt");
txtDateTo.Text = leave.DateEnd.ToString("MMM dd, yyyy hh:mm tt");
txtUnits.Text = leave.Units.ToString();
txtReason.Text = leave.Reason;
txtApproverName.Text = clsUsers.GetName(leave.ApproverName);
txtApproverRemarks.Text = leave.ApproverRemarks;
txtStatus.Text = clsLeave.ToLeaveStatusDesc(leave.Status);
if (clsLeaveType.IsHasBalance(hdnLeaveTypeCode.Value))
{
txtBalance.Text = clsLeaveBalance.GetRemainingBalance(hdnLeaveTypeCode.Value, hdnRequestor.Value).ToString();
}
else
{
txtBalance.Text = "NA";
}
btnApprove.Visible = (leave.Status == "F");
btnDisApprove.Visible = (leave.Status == "F");
//added by charlie start
clsDepartmentApprover.AuthenticateAccessFormWOP(leave.UserName, Request.Cookies["Speedo"]["UserName"]);
string strLeaveDescription = txtLeaveType.Text.ToUpper();
string strLeaveWithPay = "";
if (strLeaveDescription.Contains("EMERGENCY LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Emergency Leave");
}
else if (strLeaveDescription.Contains("VACATION LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Vacation Leave");
}
else if (strLeaveDescription.Contains("SICK LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Sick Leave");
}
if (strLeaveWithPay.Length != 0)
{
lblLeaveType.Text = clsLeaveSetting.GetDescription(strLeaveWithPay) + " Application";
}
else
{
lblLeaveType.Text = "Leave of Absence Application";
}
//add by charlie end
this.LoadLeaveTypeListNoPay();
}
}
protected void LoadLeaveTypeListNoPay() //added by charlie function LoadLeaveTypeListNoPay
{
string strPicture = "";
string strWrite = "";
string strLeaveDescription = txtLeaveType.Text.ToUpper();
string strLeaveWithPay = "";
if (strLeaveDescription.Contains("WITHOUT PAY"))
{
if (strLeaveDescription.Contains("EMERGENCY LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Emergency Leave");
}
else if (strLeaveDescription.Contains("VACATION LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Vacation Leave");
}
else if (strLeaveDescription.Contains("SICK LEAVE"))
{
strLeaveWithPay = clsLeaveSetting.GetCode("Sick Leave");
}
else
{
strLeaveWithPay = "";
}
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
DataTable tblLeaveBalance = clsLeave.GetRecord(leave.UserName, leave.LeaveType);
foreach (DataRow drow in tblLeaveBalance.Rows)
{
if (drow["leavstat"].ToString() == "A")
{
strPicture = "approved.png";
}
else if (drow["leavstat"].ToString() == "D")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "C")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "F")
{
strPicture = "Approval.png";
}
strWrite = strWrite + "<tr>" +
"<td class='GridRows' style='text-align:left;'>" + Convert.ToDateTime(drow["datefile"].ToString()).ToLongDateString() + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + drow["units"].ToString() + "</td>" +
"<td class='GridRows' style='text-align:left;'>" + clsString.CutString(drow["reason"].ToString(), 70) + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + clsUsers.GetName(drow["apphname"].ToString()) + "</td>" +
"<td class='GridRows' align='center'><img src='../../../Support/" + strPicture + "' alt='' align='middle' /></td>" +
"</tr>";
}
DataTable tblLeaveBalance2 = clsLeave.GetRecord(leave.UserName, strLeaveWithPay);
if (tblLeaveBalance2.Rows.Count == 0)
{
//Response.Write(strWrite);
lblWriteLeaveTypeList.Text = strWrite;
}
else
{
foreach (DataRow drow2 in tblLeaveBalance2.Rows)
{
if (drow2["leavstat"].ToString() == "A")
{
strPicture = "approved.png";
}
else if (drow2["leavstat"].ToString() == "D")
{
strPicture = "Disapproved.png";
}
else if (drow2["leavstat"].ToString() == "C")
{
strPicture = "Disapproved.png";
}
else if (drow2["leavstat"].ToString() == "F")
{
strPicture = "Approval.png";
}
strWrite = strWrite + "<tr>" +
"<td class='GridRows' style='text-align:left;'>" + Convert.ToDateTime(drow2["datefile"].ToString()).ToLongDateString() + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + drow2["units"].ToString() + "</td>" +
"<td class='GridRows' style='text-align:left;'>" + clsString.CutString(drow2["reason"].ToString(), 70) + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + clsUsers.GetName(drow2["apphname"].ToString()) + "</td>" +
"<td class='GridRows' align='center'><img src='../../../Support/" + strPicture + "' alt='' align='middle' /></td>" +
"</tr>";
}
// Response.Write(strWrite);
lblWriteLeaveTypeList.Text = strWrite;
}
}
//---------------------------------WITH PAY-----------------------------------------------------------------------
else
{
string strLeaveWithPay2 = "";
string strLeaveTypeAlt = "";
//if (strLeaveDescription.Contains("EMERGENCY LEAVE"))
//{
// strLeaveWithPay2 = clsLeaveSetting.GetCode("Emergency Leave");
// strLeaveTypeAlt = clsLeaveType.getLeaveType("EMERGENCY LEAVE WITHOUT PAY");
//}
//else if (strLeaveDescription.Contains("VACATION LEAVE"))
//{
// strLeaveWithPay2 = clsLeaveSetting.GetCode("Vacation Leave");
// strLeaveTypeAlt = clsLeaveType.getLeaveType("VACATION LEAVE WITHOUT PAY");
//}
//else if (strLeaveDescription.Contains("SICK LEAVE"))
//{
// strLeaveWithPay2 = clsLeaveSetting.GetCode("Sick Leave");
// strLeaveTypeAlt = clsLeaveType.getLeaveType("SICK LEAVE WITHOUT PAY");
//}
if (strLeaveDescription.Contains("EMERGENCY LEAVE"))
{
strLeaveWithPay2 = clsLeaveSetting.GetCode("Emergency Leave");
strLeaveTypeAlt = clsLeaveType.getLeaveType("EMERGENCY LEAVE WITH PAY");
}
else if (strLeaveDescription.Contains("VACATION LEAVE"))
{
strLeaveWithPay2 = clsLeaveSetting.GetCode("Vacation Leave");
strLeaveTypeAlt = clsLeaveType.getLeaveType("VACATION LEAVE WITH PAY");
}
else if (strLeaveDescription.Contains("SICK LEAVE"))
{
strLeaveWithPay2 = clsLeaveSetting.GetCode("Sick Leave");
strLeaveTypeAlt = clsLeaveType.getLeaveType("SICK LEAVE WITH PAY");
}
else
{
strLeaveWithPay2 = "";
}
clsLeave leave = new clsLeave(Request.QueryString["leavcode"].ToString());
leave.Fill();
string strLeaveWithoutPay = clsLeaveType.GetDescription(leave.LeaveCode).ToUpper();
DataTable tblLeaveBalance = clsLeave.GetRecord(leave.UserName, strLeaveTypeAlt);
foreach (DataRow drow in tblLeaveBalance.Rows)
{
if (drow["leavstat"].ToString() == "A")
{
strPicture = "approved.png";
}
else if (drow["leavstat"].ToString() == "D")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "C")
{
strPicture = "Disapproved.png";
}
else if (drow["leavstat"].ToString() == "F")
{
strPicture = "Approval.png";
}
strWrite = strWrite + "<tr>" +
"<td class='GridRows' style='text-align:left;'>" + Convert.ToDateTime(drow["datefile"].ToString()).ToLongDateString() + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + drow["units"].ToString() + "</td>" +
"<td class='GridRows' style='text-align:left;'>" + clsString.CutString(drow["reason"].ToString(), 70) + "</td>" +
"<td class='GridRows' style='text-align:center;'>" + clsUsers.GetName(drow["apphname"].ToString()) + "</td>" +
"<td class='GridRows' align='center'><img src='../../../Support/" + strPicture + "' alt='' align='middle' /></td>" +
"</tr>";
}
//Response.Write(strWrite);
lblWriteLeaveTypeList.Text = strWrite;
//DataTable tblLeaveBalance2 = clsLeave.GetRecord(leave.UserName, strLeaveWithPay2);
//if (tblLeaveBalance2.Rows.Count == 0)
//{
// Response.Write(strWrite);
//}
//else
//{
// foreach (DataRow drow2 in tblLeaveBalance2.Rows)
// {
// if (drow2["leavstat"].ToString() == "A")
// strPicture = "approved.png";
// else if (drow2["leavstat"].ToString() == "D")
// strPicture = "Disapproved.png";
// else if (drow2["leavstat"].ToString() == "C")
// strPicture = "Disapproved.png";
// else if (drow2["leavstat"].ToString() == "F")
// strPicture = "Approval.png";
// strWrite = strWrite + "<tr>" +
// "<td class='GridRows' style='text-align:left;'>" + Convert.ToDateTime(drow2["datefile"].ToString()).ToLongDateString() + "</td>" +
// "<td class='GridRows' style='text-align:center;'>" + drow2["units"].ToString() + "</td>" +
// "<td class='GridRows' style='text-align:left;'>" + clsString.CutString(drow2["reason"].ToString(), 70) + "</td>" +
// "<td class='GridRows' style='text-align:center;'>" + clsUsers.GetName(drow2["apphname"].ToString()) + "</td>" +
// "<td class='GridRows' align='center'><img src='../../../Support/" + strPicture + "' alt='' align='middle' /></td>" +
// "</tr>";
// }
// Response.Write(strWrite);
//}
}
}
