/// <summary>
/// To Load all Period data
/// </summary>
private void LoadPeriod()
{
try
{
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
if (dt_Details.Rows.Count > 0)
{
rcbPeriod.DataSource = dt_Details;
rcbPeriod.DataTextField = "PERIOD_NAME";
rcbPeriod.DataValueField = "PERIOD_ID";
rcbPeriod.DataBind();
}
rcbPeriod.Items.Insert(0, new RadComboBoxItem("Select"));
rcbPrdDtl.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmGratuityReportSS", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadBU()
{
try
{
_obj_smhr_businessunit = new SMHR_BUSINESSUNIT();
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_logininfo = new SMHR_LOGININFO();
obj_smhr_logininfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
obj_smhr_logininfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(obj_smhr_logininfo);
rcmb_BU.DataSource = dt_BUDetails;
rcmb_BU.DataValueField = "BUSINESSUNIT_ID";
rcmb_BU.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BU.DataBind();
//if (Convert.ToString(Session["SELFSERVICE"]) == "ADMIN")
// rcmb_BU.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", "-1"));
//else
// rcmb_BU.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select"));
rcmb_BU.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("'", "''"), "CmprsnRptWithPrevMnth", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
_obj_smhr_businessunit = new SMHR_BUSINESSUNIT();
_obj_smhr_period = new SMHR_PERIOD();
dt_Details = new DataTable();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
if (dt_Details.Rows.Count != 0)
{
rcb_Period.DataSource = dt_Details;
rcb_Period.DataValueField = "PERIOD_ID";
rcb_Period.DataTextField = "PERIOD_NAME";
rcb_Period.DataBind();
rcb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
}
rcmb_businessunit.Items.Clear();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PayrollApproval", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
public void loadCombos()
{
try
{
// for loading the businessunits
_obj_Smhr_LoginInfo = new SMHR_LOGININFO();
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
dt_Details = BLL.get_Business_Units(_obj_Smhr_LoginInfo);
rcmbBusinessUnit.DataSource = dt_Details;
rcmbBusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmbBusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmbBusinessUnit.DataBind();
rcmbBusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
// for loading the periods
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmbPeriod.DataSource = dt_Details;
rcmbPeriod.DataTextField = "PERIOD_NAME";
rcmbPeriod.DataValueField = "PERIOD_ID";
rcmbPeriod.DataBind();
rcmbPeriod.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmHoldPayrollProcess", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
_obj_smhr_businessunit = new SMHR_BUSINESSUNIT();
_obj_smhr_period = new SMHR_PERIOD();
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_SMHR_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(_obj_SMHR_LoginInfo);
ddl_BusinessUnit.DataSource = dt_BUDetails;
ddl_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
ddl_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
ddl_BusinessUnit.DataBind();
ddl_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
//SMHR_DEPARTMENT _obj_smhr_department = new SMHR_DEPARTMENT();
//_obj_smhr_department.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_department.MODE = 5;
//DataTable dt_dept = BLL.get_Department(_obj_smhr_department);
//rcb_Department.DataSource = dt_dept;
//rcb_Department.DataValueField = "DEPARTMENT_ID";
//rcb_Department.DataTextField = "DEPARTMENT_NAME";
//rcb_Department.DataBind();
//rcb_Department.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeLeaveEncashment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadBusinessUnit()
{
try
{
string control = Convert.ToString(Request.QueryString["Control"]);
obj_smhr_Businessunit = new SMHR_BUSINESSUNIT();
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Logininfo = new SMHR_LOGININFO();
obj_smhr_Logininfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
obj_smhr_Logininfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(obj_smhr_Logininfo);
rcmb_BusinessUnit.DataSource = dt_BUDetails;
rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataBind();
if (control == "11")
{
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
// rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem(Convert.ToString(Session["ORG_NAME"])));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeDueIncrement", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos1()
{
try
{
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_payperiod.DataSource = dt_Details;
rcmb_payperiod.DataValueField = "PERIOD_ID";
rcmb_payperiod.DataTextField = "PERIOD_NAME";
rcmb_payperiod.DataBind();
rcmb_payperiod.Items.Insert(0, new RadComboBoxItem("Select"));
//SMHR_DEPARTMENT _obj_smhr_department = new SMHR_DEPARTMENT();
//_obj_smhr_department.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_department.MODE = 5;
//DataTable dt_dept = BLL.get_Department(_obj_smhr_department);
//ddl_Department.DataSource = dt_dept;
//ddl_Department.DataValueField = "DEPARTMENT_ID";
//ddl_Department.DataTextField = "DEPARTMENT_NAME";
//ddl_Department.DataBind();
//ddl_Department.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Wht", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_Employee_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
_obj_smhr_period = new SMHR_PERIOD();
dt_Details = new DataTable();
_obj_smhr_period.OPERATION = operation.Select;
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_SMHR_LoginInfo.LOGIN_ID = 53;
dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_Period.DataSource = dt_Details;
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
_OBJ_BONUS_TRANS.OPERATION = operation.Login;
_OBJ_BONUS_TRANS.APPRCYCLE_ID = Convert.ToInt32(Session["EMP_TYPE"]);
DataTable dt_login = BLL.Get_SMHR_BONUS_TRANS1(_OBJ_BONUS_TRANS);
if (dt_login.Rows.Count > 0)
{
Session["USER_NAME"] = Convert.ToString(dt_login.Rows[0]["LOGTYP_CODE"]);
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "FORM16", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
protected void rcmb_businessunit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_businessunit.SelectedIndex > 0)
{
_obj_smhr_period = new SMHR_PERIOD();
dt_Details = new DataTable();
_obj_smhr_period.OPERATION = operation.Select;
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_SMHR_LoginInfo.LOGIN_ID = 53;
dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_period.DataSource = dt_Details;
rcmb_period.DataValueField = "PERIOD_ID";
rcmb_period.DataTextField = "PERIOD_NAME";
rcmb_period.DataBind();
rcmb_period.Items.Insert(0, new RadComboBoxItem("Select"));
rg_bonuspast.Visible = false;
}
else
{
rcmb_period.Items.Clear();
rg_bonuspast.Visible = false;
rcmb_periodelements.Items.Clear();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "bonuspast", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
_obj_smhr_businessunit = new SMHR_BUSINESSUNIT();
_obj_smhr_period = new SMHR_PERIOD();
dt_details = new DataTable();
_obj_smhr_businessunit.OPERATION = operation.Select;
_obj_smhr_businessunit.ISDELETED = true;
dt_details = BLL.get_BusinessUnit(_obj_smhr_businessunit);
rcmb_BUID.DataSource = dt_details;
rcmb_BUID.DataValueField = "BUSINESSUNIT_ID";
rcmb_BUID.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BUID.DataBind();
rcmb_BUID.Items.Insert(0, new RadComboBoxItem("Select", "0"));
_obj_smhr_period.OPERATION = operation.Select;
dt_details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_Period.DataSource = dt_details;
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_leaveopeningbalances", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
//To fetch BusinessUnits
DataSet ds = BLL.GetEmployeeFilterDetails(Convert.ToInt32(Session["ORG_ID"]), null, null, null);
rcmb_BusinessUnit.DataSource = ds.Tables[0];
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataBind();
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
//To fetch Periods
SMHR_PERIOD _obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_Period.DataSource = dt_Details;
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_Employee.Items.Insert(0, new RadComboBoxItem("Select", "-1"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "RegstrUnRegstrAccStmts", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void BindLoanGrid()
{
try
{
RadGrid1.Visible = true;
SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT();
smhr_LoanAmount.OPERATION = operation.Get;
smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]);
smhr_LoanAmount.LoanID = Convert.ToInt32(rad_TypeOfLoan.SelectedValue);
smhr_LoanAmount.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dt = BLL.get_LoanMaxEligibleAmount(smhr_LoanAmount);
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RadGrid1.Enabled = false;
btn_Save.Visible = false;
}
else
{
RadGrid1.Enabled = true;
btn_Save.Visible = true;
}
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
ddl_BusinessUnit.Items.Clear();
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_SMHR_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(_obj_SMHR_LoginInfo);
ddl_BusinessUnit.DataSource = dt_BUDetails;
ddl_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
ddl_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
ddl_BusinessUnit.DataBind();
ddl_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
ddl_Period.DataSource = dt_Details;
ddl_Period.DataValueField = "PERIOD_ID";
ddl_Period.DataTextField = "PERIOD_NAME";
ddl_Period.DataBind();
ddl_Period.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Postings", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadPeriod()
{
try
{
rcmb_FromPeriod.Items.Clear();
SMHR_PERIOD PRD = new SMHR_PERIOD();
PRD.OPERATION = operation.PERIOD;
PRD.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = new DataTable();
DT = BLL.GetEmployeePeriod(PRD);
if (DT.Rows.Count > 0)
{
rcmb_FromPeriod.DataSource = DT;
rcmb_FromPeriod.DataTextField = "PERIOD_NAME";
rcmb_FromPeriod.DataValueField = "PERIOD_ID";
rcmb_FromPeriod.DataBind();
}
rcmb_FromPeriod.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (System.Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Allowance", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
// Loading Business units
_obj_smhr_businessunit = new SMHR_BUSINESSUNIT();
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
rcmb_Perioddtls.Items.Clear();
rcmb_Busniessunit.Items.Clear();
rcmb_Financialperiod.Items.Clear();
_obj_SMHR_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
dt_Information = BLL.get_Business_Units(_obj_SMHR_LoginInfo);
if (dt_Information.Rows.Count != 0)
{
rcmb_Busniessunit.DataSource = dt_Information;
rcmb_Busniessunit.DataValueField = "BUSINESSUNIT_ID";
rcmb_Busniessunit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_Busniessunit.DataBind();
rcmb_Busniessunit.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_Busniessunit.SelectedIndex = 0;
}
else
{
rcmb_Busniessunit.DataSource = dt_null;
rcmb_Busniessunit.DataBind();
rcmb_Busniessunit.Items.Insert(0, new RadComboBoxItem("Select"));
}
// Loading Periods
SMHR_PERIOD _obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_SMHR_LoginInfo.LOGIN_ID = 53;
dt_Information = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
if (dt_Information.Rows.Count != 0)
{
rcmb_Financialperiod.DataSource = dt_Information;
rcmb_Financialperiod.DataValueField = "PERIOD_ID";
rcmb_Financialperiod.DataTextField = "PERIOD_NAME";
rcmb_Financialperiod.DataBind();
rcmb_Financialperiod.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
rcmb_Financialperiod.DataSource = dt_null;
rcmb_Financialperiod.DataBind();
rcmb_Financialperiod.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Esiexport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadBusinessUnit()
{
try
{
obj_smhr_Businessunit = new SMHR_BUSINESSUNIT();
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Logininfo = new SMHR_LOGININFO();
Control = Convert.ToString(Request.QueryString["Control"]);
if (Convert.ToString(Session["SELFSERVICE"]) == "ADMIN")
{
obj_smhr_Logininfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
obj_smhr_Logininfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(obj_smhr_Logininfo);
rcmb_BusinessUnit.DataSource = dt_BUDetails;
rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataBind();
//rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
if (Control == "AllocationSummary")
{
// rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem(Convert.ToString(Session["ORG_NAME"]), "-1"));
}
else
{
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
else
{
_obj_smhr_emp_payitems = new SMHR_EMP_PAYITEMS();
_obj_smhr_emp_payitems.EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_emp_payitems.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_emp_payitems.OPERATION = operation.Self;
DataTable dt_BU = BLL.get_EmpDetails(_obj_smhr_emp_payitems);
rcmb_BusinessUnit.DataSource = dt_BU;
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataValueField = "EMP_BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataBind();
//rcmb_BusinessUnit.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
if (Control == "AllocationSummary")
{
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem(Convert.ToString(Session["ORG_NAME"]), "-1"));
}
else
{
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LeaveAllowancesPaid", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rc_FinalicalPeriod_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rc_financialPeriod.SelectedIndex > 0)
{
RG_TrainingApproval.Visible = true;
btn_submit.Visible = true;
btn_Cancel.Visible = true;
SMHR_PAYITEMS _obj_Smhr_PayItems = new SMHR_PAYITEMS();
_obj_Smhr_PayItems.OPERATION = operation.Check2;
_obj_Smhr_PayItems.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_PayItems.PAYITEM_FINPERIODID = Convert.ToInt32(rc_financialPeriod.SelectedValue);
DataTable dt = BLL.get_PayItems(_obj_Smhr_PayItems);
RG_TrainingApproval.DataSource = dt;
RG_TrainingApproval.DataBind();
RadComboBox rc_LoanProcessType;
for (int i = 0; i < RG_TrainingApproval.Items.Count; i++)
{
rc_LoanProcessType = RG_TrainingApproval.Items[i].FindControl("rc_LoanProcessType") as RadComboBox;
//rc_LoanProcessType.SelectedValue = Convert.ToString(dt.Rows[i]["LOANSETUP_LOANPROCESSTYPE"]);
rc_LoanProcessType.SelectedIndex = rc_LoanProcessType.Items.FindItemIndexByText(Convert.ToString(dt.Rows[i]["LOANSETUP_LOANPROCESSTYPE"]));
}
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(rc_financialPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RG_TrainingApproval.Enabled = false;
btn_submit.Visible = false;
btn_Cancel.Visible = false;
}
else
{
RG_TrainingApproval.Enabled = true;
btn_submit.Visible = true;
btn_Cancel.Visible = true;
}
}
else
{
RG_TrainingApproval.Visible = false;
btn_submit.Visible = false;
btn_Cancel.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanSetup", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
clearControls();
BindFinancialPeriod();
//BindLoanTypes();
rad_TypeOfLoan.Enabled = false;
RadGrid1.Visible = true;
SMHR_LOANELIGIBLEAMOUNT smhr_LoanAmount = new SMHR_LOANELIGIBLEAMOUNT();
smhr_LoanAmount.OPERATION = operation.Get;
smhr_LoanAmount.OrgID = Convert.ToInt32(Session["ORG_ID"]);
smhr_LoanAmount.LoanID = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_LoanMaxEligibleAmount(smhr_LoanAmount);
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
if (dt.Rows.Count > 0)
{
SMHR_PAYITEMS _obj_Smhr_BusinessUnit = new SMHR_PAYITEMS();
_obj_Smhr_BusinessUnit.OPERATION = operation.Check2;
_obj_Smhr_BusinessUnit.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt1 = BLL.get_PayItems(_obj_Smhr_BusinessUnit);
rad_TypeOfLoan.DataSource = dt1;
rad_TypeOfLoan.DataValueField = "PAYITEM_ID";
rad_TypeOfLoan.DataTextField = "PAYITEM_PAYITEMNAME";
rad_TypeOfLoan.DataBind();
rad_TypeOfLoan.Items.Insert(0, new RadComboBoxItem("Select", "-1"));
rad_TypeOfLoan.SelectedIndex = rad_TypeOfLoan.FindItemIndexByValue(smhr_LoanAmount.LoanID.ToString());
radFinPeriod.SelectedIndex = radFinPeriod.FindItemIndexByValue(dt.Rows[0]["LOANELIGIBLEAMOUNT_FIN_PERIOD_ID"].ToString());
}
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RadGrid1.Enabled = false;
}
else
{
RadGrid1.Enabled = true;
}
// trExpend.Visible = false;
lbl_ExpenditureID.Text = smhr_LoanAmount.LoanID.ToString();
// rad_ExpenditureName.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_NAME"]);
// rad_ExpenditureName.Enabled = false;
// rtxt_ExpenditureDesc.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_DESC"]);
btn_Save.Visible = true;
Rm_CY_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MaxLoanEligibility", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Generate_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Period = new SMHR_PERIOD();
_obj_Smhr_Period.OPERATION = operation.Empty;
//_obj_Smhr_Period.PERIOD_ID = null; ;
_obj_Smhr_Period.PERIOD_NAME = Convert.ToString(rtxt_PeriodName.Text);
_obj_Smhr_Period.PERIOD_STARTDATE = Convert.ToDateTime(rdtp_StartDate.SelectedDate);
_obj_Smhr_Period.PERIOD_TYPE = Convert.ToInt32(rcmb_PeriodType.SelectedItem.Value);
_obj_Smhr_Period.PERIOD_DURATION = Convert.ToInt32(rtxt_Duration.Text);
if (rcmb_DurationType.SelectedValue != "")
{
if (rcmb_DurationType.SelectedItem.Value != "-1")
{
_obj_Smhr_Period.PERIOD_DURATIONTYPE = Convert.ToInt32(rcmb_DurationType.SelectedIndex);
}
else
{
BLL.ShowMessage(this, "Please select Durtaion Type");
// return;
}
}
else
{
BLL.ShowMessage(this, "Please select Period Type");
//return;
}
dt1 = BLL.GeneratePeriodDetails(_obj_Smhr_Period);
//if and else added by bharat
// as it is throwing error if then don't select period type and click on generate button
if (dt1.Rows.Count > 0)
{
Rg_PeriodDetails.DataSource = dt1;
ViewState["Rg_PeriodDetails"] = dt1;
Rg_PeriodDetails.DataBind();
Rg_PeriodDetails.Visible = true;
btn_Save.Visible = true;
rdtp_EndDate.SelectedDate = Convert.ToDateTime(dt1.Rows[dt1.Rows.Count - 1]["prddtl_enddate"]);
}
else
{
BLL.ShowMessage(this, "Unable to Generate Details, Please Select Proper Information");
btn_Save.Visible = false;
Rg_PeriodDetails.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Period", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcb_FinancialPeriod_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcb_FinancialPeriod.SelectedIndex > 0)
{
btn_Save.Visible = true;
_obj_smhr_TaxationMaster = new SMHR_TAXATIONMASTER();
_obj_smhr_TaxationMaster.OPERATION = operation.Get;
_obj_smhr_TaxationMaster.TAXATIONMASTER_FINPERIOD_ID = Convert.ToInt32(rcb_FinancialPeriod.SelectedValue);
_obj_smhr_TaxationMaster.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_TaxationMaster.TAXATIONMASTER_TYPE_ID = Convert.ToInt32(rcb_Taxation.SelectedValue);
DataTable dt_Details = BLL.get_Taxation(_obj_smhr_TaxationMaster);
if (dt_Details.Rows.Count > 0)
{
RG_TaxationSlab.Visible = true;
RG_TaxationSlab.DataSource = dt_Details;
RG_TaxationSlab.DataBind();
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(rcb_FinancialPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RG_TaxationSlab.Enabled = false;
btn_Save.Visible = false;
}
else
{
RG_TaxationSlab.Enabled = Convert.ToBoolean(dt_Details.Rows[0]["ISEnable"]);;
btn_Save.Visible = Convert.ToBoolean(dt_Details.Rows[0]["ISEnable"]);;
}
}
else
{
RG_TaxationSlab.Visible = true;
RG_TaxationSlab.DataSource = GetEmptyDT();
RG_TaxationSlab.DataBind();
RG_TaxationSlab.Enabled = true;
btn_Save.Visible = true;
}
}
else
{
RG_TaxationSlab.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "TaxationMaster", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadBusinessUnit()
{
try
{
obj_smhr_Businessunit = new SMHR_BUSINESSUNIT();
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Logininfo = new SMHR_LOGININFO();
obj_smhr_Logininfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
obj_smhr_Logininfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(obj_smhr_Logininfo);
rcmb_BusinessUnit.DataSource = dt_BUDetails;
rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataBind();
//rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem(Convert.ToString(Session["ORG_NAME"])));
//if (Convert.ToString(Session["SELFSERVICE"]) == "ADMIN")
//{
// obj_smhr_Logininfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
// obj_smhr_Logininfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// DataTable dt_BUDetails = BLL.get_Business_Units(obj_smhr_Logininfo);
// rcmb_BusinessUnit.DataSource = dt_BUDetails;
// rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
// rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
// rcmb_BusinessUnit.DataBind();
// rcmb_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
// rcmb_BusinessUnit.Items.Insert(1, new RadComboBoxItem("All"));
// //int itemCount = rcmb_BusinessUnit.Items.Count;
// //rcmb_BusinessUnit.Items.Insert(itemCount+1,new RadComboBoxItem("All"));
//}
//else
//{
// _obj_smhr_emp_payitems = new SMHR_EMP_PAYITEMS();
// _obj_smhr_emp_payitems.EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
// _obj_smhr_emp_payitems.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// _obj_smhr_emp_payitems.OPERATION = operation.Self;
// DataTable dt_BU = BLL.get_EmpDetails(_obj_smhr_emp_payitems);
// rcmb_BusinessUnit.DataSource = dt_BU;
// rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
// rcmb_BusinessUnit.DataValueField = "EMP_BUSINESSUNIT_ID";
// rcmb_BusinessUnit.DataBind();
// rcmb_BusinessUnit.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
// //int itemCount = rcmb_BusinessUnit.Items.Count;
// //rcmb_BusinessUnit.Items.Insert(itemCount + 1, new RadComboBoxItem("All"));
//}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeData", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadFinancialPeriod()
{
SMHR_PERIOD _obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtFinPrd = BLL.GET_FIN_PERIOD(_obj_smhr_period);
rcbFinPeriod.DataSource = dtFinPrd;
rcbFinPeriod.DataTextField = "PERIOD_NAME";
rcbFinPeriod.DataValueField = "PERIOD_ID";
rcbFinPeriod.DataBind();
rcbFinPeriod.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select"));
}
public void LoadMainGrid()
{
try
{
_obj_Smhr_Period = new SMHR_PERIOD();
_obj_Smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt = BLL.get_PeriodHeaderDetails_Calendar(_obj_Smhr_Period);
Rg_Period.DataSource = dt;
ViewState["Table"] = dt;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PeriodCalender", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
//Business Unit
rcmb_BusinessUnit.Items.Clear();
_obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_SMHR_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(_obj_SMHR_LoginInfo);
rcmb_BusinessUnit.DataSource = dt_BUDetails;
rcmb_BusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_BusinessUnit.DataValueField = "BUSINESSUNIT_ID";
rcmb_BusinessUnit.DataBind();
rcmb_BusinessUnit.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
rcmb_Period.Items.Clear();
_obj_smhr_Period = new SMHR_PERIOD();
_obj_smhr_Period.OPERATION = operation.Select;
_obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_PeriodHeaderDetails(_obj_smhr_Period);
rcmb_Period.DataSource = dt;
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
//Pay Item
rcmb_Payitem.Items.Clear();
_obj_Smhr_YTDOpeningBalance = new SMHR_YTDOPENINGBALANCE();
_obj_Smhr_YTDOpeningBalance.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_YTDOpeningBalance.OPERATION = operation.EMPTY1;
DataTable dtPayitem = BLL.get_YTDOpeningBalance(_obj_Smhr_YTDOpeningBalance);
rcmb_Payitem.DataSource = dtPayitem;
rcmb_Payitem.DataValueField = "PAYITEM_ID";
rcmb_Payitem.DataTextField = "PAYITEM_PAYITEMNAME";
rcmb_Payitem.DataBind();
rcmb_Payitem.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_YTDOpeningBalances", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void loadDetails()
{
try
{
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcb_Period.DataSource = dt_Details;
rcb_Period.DataValueField = "PERIOD_ID";
rcb_Period.DataTextField = "PERIOD_NAME";
rcb_Period.DataBind();
rcb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_businessunit.Items.Clear();
//To load Business unit
SMHR_LOGININFO _obj_SMHR_LoginInfo = new SMHR_LOGININFO();
_obj_SMHR_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_LoginInfo.LOGIN_ID = Convert.ToInt32(Session["USER_ID"]);
DataTable dt_BUDetails = BLL.get_Business_Units(_obj_SMHR_LoginInfo);
if (dt_BUDetails.Rows.Count != 0)
{
rcmb_businessunit.DataSource = dt_BUDetails;
rcmb_businessunit.DataValueField = "BUSINESSUNIT_ID";
rcmb_businessunit.DataTextField = "BUSINESSUNIT_CODE";
rcmb_businessunit.DataBind();
rcmb_businessunit.Items.Insert(0, new RadComboBoxItem("Select"));
rcb_Transaction.Items.Clear();
RG_Transaction.Visible = false;
btn_Rollback.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Rollback", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
//_obj_smhr_payroll = new SMHR_PAYROLL();
//_obj_smhr_payroll.MODE = 22;
//DataTable dt = BLL.get_PayDetails(_obj_smhr_payroll);
//rcb_Transaction.DataSource = dt;
//rcb_Transaction.DataTextField = "TEMP_PAYTRAN_NAME";
//rcb_Transaction.DataValueField = "TEMP_PAYTRAN_ID";
//rcb_Transaction.DataBind();
//rcb_Transaction.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select"));
}
private void BindMedicalGrid()
{
try
{
int count = 0;
RadGrid1.Visible = true;
smhr_MedicalBenfit = new SMHR_MEDICALBENFIT();
smhr_MedicalBenfit.OPERATION = operation.Get;
smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]);
//smhr_MedicalBenfit.ExpendID = Convert.ToInt32(rad_ExpenditureName.SelectedValue);
smhr_MedicalBenfit.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dt = BLL.get_MedicalBenfit(smhr_MedicalBenfit);
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RadGrid1.Enabled = false;
RadGrid1.MasterTableView.Columns[3].Visible = false;
}
else
{
RadGrid1.Enabled = true;
RadGrid1.MasterTableView.Columns[3].Visible = true;
}
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(dt.Rows[i]["medical_added"]) == false)
{
RadGrid1.MasterTableView.Columns[3].Visible = false;
return;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadFinancialPeriods()
{
try
{
SMHR_PERIOD _obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtFinancialPeriods = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_FinancialYear.DataSource = dtFinancialPeriods;
rcmb_FinancialYear.DataValueField = "PERIOD_ID";
rcmb_FinancialYear.DataTextField = "PERIOD_NAME";
rcmb_FinancialYear.DataBind();
rcmb_FinancialYear.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_IntrstOnNormlContribution", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
ddl_Period.DataSource = dt_Details;
ddl_Period.DataValueField = "PERIOD_ID";
ddl_Period.DataTextField = "PERIOD_NAME";
ddl_Period.DataBind();
ddl_Period.Items.Insert(0, new RadComboBoxItem("Select"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Retropay", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCombos()
{
try
{
obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Period.OPERATION = operation.Select;
obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(obj_smhr_Period);
//DataTable dt_Details = BLL.get_PeriodHeaderDetails_Calendar(obj_smhr_Period);
rcmb_Period.DataSource = dt_Details;
rcmb_Period.DataValueField = "PERIOD_ID";
rcmb_Period.DataTextField = "PERIOD_NAME";
rcmb_Period.DataBind();
rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select"));
_obj_Smhr_Location = new SMHR_TRAINING_LOCATION();
_obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Location.OPERATION = operation.Select1;
rcmb_Location.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location);
rcmb_Location.DataTextField = "Location_Name";
rcmb_Location.DataValueField = "Location_ID";
rcmb_Location.DataBind();
rcmb_Location.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
if (string.Compare(Control, "EmployeeAttendance", true) == 0)
{
SMHR_COURSE _obj_Course = new SMHR_COURSE();
_obj_Course.OPERATION = operation.Select2;
_obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); //Convert.ToInt32(Session["ORG_ID"]);
rcmb_Course.DataSource = BLL.get_Course(_obj_Course);
rcmb_Course.DataTextField = "COURSE_NAME";
rcmb_Course.DataValueField = "COURSE_ID";
rcmb_Course.DataBind();
rcmb_Course.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("'", "''"), "LocationWiseTrainingProgram", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcb_BusinessUnit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcb_BusinessUnit.SelectedIndex != 0)
{
//To load Financial Periods
_obj_smhr_period = new SMHR_PERIOD();
_obj_smhr_period.OPERATION = operation.Select;
_obj_smhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(_obj_smhr_period);
rcmb_period.DataSource = dt_Details;
rcmb_period.DataValueField = "PERIOD_ID";
rcmb_period.DataTextField = "PERIOD_NAME";
rcmb_period.DataBind();
rcmb_period.Items.Insert(0, new RadComboBoxItem("Select"));
//LoadEmployees();
rcb_Employee.Items.Clear();
rcb_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
RG_Employee.Visible = false;
btn_Cancel.Visible = false;
btn_Save.Visible = false;
}
else
{
rcb_Employee.Items.Clear();
rcb_Employee.Items.Insert(0, new RadComboBoxItem("Select"));
rcb_Employee.ClearSelection();
rcmb_period.Items.Clear();
rcmb_period.Items.Insert(0, new RadComboBoxItem("Select"));
rcmb_period.ClearSelection();
btn_Cancel.Visible = false;
btn_Save.Visible = false;
RG_Employee.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TDSExempt", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
