protected void rcmb_BusinessUnit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rcmb_Employee.Items.Clear();
rv_DailyLog.Style.Add("Display", "none");
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.MODE = 2;
_obj_Smhr_LeaveApp.BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
DataTable dtemp = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
rcmb_Employee.DataSource = dtemp;
if (dtemp.Rows.Count != 0)
{
rcmb_Employee.DataTextField = "EMPNAME";
rcmb_Employee.DataValueField = "EMP_ID";
rcmb_Employee.DataBind();
rcmb_Employee.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
}
else
{
BLL.ShowMessage(this, "There are No employees in this Business Unit, Please select another");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_dailylogreport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_BusinessUnit_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rcmb_Employee.Items.Clear();
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.MODE = 2;
_obj_Smhr_LeaveApp.BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
DataTable dt = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
rcmb_Employee.DataSource = dt;
rcmb_Employee.DataTextField = "EMPNAME";
rcmb_Employee.DataValueField = "EMP_ID";
rcmb_Employee.DataBind();
rcmb_Employee.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
// if we select other businessunit only employees get loading but grid is not refreshing
rg_EmployeeWise.DataSource = null;
rg_EmployeeWise.DataBind();
rg_EmployeeWise.Visible = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_leavetran", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
loadDropdown();
clearControls();
DataTable dt = BLL.get_EmpOTTrans(new SMHR_EMPOTTRANS(Convert.ToInt32(Convert.ToString(e.CommandArgument))));
lbl_OTDetID.Text = Convert.ToString(e.CommandArgument);
rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["BUSINESSUNIT_ID"]));
rcmb_BusinessUnit_SelectedIndexChanged(null, null);
if (Request.QueryString["BUSINESSUNIT_ID"] != null)
{
rcmb_BusinessUnit.Enabled = false;
}
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.BUSINESSUNIT_ID = Convert.ToInt32(Convert.ToString(dt.Rows[0]["BUSINESSUNIT_ID"]));
_obj_Smhr_LeaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(Convert.ToString(dt.Rows[0]["EMPOTTRANS_EMPID"]));
_obj_Smhr_LeaveApp.MODE = 3;
DataTable dtemp = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
rcmb_OTDetEmployeeID.DataSource = dtemp;
//lbl_Curr.Text = Convert.ToString(dtemp.Rows[0]["CURRENCY"]);
rcmb_OTDetEmployeeID.DataTextField = "EMPNAME";
rcmb_OTDetEmployeeID.DataValueField = "EMP_ID";
rcmb_OTDetEmployeeID.DataBind();
rcmb_OTDetEmployeeID.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
rcmb_OTDetEmployeeID.SelectedIndex = rcmb_OTDetEmployeeID.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPOTTRANS_EMPID"]));
rcmb_OTDetEmployeeID_SelectedIndexChanged(null, null);
LoadOTandPeriod();
rcmb_OTDetOTType.SelectedIndex = rcmb_OTDetOTType.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPOTTRANS_TYPEID"]));
rcmb_OTDetPeriodMain.SelectedIndex = rcmb_OTDetPeriodMain.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PERIODMAIN"]));
rcmb_OTDetPeriodMain_SelectedIndexChanged(null, null);
rcmb_OTDetPeriodDetails.SelectedIndex = rcmb_OTDetPeriodDetails.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["EMPOTTRANS_PERIOD_ID"]));
rdtp_OTDetOTDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["EMPOTTRANS_DATE"]);
rtxt_OTDetOTHours.Text = Convert.ToString(dt.Rows[0]["EMPOTTRANS_HOURS"]);
if (Convert.ToString(dt.Rows[0]["EMPOTTRANS_STATUS"]) == "0")
{
btn_Update.Visible = true;
}
else
{
BLL.ShowMessage(this, "This Record cannot be editing as it is already " + (Convert.ToString(dt.Rows[0]["EMPOTTRANS_STATUS"]) == "1" ? "Approved" : "Rejected"));
}
Rm_OT_page.SelectedIndex = 1;
rcmb_BusinessUnit.Enabled = false;
rcmb_OTDetEmployeeID.Enabled = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OTDetails", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Rollback_click(object sender, CommandEventArgs e)
{
try
{
SMHR_LEAVEAPP _obj_smhr_leaveApp1 = new SMHR_LEAVEAPP();
_obj_smhr_leaveApp1.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveApp1.LEAVEAPP_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_leaveApp1.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_leaveApp1.OPERATION = operation.Available;
DataTable dt_Details = BLL.get_LeaveApp(_obj_smhr_leaveApp1);
string str = Convert.ToString(e.CommandArgument);
_obj_smhr_leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_leaveapp.LEAVEAPP_STATUS = 3;
_obj_smhr_leaveapp.LEAVEAPP_EMP_ID = Convert.ToInt32(dt_Details.Rows[0]["EMP_ID"]);
//_obj_smhr_leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_TODATE"]));
_obj_smhr_leaveapp.LEAVE_ROLLBACKDATE = DateTime.Now;
_obj_smhr_leaveapp.LASTMDFBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_ID = Convert.ToInt32(e.CommandArgument);
_obj_smhr_leaveapp.LASTMDFDATE = DateTime.Now;
_obj_smhr_leaveapp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveapp.LEAVEAPP_LEAVETYPE_ID = Convert.ToInt32(dt_Details.Rows[0]["LEAVETYPEID"]);
_obj_smhr_leaveapp.OPERATION = operation.Delete1;
BLL.set_LeaveApp(_obj_smhr_leaveapp);
SMHR_LEAVEBALANCE _obj_smhr_leavebal = new SMHR_LEAVEBALANCE();
_obj_smhr_leavebal.LT_LEAVETYPEID = Convert.ToInt32(dt_Details.Rows[0]["LEAVETYPEID"]);
_obj_smhr_leavebal.OPERATION = operation.Update;
_obj_smhr_leavebal.EMPNAME = Convert.ToString(dt_Details.Rows[0]["EMP_ID"]);
_obj_smhr_leavebal.ORGANISATION_ID = Convert.ToInt32(Convert.ToString(Session["org_ID"]));
_obj_smhr_leavebal.MODE = 8;
_obj_smhr_leavebal.NDays = float.Parse(Convert.ToString(dt_Details.Rows[0]["LEAVEAPP_DAYS"]));
_obj_smhr_leavebal.LEAVEAPP_ID = Convert.ToInt32(e.CommandArgument);
_obj_smhr_leavebal.CREATEDDATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_TODATE"]));
_obj_smhr_leavebal.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
bool rs = BLL.set_leavebalances(_obj_smhr_leavebal);
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadGrid()
{
try
{
SMHR_LEAVEAPP _obj_smhr_leaveApp = new SMHR_LEAVEAPP();
_obj_smhr_leaveApp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_leaveApp.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_leaveApp.OPERATION = operation.Available;
DataTable dt_Details = BLL.get_LeaveApp(_obj_smhr_leaveApp);
Rg_LeaveApp.DataSource = dt_Details;
// Rg_LeaveApp.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_leaveDetails", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadData()
{
try
{
_obj_smhr_leaveapp = new SMHR_LEAVEAPP();
//_obj_smhr_leaveapp.OPERATION = operation.Check;
_obj_smhr_leaveapp.OPERATION = operation.Validate1;
_obj_smhr_leaveapp.LEAVEAPP_EMP_ID = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.ORGANISATION_ID = Convert.ToInt32(Convert.ToString(Session["org_ID"]));
_obj_smhr_leaveapp.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
dt_Details = new DataTable();
dt_Details = BLL.get_LeaveApp(_obj_smhr_leaveapp);
RG_LeaveApproval.DataSource = dt_Details;
//RG_LeaveApproval.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadEmployees()
{
try
{
SMHR_LEAVEAPP _obj_smhr_leaveApp = new SMHR_LEAVEAPP();
_obj_smhr_leaveApp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_leaveApp.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_leaveApp.OPERATION = operation.Delete;
DataTable dt_Details = BLL.get_LeaveApp(_obj_smhr_leaveApp);
rcmb_Employee.DataSource = dt_Details;
rcmb_Employee.DataTextField = "EMPNAME";
rcmb_Employee.DataValueField = "EMP_ID";
rcmb_Employee.DataBind();
rcmb_Employee.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_leaveBalances", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_BU_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rcmb_emp.Items.Clear();
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.MODE = 2;
_obj_Smhr_LeaveApp.BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BU.SelectedItem.Value);
rcmb_emp.DataSource = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
rcmb_emp.DataTextField = "EMPNAME";
rcmb_emp.DataValueField = "EMP_ID";
rcmb_emp.DataBind();
rcmb_emp.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
rg_EmployeeLeavedetail.Visible = false;
rd_Periodlist.ClearSelection();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_leavetran", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
ddl_BusinessUnit.Items.Clear();
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.MODE = 1;
ddl_BusinessUnit.DataSource = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
ddl_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
ddl_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
ddl_BusinessUnit.DataBind();
ddl_BusinessUnit.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
DataTable dt = BLL.get_Year(2);
rtxt_Period.Text = Convert.ToString(dt.Rows[0][0]);
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_YearEndLeaveProcess", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Reject_Click(object sender, EventArgs e)
{
try
{
CheckBox chkBox = new CheckBox();
Label lblID = new Label();
Label lblempid = new Label();
RadTextBox rtxt_rej_reason = new RadTextBox();
int i = 0;
Label1.Text = "";
bool status = false;
bool status1 = false;
for (i = 0; i < RG_LeaveApproval.Items.Count; i++)
{
chkBox = RG_LeaveApproval.Items[i].FindControl("chk_Choose") as CheckBox;
lblID = RG_LeaveApproval.Items[i].FindControl("lblLeavetypeid") as Label;
lblempid = RG_LeaveApproval.Items[i].FindControl("lblempID") as Label;
rtxt_rej_reason = RG_LeaveApproval.Items[i].FindControl("rtxt_rej_reason") as RadTextBox;
if (chkBox.Checked)
{
if (Label1.Text == "")
{
Label1.Text = lblID.Text;
}
else
{
Label1.Text = Label1.Text + "," + lblID.Text;
}
if (Convert.ToString(rtxt_rej_reason.Text) == string.Empty)
{
BLL.ShowMessage(this, "Please Enter Comments For rejection"); return;
}
_obj_smhr_leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_leaveapp.LEAVEAPP_REASON = lblID.Text;
_obj_smhr_leaveapp.LEAVEAPP_STATUS = 2;
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDATE = Convert.ToDateTime(rdp_ApprovalDate.SelectedDate.Value);
_obj_smhr_leaveapp.LASTMDFBY = 1;
_obj_smhr_leaveapp.LASTMDFDATE = DateTime.Now;
_obj_smhr_leaveapp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveapp.LEAVEAPP_REJECT_REASON = Convert.ToString(rtxt_rej_reason.Text.Replace("'", "''"));
_obj_smhr_leaveapp.OPERATION = operation.Check;
status = BLL.set_LeaveApp(_obj_smhr_leaveapp);
if (status == true)
{
//BLL.ShowMessage(this, "Selected Leaves Rejected");
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(lblempid.Text);
_obj_Smhr_LeaveApp.MODE = 4;
DataTable dt_mail = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
if (dt_mail.Rows.Count > 0)
{
//if (!((dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["REPORTING_EMP"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP"] != string.Empty)))
if (((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP"]) != string.Empty) && ((dt_mail.Rows[0]["REPORTING_EMP"]) != System.DBNull.Value)))
{
_obj_Smhr_LeaveApp.MODE = 3;
_obj_Smhr_LeaveApp.LEAVEAPP_ID = Convert.ToInt32(lblID.Text);
if (BLL.get_Leave_Mail(_obj_Smhr_LeaveApp))
{
status1 = true;
}
}
}
}
}
//else
//{
// i = i + 1;
//}
}
if (string.IsNullOrEmpty(Label1.Text))
{
BLL.ShowMessage(this, "Please Select Employees");
return;
}
if (status)
{
if (status1)
{
BLL.ShowMessage(this, "Selected Leave Rejected and Notification Sent");
}
else
{
BLL.ShowMessage(this, "Selected Leave Rejected");
}
}
LoadData();
RG_LeaveApproval.DataBind();
return;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Approve_Click(object sender, EventArgs e)
{
try
{
CheckBox chkBox = new CheckBox();
Label lblAppID = new Label();
Label lblempid = new Label();
Label lblNoDays = new Label();
Label lblLeaveID = new Label();
Label lblLeaveCode = new Label();
Label lblPrdID = new Label();
RadTextBox rtxt_rej_reason = new RadTextBox();
bool status = false;
bool status1 = false;
//string str = "";
//string str1 = "";
for (int index = 0; index <= RG_LeaveApproval.Items.Count - 1; index++)
{
string str = "";
string str1 = "";
chkBox = RG_LeaveApproval.Items[index].FindControl("chk_Choose") as CheckBox;
lblAppID = RG_LeaveApproval.Items[index].FindControl("lblLeavetypeid") as Label;
lblempid = RG_LeaveApproval.Items[index].FindControl("lblempID") as Label;
lblNoDays = RG_LeaveApproval.Items[index].FindControl("lblempLeaveDays") as Label;
lblLeaveID = RG_LeaveApproval.Items[index].FindControl("lblLeaveID") as Label;
lblLeaveCode = RG_LeaveApproval.Items[index].FindControl("lblempLeave") as Label;
lblPrdID = RG_LeaveApproval.Items[index].FindControl("lblPrdID") as Label;
rtxt_rej_reason = RG_LeaveApproval.Items[index].FindControl("rtxt_rej_reason") as RadTextBox;
if (chkBox.Checked)
{
I_ChkCount = I_ChkCount + 1;
if (str == "")
{
str = "" + lblAppID.Text + "";
}
else
{
str = str + "," + lblAppID.Text + "";
}
if (str1 == "")
{
str1 = "" + lblempid.Text + "";
}
_obj_smhr_leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_leaveapp.LEAVEAPP_REASON = str;
_obj_smhr_leaveapp.LEAVEAPP_STATUS = 1;
_obj_smhr_leaveapp.LEAVEAPP_EMP_ID = Convert.ToInt32(str1);
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDATE = Convert.ToDateTime(rdp_ApprovalDate.SelectedDate.Value);
_obj_smhr_leaveapp.LASTMDFBY = 1;
_obj_smhr_leaveapp.LASTMDFDATE = DateTime.Now;
_obj_smhr_leaveapp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveapp.LEAVEAPP_LEAVETYPE_ID = Convert.ToInt32(lblLeaveID.Text);
_obj_smhr_leaveapp.LEAVEAPP_REJECT_REASON = Convert.ToString(rtxt_rej_reason.Text.Replace("'", "''"));
/*if (lblLeaveCode.Text.Trim() != "LOP")
* {
* //TO GET LEAVEBALANCES OF EMPLOYEE
* _obj_smhr_leaveapp.OPERATION = operation.Select1;
* DataTable dt_bal = BLL.get_LeaveApp(_obj_smhr_leaveapp);
* if (dt_bal.Rows.Count > 0)
* {
* if (Convert.ToDouble(dt_bal.Rows[0]["LT_CURRENTBALANCE"]) <= 0.00)
* {
* BLL.ShowMessage(this, "Employee Does Not Have Leaves For This LeaveType.");
* return;
* }
* if (Convert.ToDouble(dt_bal.Rows[0]["LT_CURRENTBALANCE"]) < Convert.ToDouble(lblNoDays.Text))
* {
* BLL.ShowMessage(this, "Employee Has Only " + Convert.ToDouble(dt_bal.Rows[0]["LT_CURRENTBALANCE"]) + " Balances.");
* return;
* }
*
* }
* else
* {
* BLL.ShowMessage(this, "Employee Does Not Have Balances For Selected Leave Type.");
* return;
* }
* }*/
_obj_smhr_leaveapp.OPERATION = operation.Check;
status = BLL.set_LeaveApp(_obj_smhr_leaveapp);
if (lblLeaveCode.Text.Trim() != "LOP")
{
if (status == true)
{
SMHR_LEAVEBALANCE _obj_smhr_leavebal = new SMHR_LEAVEBALANCE();
_obj_smhr_leavebal.LT_LEAVETYPEID = Convert.ToInt32(lblLeaveID.Text);
_obj_smhr_leavebal.OPERATION = operation.Update;
_obj_smhr_leavebal.EMPNAME = str1;
_obj_smhr_leavebal.MODE = 9; //5;
_obj_smhr_leavebal.NDays = float.Parse(lblNoDays.Text);
_obj_smhr_leavebal.LEAVEAPP_ID = Convert.ToInt32(lblAppID.Text);
_obj_smhr_leavebal.CREATEDDATE = Convert.ToDateTime(rdp_ApprovalDate.SelectedDate.Value);
_obj_smhr_leavebal.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if (lblPrdID.Text != string.Empty)
{
_obj_smhr_leavebal.LT_PRD_ID = Convert.ToInt32(lblPrdID.Text);
}
_obj_smhr_leavebal.LT_EMPID = Convert.ToInt32(lblempid.Text);
bool rs = BLL.set_leavebalances(_obj_smhr_leavebal);
//BLL.ShowMessage(this, "Selected Leave approved and Leave Balance Updated");
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(str1);
_obj_Smhr_LeaveApp.LEAVEAPP_ID = Convert.ToInt32(lblAppID.Text);
_obj_Smhr_LeaveApp.MODE = 4;
DataTable dt_mail = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
if (dt_mail.Rows.Count > 0)
{
//if (!((dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["REPORTING_EMP"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP"] != string.Empty)))
if (((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP"]) != string.Empty) && ((dt_mail.Rows[0]["REPORTING_EMP"]) != System.DBNull.Value)))
{
_obj_Smhr_LeaveApp.MODE = 2;
if (BLL.get_Leave_Mail(_obj_Smhr_LeaveApp))
{
status1 = true;
//BLL.ShowMessage(this, "Notification Sent");
}
}
}
//LoadData();
//return;
}
}
else
{
if (status == true)
{
//BLL.ShowMessage(this, "Selected Leave Approved.");
}
}
}
//}
//if (string.IsNullOrEmpty(str))
//{
// BLL.ShowMessage(this, "Please Select Employees");
// return;
//}
}
if (I_ChkCount == 0)
{
BLL.ShowMessage(this, "Please Select Employees");
return;
}
if (status)
{
if (status1)
{
BLL.ShowMessage(this, "Selected Leave Approved And Leave Balance Updated And Notification Sent");
}
else
{
BLL.ShowMessage(this, "Selected Leave Approved And Leave Balance Updated");
}
}
LoadData();
RG_LeaveApproval.DataBind();
return;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
Session["DASHBOARD"] = "true";
}
if (Convert.ToString(Session["EMP_ID"]) == "")
{
Response.Redirect("Login.aspx", false);
}
if (!Page.IsPostBack)
{
lbl_Birthday.Text = "BIRTHDAY REMINDERS - " + DateTime.Now.ToLongDateString().ToUpper();
getBirthday();
string str_Loginid = Convert.ToString(Session["USER_ID"]);
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
//CODE FOR FETCHING EMPLOYEE NAME
_obj_smhr_Dashboard.OPERATION = operation.Select;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(str_Loginid);
DataTable dt_getEMP_NAME = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_getEMP_NAME.Rows.Count != 0)
{
lbl_EmpName.Text = Convert.ToString(dt_getEMP_NAME.Rows[0][0]);
lbl_EmpBloodGroup.Text = Convert.ToString(dt_getEMP_NAME.Rows[0][1]);
}
else
{
BLL.ShowMessage(this, "No employee name exists for this login id");
//Response.Redirect("~/Login.aspx");
}
//CODE FOR FETCHING EMPLOYEE ID
_obj_smhr_Dashboard.OPERATION = operation.Select_Emp;
_obj_smhr_Dashboard.SMHR_DASHBOARD_LOGIN_ID = Convert.ToInt32(str_Loginid);
DataTable dt_getEMP_ID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
string STR_EMP_ID = Convert.ToString(dt_getEMP_ID.Rows[0][0]);
lbl_EmpId.Text = STR_EMP_ID;
//CODE FOR FETCHING EMPLOYEE DESIGNATION
_obj_smhr_Dashboard.OPERATION = operation.Select_Pos;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_getEMP_DESG = BLL.get_EMP_ID(_obj_smhr_Dashboard);
lbl_EmpDesignation.Text = Convert.ToString(dt_getEMP_DESG.Rows[0][0]);
//CODE FOR FETCHING EMPLOYEE DEPARTMENT
_obj_smhr_Dashboard.OPERATION = operation.Select_Dept;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_getEMP_DEPT = BLL.get_EMP_ID(_obj_smhr_Dashboard);
lbl_EmpDepartment.Text = Convert.ToString(dt_getEMP_DEPT.Rows[0][0]);
//NO of Pending Leave Applications
_obj_smhr_Leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_Leaveapp.OPERATION = operation.Check_New;
_obj_smhr_Leaveapp.LEAVEAPP_STATUS = Convert.ToInt32(0);
_obj_smhr_Leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingLeave = BLL.get_LeaveApp(_obj_smhr_Leaveapp);
lbl_pendingleave.Text = Convert.ToString(dt_NoOfPendingLeave.Rows[0][0]);
//No of Pending Comp-Off Application
_obj_smhr_Compoff = new SMHR_EMPCOMOFF();
_obj_smhr_Compoff.OPERATION = operation.Check_New;
_obj_smhr_Compoff.EMPCOMPOFF_STATUS = Convert.ToInt32(0);
_obj_smhr_Compoff.EMPCOMPOFF_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingCOMPOFF = BLL.get_empcompffs(_obj_smhr_Compoff);
lbl_pendingcompoff.Text = Convert.ToString(dt_NoOfPendingCOMPOFF.Rows[0][0]);
//No of Pending Expense Applications
_obj_smhr_Expense = new SMHR_EXPENSE();
_obj_smhr_Expense.OPERATION = operation.Check_New;
_obj_smhr_Expense.EXPENSE_STATUS = Convert.ToInt32(0);
_obj_smhr_Expense.EXPENSE_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingExpense = BLL.get_Expense(_obj_smhr_Expense);
lbl_pendingexpense.Text = Convert.ToString(dt_NoOfPendingExpense.Rows[0][0]);
//No of Pending Loan Applications
//EMPLOYEE LEAVE APPLICATION STATUS
_obj_smhr_Leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_Leaveapp.OPERATION = operation.Select_New;
_obj_smhr_Leaveapp.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_leavestatus = BLL.get_LeaveApp(_obj_smhr_Leaveapp);
int int_NoOfLeaves = dt_leavestatus.Rows.Count;
if (int_NoOfLeaves == 0)
{
lbl_MgrLeaveAppStatus.Text = "No leave application status available";
//BLL.ShowMessage(this, "No data available");
}
else
{
int lastLeaveStatus = Convert.ToInt32(dt_leavestatus.Rows[int_NoOfLeaves - 1][0]);
if (lastLeaveStatus == 0)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Pending";
}
else if (lastLeaveStatus == 1)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Approved";
}
else if (lastLeaveStatus == 2)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Rejected";
}
else if (lastLeaveStatus == 3)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Cancelled";
}
else
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Not Found";
}
}
//EMPLOYEE COMP-OFF APPLICATION STATUS
_obj_smhr_Compoff = new SMHR_EMPCOMOFF();
_obj_smhr_Compoff.OPERATION = operation.Select_New;
_obj_smhr_Compoff.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_compoff = BLL.get_empcompffs(_obj_smhr_Compoff);
int int_NoOfCompOff = dt_compoff.Rows.Count;
if (int_NoOfCompOff == 0)
{
lbl_MgrCompOffAppStatus.Text = "No comp-off application status available";
// BLL.ShowMessage(this, "No data available");
}
else
{
int lastCompOffStatus = Convert.ToInt32(dt_compoff.Rows[(int_NoOfCompOff) - 1][0]);
if (lastCompOffStatus == 0)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Pending";
}
else if (lastCompOffStatus == 1)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Approved";
}
else if (lastCompOffStatus == 2)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Applicaiton Rejected";
}
else if (lastCompOffStatus == 3)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Cancelled";
}
else
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Not Found";
}
}
//EMPLOYEE EXPENSE APPLICATION STATUS
_obj_smhr_Expense = new SMHR_EXPENSE();
_obj_smhr_Expense.OPERATION = operation.Select_New;
_obj_smhr_Expense.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_expense = BLL.get_Expense(_obj_smhr_Expense);
int int_NoOfExpense = dt_compoff.Rows.Count;
if (int_NoOfExpense == 0)
{
lbl_MgrExpenseAppStatus.Text = "No expense application status available";
}
else
{
int lastExpenseStatus = Convert.ToInt32(dt_compoff.Rows[(int_NoOfExpense) - 1][0]);
if (lastExpenseStatus == 0)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Pending";
}
else if (lastExpenseStatus == 1)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Approved";
}
else if (lastExpenseStatus == 2)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Rejected";
}
else if (lastExpenseStatus == 3)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Cancelled";
}
else
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Not Found";
}
}
//Modified
#region Pie-Chart for Ytd Balances
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
string str_MonthNo = DateTime.Now.Month.ToString();
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string str_Period_Month = mfi.GetMonthName(Convert.ToInt32(str_MonthNo));
string str_Period_Year = DateTime.Now.Year.ToString();
string str_PeriodName = str_Period_Month.ToUpper() + " " + str_Period_Year;
_obj_smhr_Dashboard.OPERATION = operation.Check_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_PeriodName;
DataTable dt_PeriodID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_PeriodID.Rows.Count == 0)
{
//DataTable dt_ZeroYtdBalance = new DataTable();
//BLL.ShowMessage(this, "No data available");
}
string str_PeriodId = Convert.ToString(dt_PeriodID.Rows[0][0]);
_obj_smhr_Dashboard.OPERATION = operation.Check1;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODID = Convert.ToInt32(str_PeriodId);
DataTable dt_YtdBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_YtdBalance.Rows.Count == 0)
{
DataTable dt_ZeroYtdBalance = new DataTable();
DataRow dr_ZeroYtdBalance = dt_ZeroYtdBalance.NewRow();
DataColumn dc_ZeroYtdBalance = new DataColumn();
DataColumn dc_ZeroPayItem_PayDesc = new DataColumn();
dc_ZeroYtdBalance.ColumnName = "YtdBalance";
dc_ZeroPayItem_PayDesc.ColumnName = "payitem_paydesc";
dt_ZeroYtdBalance.Columns.Add(dc_ZeroYtdBalance);
dt_ZeroYtdBalance.Columns.Add(dc_ZeroPayItem_PayDesc);
dr_ZeroYtdBalance["YtdBalance"] = "0.00";
dr_ZeroYtdBalance["payitem_paydesc"] = "Ytd Balances";
dt_ZeroYtdBalance.Rows.Add(dr_ZeroYtdBalance);
RadChart_YtdBalances.DataSource = dt_ZeroYtdBalance;
RadChart_YtdBalances.DataBind();
//RadChart_YtdBalances.Visible = false;
//BLL.ShowMessage(this, "No data available for ytd balances");
}
else
{
RadChart_YtdBalances.DataSource = dt_YtdBalance;
RadChart_YtdBalances.DataBind();
}
#endregion
//Pie-chart
#region Pie-Chart for Leave Balance
bool status = false;
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
string str_Current_Year = DateTime.Now.Year.ToString();
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_Current_Year;
_obj_smhr_Dashboard.OPERATION = operation.Select_Period;
DataTable dt_Period_ID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
string str_Period_Name = Convert.ToString(dt_Period_ID.Rows[0][0]);
_obj_smhr_Dashboard.OPERATION = operation.Select_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_Period_Name;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_LeaveBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_LeaveBalance.Rows.Count != 0)
{
for (int int_rowcount = 0; int_rowcount < dt_LeaveBalance.Rows.Count; int_rowcount++)
{
if (Convert.ToDouble(dt_LeaveBalance.Rows[int_rowcount]["LT_CURRENTBALANCE"]) == 0.00)
{
//BLL.ShowMessage(this, "No leaves to have fun");
lbl_zeroleave.Visible = true;
lbl_zeroleave.Text = "No leaves available";
status = true;
}
}
if (status == false)
{
RadChart2.Visible = true;
RadChart2.DataSource = dt_LeaveBalance;
RadChart2.DataBind();
}
}
else
{
lbl_zeroleave.Visible = true;
lbl_zeroleave.Text = "No leaves available";
//BLL.ShowMessage(this, "No data available for leave balances");
}
#endregion
#region Pie-Chart for Performance Hikes
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
_obj_smhr_Dashboard.OPERATION = operation.Select_Hike;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_Hike = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_Hike.Rows.Count != 0)
{
for (int int_rowcount = 0; int_rowcount < dt_Hike.Rows.Count; int_rowcount++)
{
if (Convert.ToDouble(dt_Hike.Rows[int_rowcount]["Hike"]) == 0.00)
{
//BLL.ShowMessage(this, "No leaves to have fun");
lbl_zerohike.Visible = true;
lbl_zerohike.Text = "No leaves available";
status = true;
}
}
if (status == false)
{
RadChart_Performance.Visible = true;
RadChart_Performance.DataSource = dt_Hike;
RadChart_Performance.DataBind();
}
}
else
{
lbl_zerohike.Visible = true;
lbl_zerohike.Text = "No leaves to have fun";
//BLL.ShowMessage(this, "No data available for leave balances");
}
#endregion
//Code For scrolling text
//_obj_smhr_Recruitmentupdates = new SMHR_RECRUITMENTUPDATES();
//_obj_smhr_Recruitmentupdates.OPERATION = operation.Select_New;
//_obj_smhr_Recruitmentupdates.SMHR_CURRENTDATE = DateTime.Now;
//DataTable dt_RecruitmentUpdates = BLL.get_RecruitmentUpdates(_obj_smhr_Recruitmentupdates);
//if (dt_RecruitmentUpdates.Rows.Count != 0)
//{
// //string str_ReqName = dt_RecruitmentUpdates.Rows[0]["JOBREQ_REQNAME"].ToString();
// Radticker1.DataSource = dt_RecruitmentUpdates;// dt_RecruitmentUpdates;
// Radticker1.DataTextField = "JOBREQ_UPDATE";
// //Radticker1.DataMember = str_ReqName;
// Radticker1.DataBind();
//}
//else
//{
// BLL.ShowMessage(this, "Recruitment are closed now");
//}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Dashboard1", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public static DataTable get_LeaveApp(SMHR_LEAVEAPP _obj_Smhr_LeaveApp)
{
return(BLL.ExecuteQuery("EXEC USP_SMHR_LEAVEAPP @Operation = 'LEAVEDETAILSROLLBACK', @ORGANISATION_ID = " + _obj_Smhr_LeaveApp.ORGANISATION_ID + ",@EMP_LOGIN_ID='" + _obj_Smhr_LeaveApp.LOGIN_ID + "',@LEAVEAPP_EMP_ID = " + _obj_Smhr_LeaveApp.LEAVEAPP_EMP_ID + ""));
}
protected void Rollback_click(object sender, CommandEventArgs e)
{
try
{
SMHR_LEAVEAPP _obj_smhr_leaveApp1 = new SMHR_LEAVEAPP();
_obj_smhr_leaveApp1.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveApp1.LEAVEAPP_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_leaveApp1.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_leaveApp1.OPERATION = operation.Available;
DataTable dt_Details = BLL.get_LeaveApp(_obj_smhr_leaveApp1);
SMHR_LEAVEAPP _obj_smhr_leaveapp = new SMHR_LEAVEAPP();
string str = Convert.ToString(e.CommandArgument);
_obj_smhr_leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_leaveapp.LEAVEAPP_STATUS = 3;
_obj_smhr_leaveapp.LEAVEAPP_EMP_ID = Convert.ToInt32(dt_Details.Rows[0]["EMP_ID"]);
//_obj_smhr_leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_APPROVEDATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_TODATE"]));
_obj_smhr_leaveapp.LEAVE_ROLLBACKDATE = DateTime.Now;
_obj_smhr_leaveapp.LASTMDFBY = Convert.ToInt32(Convert.ToString(Session["EMP_ID"]));
_obj_smhr_leaveapp.LEAVEAPP_ID = Convert.ToInt32(e.CommandArgument);
_obj_smhr_leaveapp.LASTMDFDATE = DateTime.Now;
_obj_smhr_leaveapp.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_leaveapp.LEAVEAPP_LEAVETYPE_ID = Convert.ToInt32(dt_Details.Rows[0]["LEAVETYPEID"]);
_obj_smhr_leaveapp.OPERATION = operation.Delete1;
BLL.set_LeaveApp(_obj_smhr_leaveapp);
SMHR_LEAVEBALANCE _obj_smhr_leavebal = new SMHR_LEAVEBALANCE();
_obj_smhr_leavebal.LT_LEAVETYPEID = Convert.ToInt32(dt_Details.Rows[0]["LEAVETYPEID"]);
_obj_smhr_leavebal.OPERATION = operation.Update;
_obj_smhr_leavebal.EMPNAME = Convert.ToString(dt_Details.Rows[0]["EMP_ID"]);
_obj_smhr_leavebal.ORGANISATION_ID = Convert.ToInt32(Convert.ToString(Session["org_ID"]));
_obj_smhr_leavebal.MODE = 8;
_obj_smhr_leavebal.NDays = float.Parse(Convert.ToString(dt_Details.Rows[0]["LEAVEAPP_DAYS"]));
_obj_smhr_leavebal.LEAVEAPP_ID = Convert.ToInt32(e.CommandArgument);
_obj_smhr_leavebal.CREATEDDATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_TODATE"]));
bool rs = BLL.set_leavebalances(_obj_smhr_leavebal);
if (rs == true)
{
//BLL.ShowMessage(this, "Leave Successfully Rolled back");
SMHR_LEAVEAPP _obj_Smhr_LeaveApp = new SMHR_LEAVEAPP();
_obj_Smhr_LeaveApp.LEAVEAPP_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_LeaveApp.ORGANISATION_ID = Convert.ToInt32(Convert.ToString(Session["org_ID"]));
_obj_Smhr_LeaveApp.LEAVEAPP_FROMDATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_FROMDATE"]));
_obj_Smhr_LeaveApp.LEAVEAPP_TODATE = Convert.ToDateTime((dt_Details.Rows[0]["LEAVEAPP_TODATE"]));
_obj_Smhr_LeaveApp.LEAVEAPP_DAYS = float.Parse(Convert.ToString(dt_Details.Rows[0]["LEAVEAPP_DAYS"]));
_obj_Smhr_LeaveApp.LEAVEAPP_ID = Convert.ToInt32(e.CommandArgument);
_obj_Smhr_LeaveApp.MODE = 4;
DataTable dt_mail = BLL.get_EmpLeaveDetails(_obj_Smhr_LeaveApp);
if (dt_mail.Rows.Count > 0)
{
//if (!((dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["EMP_EMAIL"] != System.DBNull.Value && dt_mail.Rows[0]["EMP_EMAIL"] != string.Empty) || (dt_mail.Rows[0]["REPORTING_EMP"] != System.DBNull.Value && dt_mail.Rows[0]["REPORTING_EMP"] != string.Empty)))
if (((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["REPORTING_EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["EMP_EMAIL"]) != string.Empty) && (dt_mail.Rows[0]["EMP_EMAIL"]) != System.DBNull.Value) &&
((Convert.ToString(dt_mail.Rows[0]["REPORTING_EMP"]) != string.Empty) && ((dt_mail.Rows[0]["REPORTING_EMP"]) != System.DBNull.Value)))
{
_obj_Smhr_LeaveApp.MODE = 5;
if (BLL.get_Leave_Mail(_obj_Smhr_LeaveApp))
{
BLL.ShowMessage(this, "Leave Successfully Rolled back and Mail Sent");
}
else
{
BLL.ShowMessage(this, "Mail Not Sent");
}
}
}
else
{
BLL.ShowMessage(this, "Leave Successfully Rolled back but Mail not Sent");
}
}
LoadGridrolb();
Rg_rollback.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_leaveDetails", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
