private void LoadSalaryStructure() { rcmb_SalStruct.Items.Clear(); _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.ISDELETED = false; _obj_smhr_salaryStruct.OPERATION = operation.Select; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); if (dt_Details.Rows.Count > 0) { rcmb_SalStruct.DataSource = dt_Details; rcmb_SalStruct.DataTextField = "SALARYSTRUCT_CODE"; rcmb_SalStruct.DataValueField = "SALARYSTRUCT_ID"; rcmb_SalStruct.DataBind(); } rcmb_SalStruct.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("ALL", "-1")); //rcmb_SalStruct.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); if (rcmb_SalStruct.Items.Count > 0) { string control = Convert.ToString(Request.QueryString["Control"]); if (control == "StaffContribution") // for Staff Contribution Report { rcmb_SalStruct.Items.Remove(1); } else { rcmb_SalStruct.Items.Remove(3); rcmb_SalStruct.Items.Remove(2); } } }
private void LoadSalaryStructure() { try { rcmb_SalStruct.Items.Clear(); _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.ISDELETED = false; _obj_smhr_salaryStruct.OPERATION = operation.Select; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); if (dt_Details.Rows.Count > 0) { rcmb_SalStruct.DataSource = dt_Details; rcmb_SalStruct.DataTextField = "SALARYSTRUCT_CODE"; rcmb_SalStruct.DataValueField = "SALARYSTRUCT_ID"; rcmb_SalStruct.DataBind(); } rcmb_SalStruct.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("ALL", "-1")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "PensionStatement", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadEmptyData() { try { _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.OPERATION = operation.EMPTY1; DataTable dt_Details = BLL.get_EmptyValues(_obj_smhr_salaryStruct); Rg_Employeesal.DataSource = dt_Details; Rg_Employeesal.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_emppayelements", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadMainGrid() { try { _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); //_obj_smhr_salaryStruct.ISDELETED = null; _obj_smhr_salaryStruct.OPERATION = operation.Select; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); dtDetails = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); RG_Salary.DataSource = dtDetails; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_SalaryStructure", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadEmptyData() { try { _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.OPERATION = operation.Empty; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_EmptyValues(_obj_smhr_salaryStruct); RG_SalaryStruct.DataSource = dt_Details; RG_SalaryStruct.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpPayElmntNullify", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void rcb_BussinessUnit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e) { try { Rg_Employeesal.Visible = true; if (rcb_BussinessUnit.SelectedIndex != 0) { _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.OPERATION = operation.EMPTY1; DataTable dt_Details = BLL.get_EmptyValues(_obj_smhr_salaryStruct); if (dt_Details.Rows.Count != 0) { Rg_Employeesal.DataSource = dt_Details; Rg_Employeesal.DataBind(); } else { LoadEmptyData(); } } else { BLL.ShowMessage(this, "Business Unit is not available"); return; } rcmb_Payitem.Items.Clear(); _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.OPERATION = operation.Empty; DataTable dt = BLL.get_EmptyValues(_obj_smhr_salaryStruct); rcmb_Payitem.DataSource = dt; rcmb_Payitem.DataValueField = "PAYITEM_ID"; rcmb_Payitem.DataTextField = "PAYITEM_PAYITEMNAME"; rcmb_Payitem.DataBind(); rcmb_Payitem.Items.Insert(0, new RadComboBoxItem("Select")); rcmb_Period.Items.Clear(); rcmb_Period.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_emppayelements", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void loadsalarystruct() { try { _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.OPERATION = operation.LOADSALARY; _obj_smhr_salaryStruct.SALARYSTRUCT_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_salarystruct = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); // RCB_SalaryStructure.DataSource = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); RCB_SalaryStructure.DataTextField = "SALARYSTRUCT_CODE"; RCB_SalaryStructure.DataValueField = "SALARYSTRUCT_ID"; RCB_SalaryStructure.DataSource = dt_salarystruct; RCB_SalaryStructure.DataBind(); RCB_SalaryStructure.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_JobOffers", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadSalStruct() { try { //Salary Structure rcmb_SalStruct.Items.Clear(); _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.ISDELETED = false; _obj_smhr_salaryStruct.OPERATION = operation.Select; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); rcmb_SalStruct.DataSource = dt_Details; rcmb_SalStruct.DataTextField = "SALARYSTRUCT_CODE"; rcmb_SalStruct.DataValueField = "SALARYSTRUCT_ID"; rcmb_SalStruct.DataBind(); string qrystrng = string.Empty; if (Request.QueryString.HasKeys()) { qrystrng = Convert.ToString(Request.QueryString["Control"]); } if (qrystrng == "3") { rcmb_SalStruct.Items.Insert(0, new RadComboBoxItem("Select", "-1")); } else { rcmb_SalStruct.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", "-1")); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeList", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadSalStructure() { try { rcmb_SalaryStructure.Items.Clear(); _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.ISDELETED = false; _obj_smhr_salaryStruct.OPERATION = operation.Select; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); rcmb_SalaryStructure.DataSource = dt_Details; rcmb_SalaryStructure.DataTextField = "SALARYSTRUCT_CODE"; rcmb_SalaryStructure.DataValueField = "SALARYSTRUCT_ID"; rcmb_SalaryStructure.DataBind(); string control = Convert.ToString(Request.QueryString["Control"]); rcmb_SalaryStructure.Items.Insert(0, new RadComboBoxItem("Select", "0")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "VoteCodeEntry", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Save_Click(object sender, EventArgs e) { try { string Code = ""; int i; int j = 0; for (i = 0; i <= RG_SalaryStruct.Items.Count - 1; i++) { Label lblCalMode = new Label(); TextBox txtgetVal = new TextBox(); CheckBox chkBox = new CheckBox(); txtgetVal = RG_SalaryStruct.Items[i].FindControl("txtNumber") as TextBox; lblCalMode = RG_SalaryStruct.Items[i].FindControl("lblCALMODE") as Label; chkBox = RG_SalaryStruct.Items[i].FindControl("chk_Select") as CheckBox; if (Convert.ToString(txtgetVal.Text) != "") { if (Convert.ToString(lblCalMode.Text).ToUpper() == "%AGE") { if (Convert.ToDouble(txtgetVal.Text) > 100) { BLL.ShowMessage(this, "Percentage Value should not exceed 100%"); return; } } if (chkBox.Checked == false) { BLL.ShowMessage(this, "Please Select the Element at Salary Structure"); return; } } else { j = j + 1; } } if (j == RG_SalaryStruct.Items.Count) { BLL.ShowMessage(this, "Please Enter Atleast one Value(s)"); return; } _obj_smhr_salaryStruct = new SMHR_SALARYSTRUCT(); _obj_smhr_salaryStruct.SALARYSTRUCT_CODE = Convert.ToString(txt_SalCode.Text).Replace("'", "''"); _obj_smhr_salaryStruct.OPERATION = operation.Check; _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); if (dt.Rows.Count != 0) { BLL.ShowMessage(this, "Name Entered is already used"); return; } Code = Convert.ToString(txt_SalCode.Text).Replace("'", "''"); bool status = false; _obj_smhr_salaryStruct.SALARYSTRUCT_CODE = Convert.ToString(txt_SalCode.Text).Replace("'", "''"); _obj_smhr_salaryStruct.SALARYSTRUCT_NAME = Convert.ToString(txt_SalName.Text.Replace("'", "''")); _obj_smhr_salaryStruct.SALARYSTRUCT_STARTDATE = Convert.ToDateTime(txt_StartDate.SelectedDate); if (txt_EndDate.SelectedDate.HasValue) { _obj_smhr_salaryStruct.SALARYSTRUCT_ENDDATE = Convert.ToDateTime(txt_EndDate.SelectedDate); } else { _obj_smhr_salaryStruct.SALARYSTRUCT_ENDDATE = null; } _obj_smhr_salaryStruct.SALARYSTRUCT_TYPE = Convert.ToInt32(rcb_Type.SelectedItem.Value); _obj_smhr_salaryStruct.SALARYSTRUCT_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_smhr_salaryStruct.SALARYSTRUCT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_smhr_salaryStruct.SALARYSTRUCT_CREATEDDATE = DateTime.Now; _obj_smhr_salaryStruct.OPERATION = operation.Insert; status = BLL.set_SalaryHeaderDetails(_obj_smhr_salaryStruct); if (status == true) { int index; _obj_smhr_salaryStruct.OPERATION = operation.Check; _obj_smhr_salaryStruct.SALARYSTRUCT_CODE = Convert.ToString(Code); _obj_smhr_salaryStruct.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); dt_Det = BLL.get_SalaryHeaderDetails(_obj_smhr_salaryStruct); if (dt_Det.Rows.Count != 0) { _sal_struct_ID = Convert.ToString(dt_Det.Rows[0][0]); } for (index = 0; index <= RG_SalaryStruct.Items.Count - 1; index++) { Label lblCode = new Label(); // Pay item Code Label lblMode = new Label(); // Pay item Mode TextBox txtVal = new TextBox(); // Salary Structure Entered Value Label lblformula = new Label(); //Salary Structure Entered Formula CheckBox chkBox = new CheckBox(); // Check Box lblCode = RG_SalaryStruct.Items[index].FindControl("lblPAYITEM_ID") as Label; lblMode = RG_SalaryStruct.Items[index].FindControl("lblCALMODE") as Label; txtVal = RG_SalaryStruct.Items[index].FindControl("txtNumber") as TextBox; lblformula = RG_SalaryStruct.Items[index].FindControl("lblformula") as Label; chkBox = RG_SalaryStruct.Items[index].FindControl("chk_Select") as CheckBox; if (Convert.ToString(txtVal.Text) != "") { if (chkBox.Checked) { _obj_smhr_salaryStruct.SALARYSTRUCT_ID = Convert.ToInt32(_sal_struct_ID); _obj_smhr_salaryStruct.SALARYSTRUCTDET_PAYITEM_ID = Convert.ToInt32(lblCode.Text); _obj_smhr_salaryStruct.SALARYSTRUCTDET_PAYMODE = Convert.ToString(lblMode.Text); _obj_smhr_salaryStruct.SALARYSTRUCTDET_PAYVALUE = Convert.ToString(txtVal.Text); _obj_smhr_salaryStruct.SALARYSTRUCTDET_FORMULA = ""; _obj_smhr_salaryStruct.SALARYSTRUCTDET_CHECKED = true; _obj_smhr_salaryStruct.SALARYSTRUCT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_smhr_salaryStruct.SALARYSTRUCT_CREATEDDATE = DateTime.Now; _obj_smhr_salaryStruct.OPERATION = operation.Insert; status = BLL.set_SalaryDetails(_obj_smhr_salaryStruct); } } } BLL.ShowMessage(this, "Record Saved Successfully"); RMP_SalaryStruct.SelectedIndex = 0; LoadMainGrid(); RG_Salary.DataBind(); clearItems(); return; } else { BLL.ShowMessage(this, "Error Occured While Doing the Process"); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_SalaryStructure", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }