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