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 }