private void LoadDetail_Combo()
{
try
{
if (ddl_Period.SelectedIndex != 0)
{
_obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(ddl_Period.SelectedItem.Value);
DataTable dt_Details = new DataTable();
dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dt_Details.Rows.Count != 0)
{
ddl_PeriodDetails.DataSource = dt_Details;
ddl_PeriodDetails.DataValueField = "PRDDTL_ID";
ddl_PeriodDetails.DataTextField = "PRDDTL_NAME";
ddl_PeriodDetails.DataBind();
ddl_PeriodDetails.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");
}
}
protected void rcmb_Period_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_Period.SelectedIndex != 0)
{
SMHR_PERIODDTL _obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(rcmb_Period.SelectedItem.Value);
//DataTable dt_Details = BLL.get_PeriodDetails_Calendar(_obj_smhr_perioddtl);
DataTable dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dt_Details.Rows.Count != 0)
{
rcmb_PeriodElements.DataSource = dt_Details;
rcmb_PeriodElements.DataValueField = "PRDDTL_ID";
rcmb_PeriodElements.DataTextField = "PRDDTL_NAME";
rcmb_PeriodElements.DataBind();
rcmb_PeriodElements.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
else
{
rcmb_PeriodElements.Items.Clear();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "PreApprovalPayRegister", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_Period_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_Period.SelectedIndex > 0)
{
rcmb_PeriodElements.Items.Clear();
_obj_Smhr_Prddtl = new SMHR_PERIODDTL();
_obj_Smhr_Prddtl.OPERATION = operation.Select;
_obj_Smhr_Prddtl.ISDELETED = true;
_obj_Smhr_Prddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(rcmb_Period.SelectedValue);
DataTable dt_Period = BLL.get_PeriodDetails(_obj_Smhr_Prddtl);
rcmb_PeriodElements.DataSource = dt_Period;
rcmb_PeriodElements.DataValueField = "PRDDTL_ID";
rcmb_PeriodElements.DataTextField = "PRDDTL_NAME";
rcmb_PeriodElements.DataBind();
rcmb_PeriodElements.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select"));
}
else
{
rcmb_PeriodElements.Items.Clear();
rcmb_Payitem.SelectedIndex = 0;
}
}
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");
}
}
protected void rcbPeriod_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rcbPrdDtl.Items.Clear();
rcbPrdDtl.ClearSelection();
rcbPrdDtl.Text = string.Empty;
rcbTranID.Items.Clear();
rcbTranID.ClearSelection();
rcbTranID.Text = string.Empty;
rcbEmployee.Items.Clear();
rcbEmployee.ClearSelection();
rcbEmployee.Text = string.Empty;
ClearFields();
RG_SalaryStruct.Visible = false;
if (rcbPeriod.SelectedIndex > 0)
{
SMHR_PERIODDTL _obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(rcbPeriod.SelectedValue);
DataTable dtPrdDetails = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dtPrdDetails.Rows.Count != 0)
{
rcbPrdDtl.DataSource = dtPrdDetails;
rcbPrdDtl.DataValueField = "PRDDTL_ID";
rcbPrdDtl.DataTextField = "PRDDTL_NAME";
rcbPrdDtl.DataBind();
}
rcbPrdDtl.Items.Insert(0, new RadComboBoxItem("Select"));
rcbTranID.Items.Insert(0, new RadComboBoxItem("Select"));
rcbEmployee.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
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");
}
}
//protected void rbt_SalaryList_SelectedIndexChanged(object sender, EventArgs e)
//{
// //Loademployee();
//}
protected void ddl_Period_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if ((ddl_BusinessUnit.SelectedIndex > 0) && (ddl_Period.SelectedIndex > 0))
{
_obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(ddl_Period.SelectedValue);
dt_Details = new DataTable();
dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dt_Details.Rows.Count != 0)
{
ddl_PeriodElements.DataSource = dt_Details;
ddl_PeriodElements.DataValueField = "PRDDTL_ID";
ddl_PeriodElements.DataTextField = "PRDDTL_NAME";
ddl_PeriodElements.DataBind();
ddl_PeriodElements.Items.Insert(0, new RadComboBoxItem("Select"));
}
//ddl_BusinessUnit.Items.Insert(0, new RadComboBoxItem("Select"));
//ddl_PeriodElements.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
ddl_PeriodElements.ClearSelection();
ddl_PeriodElements.Items.Clear();
ddl_PeriodElements.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
lbl_SalaryStruct.Visible = false;
rbt_SalaryList.Visible = false;
ddl_Employees.Items.Clear();
}
rdtp_FromDate.SelectedDate = null;
rdtp_ToDate.SelectedDate = null;
lbl_SalaryStruct.Visible = false;
rbt_SalaryList.Visible = false;
ddl_Employees.ClearSelection();
ddl_Employees.Items.Clear();
ddl_Employees.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_QuickPay", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_PeriodMaster_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_BUI.SelectedIndex <= 0)
{
BLL.ShowMessage(this, "Please Select Business Unit");
rcmb_PeriodMaster.ClearSelection();
return;
}
tr_OTDt.Visible = false;
rdtp_OTDt.Visible = false;
// _obj_smhr_perioddtl = new SMHR_PERIODDTL();
if (Convert.ToInt32(rcmb_PeriodMaster.SelectedIndex) > 0)
{
SMHR_PERIODDTL _obj_smhr_perioddtl1 = new SMHR_PERIODDTL();
_obj_smhr_perioddtl1.OPERATION = operation.Select;
_obj_smhr_perioddtl1.PRDDTL_PERIOD_ID = Convert.ToInt32(rcmb_PeriodMaster.SelectedItem.Value);
DataTable dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl1);
if (dt_Details.Rows.Count != 0)
{
rcmb_PeriodElement.DataSource = dt_Details;
rcmb_PeriodElement.DataValueField = "PRDDTL_ID";
rcmb_PeriodElement.DataTextField = "PRDDTL_NAME";
rcmb_PeriodElement.DataBind();
rcmb_PeriodElement.Items.Insert(0, new RadComboBoxItem("Select"));
}
Rg_OTDetails.Visible = false;
}
else
{
Rg_OTDetails.Visible = false;
rcmb_PeriodElement.ClearSelection();
//rcmb_PeriodElement.Items.Clear();
btn_Cancle.Visible = false;
btn_Process.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_overtimecalc", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_PeriodMaster_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
Rg_PayReults.Visible = false;
rcmb_PeriodStatus.SelectedIndex = 0;
if (rcmb_PeriodMaster.SelectedIndex != 0)
{
_obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(rcmb_PeriodMaster.SelectedItem.Value);
dt_Details = new DataTable();
dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dt_Details.Rows.Count != 0)
{
rcmb_PeriodElement.DataSource = dt_Details;
rcmb_PeriodElement.DataValueField = "PRDDTL_ID";
rcmb_PeriodElement.DataTextField = "PRDDTL_NAME";
rcmb_PeriodElement.DataBind();
rcmb_PeriodElement.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
else
{
rcmb_PeriodElement.Items.Clear();
rcmb_PeriodElement.Items.Insert(0, new RadComboBoxItem("", ""));
rcb_Transaction.Items.Clear();
rcb_Transaction.Items.Insert(0, new RadComboBoxItem("", ""));
}
//added for link to Payroll Reports. By Anirudh
lnk.Visible = false;
lnk_Approved.Visible = false;
//if (rcmb_PeriodMaster.SelectedIndex == 0)
//{
// lnk.Visible = false;
// lnk_Approved.Visible = false;
//}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Payresults", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_OTDetPeriodDetails_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
SMHR_PERIODDTL _obj_Smhr_Prddtl = new SMHR_PERIODDTL();
_obj_Smhr_Prddtl.OPERATION = operation.Select;
_obj_Smhr_Prddtl.PRDDTL_ID = Convert.ToInt32(rcmb_OTDetPeriodDetails.SelectedValue);
DataTable dt_Period = BLL.get_PeriodDetails(_obj_Smhr_Prddtl);
if (dt_Period.Rows.Count == 1)
{
rdtp_OTDetOTDate.MinDate = Convert.ToDateTime(dt_Period.Rows[0]["PRDDTL_STARTDATE"]);
rdtp_OTDetOTDate.MaxDate = Convert.ToDateTime(dt_Period.Rows[0]["PRDDTL_ENDDATE"]);
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OTDetails", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_Period_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
if (rcmb_Period.SelectedIndex != 0)
{
SMHR_PERIODDTL _obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(rcmb_Period.SelectedItem.Value);
//DataTable dt_Details = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
DataTable dt_Details = BLL.get_PeriodDetails_Calendar(_obj_smhr_perioddtl);
if (dt_Details.Rows.Count != 0)
{
rcmb_PeriodElements.DataSource = dt_Details;
rcmb_PeriodElements.DataValueField = "PRDDTL_ID";
rcmb_PeriodElements.DataTextField = "PRDDTL_NAME";
rcmb_PeriodElements.DataBind();
rcmb_PeriodElements.Items.Insert(0, new RadComboBoxItem("Select"));
/////// LoadEmployee();
}
}
else
{
rcmb_PeriodElements.Items.Clear();
}
}
protected void ddl_PeriodElements_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (ddl_PeriodElements.SelectedIndex > 0)
{
rfv_rbt_SalaryList.Enabled = true;
btn_Paytran.Visible = true;
_obj_smhr_perioddtl = new SMHR_PERIODDTL();
_obj_smhr_perioddtl.OPERATION = operation.Select;
_obj_smhr_perioddtl.PRDDTL_ID = Convert.ToInt32(ddl_PeriodElements.SelectedValue);
dtdates = new DataTable();
dtdates = BLL.get_PeriodDetails(_obj_smhr_perioddtl);
if (dtdates.Rows.Count != 0)
{
rdtp_FromDate.Clear();
rdtp_ToDate.Clear();
rdtp_FromDate.MinDate = Convert.ToDateTime(dtdates.Rows[0]["PRDDTL_STARTDATE"]);
rdtp_ToDate.MinDate = Convert.ToDateTime(dtdates.Rows[0]["PRDDTL_STARTDATE"]);
rdtp_FromDate.MaxDate = Convert.ToDateTime(dtdates.Rows[0]["PRDDTL_ENDDATE"]);
rdtp_ToDate.MaxDate = Convert.ToDateTime(dtdates.Rows[0]["PRDDTL_ENDDATE"]);
}
dt_Details = new DataTable();
_obj_smhr_employee = new SMHR_EMPLOYEE();
_obj_smhr_employee.OPERATION = operation.Empty;
_obj_smhr_employee.EMPSALDTLS_PRDDTL_ID = Convert.ToInt32(ddl_PeriodElements.SelectedValue);
_obj_smhr_employee.EMP_BUSINESSUNIT_ID = Convert.ToInt32(ddl_BusinessUnit.SelectedValue);
_obj_smhr_employee.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt_Details = BLL.get_PayBusinessUnit(_obj_smhr_employee);
if (dt_Details.Rows.Count != 0)
{
ddl_Employees.Items.Clear();
rbt_SalaryList.DataSource = dt_Details;
rbt_SalaryList.DataValueField = "EMP_SALALRYSTRUCT_ID";
rbt_SalaryList.DataTextField = "SALARYSTRUCT_CODE";
rbt_SalaryList.DataBind();
lbl_SalaryStruct.Visible = true;
rbt_SalaryList.Visible = true;
}
else
{
lbl_SalaryStruct.Visible = false;
lbl_SalaryStruct.Visible = false;
rbt_SalaryList.Visible = false;
ddl_Employees.Items.Clear();
}
}
else
{
lbl_SalaryStruct.Visible = false;
rbt_SalaryList.Visible = false;
ddl_Employees.Items.Clear();
}
ddl_Employees.ClearSelection();
ddl_Employees.Items.Clear();
ddl_Employees.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
//LoadCombos();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_QuickPay", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
ViewState["Rg_PeriodDetails"] = null;
_obj_Smhr_Period = new SMHR_PERIOD();
_obj_Smhr_Prddtl = new SMHR_PERIODDTL();
_obj_Smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Period.PERIOD_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
dt = BLL.get_PeriodHeaderDetails_Calendar(_obj_Smhr_Period);
if (dt.Rows.Count > 0)
{
rtxt_PeriodName.Text = Convert.ToString(dt.Rows[0]["PERIOD_NAME"]);
rcmb_PeriodType.SelectedIndex = rcmb_PeriodType.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PERIOD_TYPE"]));
rdtp_StartDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["PERIOD_STARTDATE"]);
rdtp_EndDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["PERIOD_ENDDATE"]);
rtxt_Duration.Text = Convert.ToString(dt.Rows[0]["PERIOD_DURATION"]);
rcmb_PeriodType_SelectedIndexChanged(null, null);
rcmb_DurationType.SelectedIndex = rcmb_DurationType.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PERIOD_DURATIONTYPE"]));
rtxt_PeriodName.Enabled = false;
rcmb_PeriodType.Enabled = false;
rdtp_StartDate.Enabled = false;
rdtp_EndDate.Enabled = false;
rtxt_Duration.Enabled = false;
rcmb_DurationType.Enabled = false;
Rm_Period_page.SelectedIndex = 1;
btn_GeneratePeriods.Visible = false;
btn_Save.Visible = false;
//code for security
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Edit.Visible = false;
}
else
{
btn_Edit.Visible = true;
}
_obj_Smhr_Prddtl.OPERATION = operation.Select;
_obj_Smhr_Prddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable dttemp = BLL.get_PeriodDetails_Calendar(_obj_Smhr_Prddtl);
ViewState["Rg_PeriodDetails"] = dttemp;
Rg_PeriodDetails.DataSource = dttemp;
Rg_PeriodDetails.DataBind();
}
else
{
BLL.ShowMessage(this, "The End Date for the Period Define has been completed");
}
}
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");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Period = new SMHR_PERIOD();
_obj_Smhr_Prddtl = new SMHR_PERIODDTL();
StringBuilder strQry = new StringBuilder();
//Entities of PERIOD TABLE
_obj_Smhr_Period = new SMHR_PERIOD();
// _obj_Smhr_Period.ORGANISATION_ID = 2;
_obj_Smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Period.PERIOD_NAME = Convert.ToString(rtxt_PeriodName.Text);
_obj_Smhr_Period.PERIOD_TYPE = Convert.ToInt32(rcmb_PeriodType.SelectedItem.Value);
_obj_Smhr_Period.PERIOD_STARTDATE = (Convert.ToDateTime(Convert.ToDateTime(rdtp_StartDate.SelectedDate).ToShortDateString()));
_obj_Smhr_Period.PERIOD_ENDDATE = Convert.ToDateTime(rdtp_EndDate.SelectedDate);
_obj_Smhr_Period.PERIOD_DURATION = Convert.ToInt32(rtxt_Duration.Text);
_obj_Smhr_Period.PERIOD_DURATIONTYPE = Convert.ToInt32(rcmb_DurationType.SelectedIndex);
_obj_Smhr_Period.PERIOD_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Period.PERIOD_CREATEDDATE = DateTime.Now;
_obj_Smhr_Period.PERIOD_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Period.PERIOD_LASTMDFDATE = DateTime.Now;
if (((Button)sender).ID.ToUpper() == "BTN_EDIT")
{
for (int i = 0; i < Rg_PeriodDetails.Items.Count; i++)
{
_obj_Smhr_Prddtl.PRDDTL_ID = Convert.ToInt32(Rg_PeriodDetails.Items[i].Cells[2].Text);
_obj_Smhr_Prddtl.PRDDTL_NAME = Convert.ToString(Rg_PeriodDetails.Items[i].Cells[3].Text);
//_obj_Smhr_Prddtl.PRDDTL_STARTDATE = Convert.ToDateTime(Rg_PeriodDetails.Items[i].Cells[4].Text);
//string date =Rg_PeriodDetails.Items[i].Cells[5].Text;
//DateTime dt = DateTime.ParseExact(date, "MM/dd/yyyy", CultureInfo.InvariantCulture);
//_obj_Smhr_Prddtl.ENDDATE = Convert.ToDateTime(dt);
RadComboBox rdcmbstatus;
rdcmbstatus = (RadComboBox)Rg_PeriodDetails.Items[i].FindControl("rcmb_Status");
_obj_Smhr_Prddtl.PRDDTL_STATUS = Convert.ToInt32(rdcmbstatus.SelectedItem.Value);
_obj_Smhr_Prddtl.PRDDTL_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Prddtl.PRDDTL_LASTMDFDATE = DateTime.Now;
_obj_Smhr_Prddtl.OPERATION = operation.Update;
strQry.Append(BLL.set_PeriodDetails_Calendar(_obj_Smhr_Prddtl) + " \n");
}
if (BLL.ExecuteNonQuery(strQry.ToString()))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
}
else
{
_obj_Smhr_Period.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_PeriodHeaderDetails_Calendar(_obj_Smhr_Period).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Period with this Name Already Exists");
return;
}
//// to validate the PERIOD START DATE
//_obj_Smhr_Period.OPERATION = operation.Validate;
//if (Convert.ToInt32(BLL.get_PeriodHeaderDetails_Calendar(_obj_Smhr_Period).Rows[0]["Count"]) > 0)
//{
// BLL.ShowMessage(this, "Period had already been defined using this date, please select another date");
// return;
//}
// to validate the PERIOD START DATE
_obj_Smhr_Period.OPERATION = operation.Validate1;
_obj_Smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Period.PERIOD_STARTDATE = Convert.ToDateTime(rdtp_StartDate.SelectedDate);
_obj_Smhr_Period.PERIOD_ENDDATE = Convert.ToDateTime(rdtp_EndDate.SelectedDate);
if (Convert.ToInt32(BLL.get_PeriodHeaderDetails_Calendar(_obj_Smhr_Period).Rows[0]["Count"]) > 0)
{
BLL.ShowMessage(this, "Period had already been defined using this date, please select another date");
return;
}
_obj_Smhr_Period.OPERATION = operation.Insert;
if (BLL.set_PeriodHeaderdetails_Calendar(_obj_Smhr_Period))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
}
Rm_Period_page.SelectedIndex = 0;
LoadMainGrid();
Rg_Period.DataBind();
ViewState["Rg_PeriodDetails"] = null;
}
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");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
loadPeriod();
SMHR_PERIOD _obj_smhr_Period = new SMHR_PERIOD();
_obj_smhr_Period.OPERATION = operation.Empty;
_obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_DetailsLoad = BLL.get_PeriodHeaderDetails(_obj_smhr_Period);
if (dt_DetailsLoad.Rows.Count > 0)
{
rcmbPeriod.SelectedIndex = rcmbPeriod.Items.FindItemIndexByValue(Convert.ToString(dt_DetailsLoad.Rows[0][0]));
}
loadPeriodElement();
SMHR_PERIODDTL obj_smhr_Prddtl = new SMHR_PERIODDTL();
obj_smhr_Prddtl.OPERATION = operation.Empty;
obj_smhr_Prddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(dt_DetailsLoad.Rows[0][0]);
DataTable dtPrddtl = BLL.get_PeriodDetails(obj_smhr_Prddtl);
if (dtPrddtl.Rows.Count > 0)
{
rcmbPeriodElement.SelectedIndex = rcmbPeriodElement.Items.FindItemIndexByValue(Convert.ToString(dtPrddtl.Rows[0][0]));
}
}
#region Display Leave-Balance in Pie-Chart
if (!Page.IsPostBack)
{
bool status = false;
Color[] barColors = new Color[8] {
Color.Purple,
Color.SteelBlue,
Color.Aqua,
Color.Yellow,
Color.Navy,
Color.Green,
Color.Blue,
Color.Red
};
SMHR_PERIOD obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Period.OPERATION = operation.Empty;
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)
{
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
_obj_smhr_Dashboard.OPERATION = operation.Select_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODID = Convert.ToInt32(dt_Details.Rows[0][0]);
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
DataTable dt_LeaveBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_LeaveBalance.Rows.Count != 0)
{
for (int dt_rowcount = 0; dt_rowcount < dt_LeaveBalance.Rows.Count; dt_rowcount++)
{
if (dt_LeaveBalance.Rows.Count == 1)
{
if (Convert.ToDouble(dt_LeaveBalance.Rows[dt_rowcount]["LT_CURRENTBALANCE"]) == 0.00)
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
status = true;
}
}
}
if (status == false)
{
int i = 0;
RadChart2.Visible = true;
RadChart2.DataSource = dt_LeaveBalance;
RadChart2.DataBind();
foreach (var item in RadChart2.Series[0].Items)
{
item.Appearance.FillStyle.MainColor = barColors[i++];
}
}
}
else
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
}
}
else
{
BLL.ShowMessage(this, "Current Period does not contains Leave Balances");
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveChart", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
#endregion
}
