private void LoadData()
{
try
{
SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
_obj_smhr_empcompoff.OPERATION = operation.Check1;
_obj_smhr_empcompoff.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_Loanstatus1(_obj_smhr_empcompoff);
Rg_HrMamager.DataSource = dt;
if (dt.Rows.Count != 0)
{
btn_Save.Visible = true;
// btn_Cancel.Visible = true;
}
else
{
btn_Save.Visible = false;
btn_Cancel.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "HrManagerLoan", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Rg_Mamager_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
Label lblIsEnabled = item.FindControl("lblIsEnabled") as Label;
CheckBox chk_Select = item.FindControl("chk_Select") as CheckBox;
if (lblIsEnabled.Text != "")
{
int isEnabled = Convert.ToInt32((item.FindControl("lblIsEnabled") as Label).Text);
chk_Select.Enabled = Convert.ToBoolean(isEnabled);
}
}
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
SMHR_LOANREQUEST _obj_Smhr_BusinessUnit = new SMHR_LOANREQUEST();
_obj_Smhr_BusinessUnit.OPERATION = operation.New;
//as we are getting the status of the loans by passing loanstatus id but not checking corresponding with organisation
_obj_Smhr_BusinessUnit.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
RadComboBox ddlAccount = (RadComboBox)e.Item.FindControl("rcmb_Status");
ddlAccount.DataSource = BLL.get_EmployeeStatus(_obj_Smhr_BusinessUnit);
ddlAccount.DataTextField = "hr_master_desc";
ddlAccount.DataValueField = "Hr_master_id";
ddlAccount.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LoanManagerApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadData()
{
try
{
SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
_obj_smhr_empcompoff.OPERATION = operation.Select3;
Rg_Mamager.DataSource = BLL.get_Error_Log(_obj_smhr_empcompoff);
}
catch (System.Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Error_Log", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Cancel_Click(object sender, EventArgs e)
{
try
{
SMHR_LOANREQUEST _obj_Smhr_Loan = new SMHR_LOANREQUEST();
_obj_Smhr_Loan.OPERATION = operation.Select2;
Label lblid = new Label();
for (int i = 0; i < Rg_HrMamager.Items.Count; i++)
{
lblid = Rg_HrMamager.Items[i].FindControl("Label1") as Label;
}
if (lblid.Text != "")
{
_obj_Smhr_Loan.SMHR_LOANREQUEST_ID = Convert.ToInt32(lblid.Text);
}
DataTable dt = BLL.get_Loanstatus2(_obj_Smhr_Loan);
int j = 0;
if (dt.Rows.Count > 0)
{
j = Convert.ToInt32(dt.Rows[0]["LOANREQUESTSTATUS"]);
}
if (j == 1025)
{
BLL.ShowMessage(this, "You are not authoried to proceed");
return;
}
else
{
if (Session["LOANTYPE"] != null)
{
string str = "1";
if (str == Convert.ToString(Session["LOANTYPE"]))
{
Response.Redirect("~/Payroll/frm_EmpLoanTran.aspx");
}
else
{
Session["LOANTYPE"] = 2;
Response.Redirect("~/Payroll/frm_EmpReducingLoanTran.aspx");
}
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "HrManagerLoan", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Rg_HrMamager_ItemDataBound1(object sender, GridItemEventArgs e)
{
try
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
SMHR_LOANREQUEST _obj_Smhr_BusinessUnit = new SMHR_LOANREQUEST();
_obj_Smhr_BusinessUnit.OPERATION = operation.Get;
RadComboBox ddlAccount = (RadComboBox)e.Item.FindControl("rcmb_Status");
ddlAccount.DataSource = BLL.get_EmployeeStatus1(_obj_Smhr_BusinessUnit);
ddlAccount.DataTextField = "hr_master_desc";
ddlAccount.DataValueField = "Hr_master_id";
ddlAccount.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "HrManagerLoan", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Delete_Command(object sender, CommandEventArgs e)
{
try
{
SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
_obj_smhr_empcompoff.ERROR_LOG_ID = Convert.ToInt32(e.CommandArgument);
if (BLL.set_ErrorLog(_obj_smhr_empcompoff) == true)
{
BLL.ShowMessage(this, "Record deleted successfully");
LoadData1();
}
else
{
BLL.ShowMessage(this, "Record not deleted successfully");
}
}
catch (System.Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Error_Log", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadEmployee()
{
try
{
SMHR_LOANREQUEST _obj_Smhr_BusinessUnit = new SMHR_LOANREQUEST();
_obj_Smhr_BusinessUnit.OPERATION = operation.Validate;
_obj_Smhr_BusinessUnit.LOANREQUEST_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_BusinessUnit.BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
//_obj_Smhr_BusinessUnit.lOANREQUEST_EMPLOYEEID = Convert.ToInt32(Session["USER_ID"]);
rcmb_EmployeeName.Items.Clear();
rcmb_EmployeeName.DataSource = BLL.get_Employee(_obj_Smhr_BusinessUnit);
rcmb_EmployeeName.DataTextField = "employeename";
rcmb_EmployeeName.DataValueField = "emp_id";
rcmb_EmployeeName.DataBind();
rcmb_EmployeeName.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_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
string Status = string.Empty;
SMHR_LOANREQUEST _obj_Smhr_Loan = new SMHR_LOANREQUEST();
_obj_Smhr_Loan.OPERATION = operation.Update1;
RadComboBox lblCode = new RadComboBox();
Label lblid = new Label();
RadComboBox lblCode1 = new RadComboBox();
CheckBox chk_Open = new CheckBox();
RadDatePicker lblMode = new RadDatePicker();
for (int i = 0; i < Rg_HrMamager.Items.Count; i++)
{
lblid = Rg_HrMamager.Items[i].FindControl("Label1") as Label;
lblCode = Rg_HrMamager.Items[i].FindControl("rcmb_Status") as RadComboBox;
lblCode1 = Rg_HrMamager.Items[i].FindControl("rcmb_Loan") as RadComboBox;
chk_Open = Rg_HrMamager.Items[i].FindControl("chkOpen") as CheckBox;
if (chk_Open.Checked == true)
{
_obj_Smhr_Loan.APPROVEDDATE = DateTime.Now;
_obj_Smhr_Loan.APPROVEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_Loan.SMHR_LOANREQUEST_ID = Convert.ToInt32(lblid.Text);
//if (lblCode.Text == "Approved")
//{
// _obj_Smhr_Loan.STATUS = "B";
//}
//else if (lblCode.Text == "Declined")
//{
// _obj_Smhr_Loan.STATUS = "D";
//}
_obj_Smhr_Loan.LoanMode = Convert.ToInt32(lblCode1.SelectedItem.Value);
if (lblCode1.SelectedItem.Value == "1")
{
Session["LOANTYPE"] = 1;
}
else
{
Session["LOANTYPE"] = 2;
}
_obj_Smhr_Loan.STATUS = Convert.ToInt32(lblCode.SelectedItem.Value);
_obj_Smhr_Loan.LEVEL2 = Convert.ToInt32(lblCode.SelectedItem.Value);
_obj_Smhr_Loan.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Loan.LASTMDFDATE = DateTime.Now;
if (BLL.set_HRLoanRequest(_obj_Smhr_Loan))
{
Status = "yes";
}
else
{
Status = "no";
}
}
}
if (string.IsNullOrEmpty(Status))
{
BLL.ShowMessage(this, "Please Select atleast one");
return;
}
if (Status == "yes")
{
BLL.ShowMessage(this, "Information Saved Successfully");
LoadData();
Rg_HrMamager.DataBind();
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "HrManagerLoan", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
CheckBox chk_box1 = new CheckBox();
int j = 0;
for (int i = 0; i < Rg_Mamager.Items.Count; i++)
{
chk_box1 = Rg_Mamager.Items[i].FindControl("chk_Select") as CheckBox;
if (chk_box1.Checked)
{
j = j + 1;
}
}
SMHR_LOANREQUEST _obj_Smhr_Loan = new SMHR_LOANREQUEST();
_obj_Smhr_Loan.OPERATION = operation.Update;
Label lbl_approveid = new Label();
Label lbl_sanctionid = new Label();
SMHR_LOANREQUEST _obj_Smhr_BusinessUnit = new SMHR_LOANREQUEST();
_obj_Smhr_BusinessUnit.OPERATION = operation.New;
//as we are getting the status of the loans by passing loanstatus id but not checking corresponding with organisation
_obj_Smhr_BusinessUnit.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_status = BLL.get_EmployeeStatus(_obj_Smhr_BusinessUnit);
if (dt_status.Rows.Count > 0)
{
for (int i = 0; i < dt_status.Rows.Count; i++)
{
if (Convert.ToString(dt_status.Rows[i]["hr_master_desc"]).Trim() == "Approved")
{
lbl_approveid.Text = Convert.ToString(dt_status.Rows[i]["hr_master_id"]);
}
else
{
lbl_sanctionid.Text = Convert.ToString(dt_status.Rows[i]["hr_master_id"]);
}
}
}
RadComboBox lblCode = new RadComboBox();
Label lblid = new Label();
Label date = new Label();
CheckBox chk_Open = new CheckBox();
RadDatePicker lblMode = new RadDatePicker();
int count = 0;
for (int i = 0; i < Rg_Mamager.Items.Count; i++)
{
chk_Open = Rg_Mamager.Items[i].FindControl("chk_Select") as CheckBox;
if (chk_Open.Checked == true)
{
count++;
}
}
if (count == 0)
{
BLL.ShowMessage(this, "Please Select atleast one Employee");
return;
}
for (int i = 0; i < Rg_Mamager.Items.Count; i++)
{
lblid = Rg_Mamager.Items[i].FindControl("Label1") as Label;
lblCode = Rg_Mamager.Items[i].FindControl("rcmb_Status") as RadComboBox;
lblMode = Rg_Mamager.Items[i].FindControl("lbl_DPname") as RadDatePicker;
chk_Open = Rg_Mamager.Items[i].FindControl("chk_Select") as CheckBox;
if (chk_Open.Checked == true)
{
date.Text = DateTime.Now.ToShortDateString();
_obj_Smhr_Loan.APPROVEDDATE = DateTime.Now;
_obj_Smhr_Loan.APPROVEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Smhr_Loan.SMHR_LOANREQUEST_ID = Convert.ToInt32(lblid.Text);
//if (lblCode.Text == "Approved")
//{
// _obj_Smhr_Loan.STATUS = "B";
//}
//else if (lblCode.Text == "Declined")
//{
// _obj_Smhr_Loan.STATUS = "D";
//}
_obj_Smhr_Loan.LOANNAME = Convert.ToString(Rg_Mamager.Items[i].Cells[7].Text).Replace("'", "''");
_obj_Smhr_Loan.STATUS = Convert.ToInt32(lblCode.SelectedItem.Value);
_obj_Smhr_Loan.LEVEL1 = Convert.ToInt32(lblCode.SelectedItem.Value);
_obj_Smhr_Loan.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Loan.LASTMDFDATE = DateTime.Now;
if (Convert.ToInt32(lbl_approveid.Text) == Convert.ToInt32(lblCode.SelectedItem.Value))
{
_obj_Smhr_Loan.OPERATION = operation.Update;
}
else
{
_obj_Smhr_Loan.OPERATION = operation.Update1;
}
if (BLL.set_LoanRequest(_obj_Smhr_Loan))
{
s = "yes";
}
else
{
s = "no";
}
}
//else
//{
// //BLL.ShowMessage(this, "Please select Choose Option");
// //return;
// s = "no";
//}
}
if (s == "yes")
{
BLL.ShowMessage(this, "Information Saved Sucessfully.");
LoadData();
Rg_Mamager.DataBind();
}
else
{
BLL.ShowMessage(this, "Error Occured While Saving Information.");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LoanManagerApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadData()
{
try
{
DataTable dt;
//if (Convert.ToInt32(Session["EMP_ID"]) == 0)
//{
// SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
// _obj_smhr_empcompoff.OPERATION = operation.Select3;
// _obj_smhr_empcompoff.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// //_obj_smhr_empcompoff.lOANREQUEST_EMPLOYEEID = 57;// Convert.ToInt32(Session["EMP_ID"]);
// dt = BLL.get_EmployeeLoanFinalstatus(_obj_smhr_empcompoff);
// Rg_HrMamager.DataSource = dt;
//}
//else
//{
// SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
// _obj_smhr_empcompoff.OPERATION = operation.Select_Self;
// _obj_smhr_empcompoff.lOANREQUEST_EMPLOYEEID = Convert.ToInt32(Session["EMP_ID"]);
// dt = BLL.get_EmployeeLoanFinalstatus(_obj_smhr_empcompoff);
// Rg_HrMamager.DataSource = dt;
//}
if (Control != null)
{
if ((Convert.ToString(Session["SELFSERVICE"]) == "true" && Control.ToUpper() == "SELFLOAN") || (Convert.ToString(Session["SELFSERVICE"]) == "" && Control.ToUpper() == "SELFLOAN"))
{
SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
_obj_smhr_empcompoff.OPERATION = operation.Select_Self;
_obj_smhr_empcompoff.lOANREQUEST_EMPLOYEEID = Convert.ToInt32(Session["EMP_ID"]);
dt = BLL.get_EmployeeLoanFinalstatus(_obj_smhr_empcompoff);
Rg_HrMamager.DataSource = dt;
}
else
{
BLL.ShowMessage(this, "You do not have Accecc on this Screen!");
return;
}
}
else
{
SMHR_LOANREQUEST _obj_smhr_empcompoff = new SMHR_LOANREQUEST();
_obj_smhr_empcompoff.OPERATION = operation.Select3;
_obj_smhr_empcompoff.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_empcompoff.lOANREQUEST_EMPLOYEEID = 57;// Convert.ToInt32(Session["EMP_ID"]);
dt = BLL.get_EmployeeLoanFinalstatus(_obj_smhr_empcompoff);
Rg_HrMamager.DataSource = dt;
}
dt.Columns.Add("SI_NO");
if (dt.Rows.Count != 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
dt.Rows[j]["SI_NO"] = j + 1;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeLoanStatus", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
