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