protected void rcmb_Period_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { try { rcmb_PeriodDetails.Items.Clear(); if (rcmb_Period.SelectedItem.Value != "0") { SMHR_ATTENDANCE _obj_Smhr_Attendance = new SMHR_ATTENDANCE(); _obj_Smhr_Attendance.OPERATION = operation.Check; _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmb_Period.SelectedItem.Value); rcmb_PeriodDetails.Items.Clear(); rcmb_PeriodDetails.DataSource = BLL.get_Attendance(_obj_Smhr_Attendance); rcmb_PeriodDetails.DataTextField = "PRDDTL_NAME"; rcmb_PeriodDetails.DataValueField = "PRDDTL_ID"; rcmb_PeriodDetails.DataBind(); rcmb_PeriodDetails.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } else { rcmb_PeriodDetails.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_Attendance", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void loadDropdown() { try { rcmb_BusinessUnitID.Items.Clear(); SMHR_ATTENDANCE _obj_Smhr_Attendance = new SMHR_ATTENDANCE(); _obj_Smhr_Attendance.OPERATION = operation.Empty; rcmb_BusinessUnitID.Items.Clear(); rcmb_BusinessUnitID.DataSource = BLL.get_Attendance(_obj_Smhr_Attendance); rcmb_BusinessUnitID.DataTextField = "BUSINESSUNIT_CODE"; rcmb_BusinessUnitID.DataValueField = "BUSINESSUNIT_ID"; rcmb_BusinessUnitID.DataBind(); rcmb_BusinessUnitID.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rcmb_Period.Items.Clear(); _obj_Smhr_Attendance = new SMHR_ATTENDANCE(); _obj_Smhr_Attendance.OPERATION = operation.Delete; rcmb_Period.Items.Clear(); rcmb_Period.DataSource = BLL.get_Attendance(_obj_Smhr_Attendance); rcmb_Period.DataTextField = "PERIOD_NAME"; rcmb_Period.DataValueField = "PERIOD_ID"; rcmb_Period.DataBind(); rcmb_Period.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rcmb_PeriodDetails.Items.Clear(); rcmb_PeriodDetails.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_Attendance", ex.StackTrace, DateTime.Now); } }
public void loadGrid() { try { if (rcmbPeriodElement.SelectedIndex > 0) { Label lblempid = new Label(); CheckBox chk1 = new CheckBox(); _obj_Smhr_Attendance = new SMHR_ATTENDANCE(); //comented on 06.03.2013 ////_obj_Smhr_Attendance = new SMHR_ATTENDANCE(); ////_obj_Smhr_Attendance.OPERATION = operation.Select4; ////_obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedValue); ////_obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue); ////_obj_Smhr_Attendance.ATTENDANCE_PERIOD_ID = Convert.ToInt32(rcmbPeriod.SelectedValue); ////DataTable dtPay = BLL.get_Attendance(_obj_Smhr_Attendance); ////if (dtPay.Rows.Count > 0) ////{ //// if ((Convert.ToString(dtPay.Rows.Count) == "2")) //// { //// if ((Convert.ToInt32(dtPay.Rows[0][0]) == 0) && (Convert.ToInt32(dtPay.Rows[1][0]) > 0)) //// { //// rgMain.Visible = true; //// trNote.Visible = true; //// lblNote.Text = "NOTE : Operations not allowed as payroll has been approved"; //// loadPayGrid(); //// } //// else if ((Convert.ToInt32(dtPay.Rows[0][0]) > 0) && (Convert.ToInt32(dtPay.Rows[1][0]) == 0)) //// { //// rgMain.Visible = true; //// trNote.Visible = true; //// lblNote.Text = "NOTE : Operations not allowed as payroll is in pending status"; //// loadPayGrid(); //// } //// else //// { trNote.Visible = false; rgMain.Visible = true; rgMain.Enabled = true; trBtn.Visible = true; trChkAll.Visible = true; _obj_Smhr_Employee_Inhold = new SMHR_EMPLOYEE_INHOLD(); _obj_Smhr_Employee_Inhold.OPERATION = operation.Check; _obj_Smhr_Employee_Inhold.INH_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedValue); _obj_Smhr_Employee_Inhold.INH_FIN_PRDDTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue); _obj_Smhr_Employee_Inhold.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dtChk = BLL.get_Employee_Inhold(_obj_Smhr_Employee_Inhold); if (dtChk.Rows.Count > 0) { if (Convert.ToString(dtChk.Rows[0][0]) == "0") { _obj_Smhr_Attendance.OPERATION = operation.CHKATT; _obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedValue); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue); DataTable dtEmp = BLL.get_Attendance(_obj_Smhr_Attendance); if (dtEmp.Rows.Count > 0) { rgMain.DataSource = dtEmp; rgMain.DataBind(); int empcount = 0; for (int index = 0; index < rgMain.Items.Count; index++) { lblempid = rgMain.Items[index].FindControl("lblEmpId") as Label; chk1 = rgMain.Items[index].FindControl("chkEmployee") as CheckBox; _obj_Smhr_Attendance.OPERATION = operation.Select1; _obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_ID = Convert.ToInt32(rcmbPeriod.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_EMP_ID = Convert.ToInt32(lblempid.Text); DataTable dt_status = BLL.get_Attendance(_obj_Smhr_Attendance); bool st = false; if (dt_status.Rows.Count > 0) { for (int count = 0; count < dt_status.Rows.Count; count++) { if (Convert.ToString(dt_status.Rows[count]["COUNT"]) != "0") { st = true;//IF PAYROLL IS IN PENDING OR APPROVED } } } if (st) { chk1.Enabled = false; } else { chk1.Enabled = true; empcount++; } } if (empcount == 0) { btnSave.Visible = false; btnUpdate.Visible = false; } else { btnSave.Visible = true; btnUpdate.Visible = false; } btnCancel.Visible = true; } } else { _obj_Smhr_Employee_Inhold.OPERATION = operation.Select; DataTable dtEmp = BLL.get_Employee_Inhold(_obj_Smhr_Employee_Inhold); if (dtEmp.Rows.Count > 0) { rgMain.DataSource = dtEmp; rgMain.DataBind(); CheckBox chk = new CheckBox(); int empcount = 0; for (int dtIndex = 0; dtIndex < dtEmp.Rows.Count; dtIndex++) { chk = rgMain.Items[dtIndex].FindControl("chkEmployee") as CheckBox; lblempid = rgMain.Items[dtIndex].FindControl("lblEmpId") as Label; if (Convert.ToString(dtEmp.Rows[dtIndex]["HOLD_STATUS"]) == "1") { chk.Checked = true; } else { chk.Checked = false; } //TO GET THE PAYROLL STATUS _obj_Smhr_Attendance.OPERATION = operation.Select1; _obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_ID = Convert.ToInt32(rcmbPeriod.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_EMP_ID = Convert.ToInt32(lblempid.Text); DataTable dt_status = BLL.get_Attendance(_obj_Smhr_Attendance); bool st = false; if (dt_status.Rows.Count > 0) { for (int count = 0; count < dt_status.Rows.Count; count++) { if (Convert.ToString(dt_status.Rows[count]["COUNT"]) != "0") { st = true;//IF PAYROLL IS IN PENDING OR APPROVED } } } if (st) { chk.Enabled = false; } else { chk.Enabled = true; empcount++; } } if (empcount == 0) { btnSave.Visible = false; btnUpdate.Visible = false; } else { btnSave.Visible = false; btnUpdate.Visible = true; } btnCancel.Visible = true; } } } //// } //// } //// else //// { //// } ////} //rgMain.Visible = true; //trBtn.Visible = true; //trChkAll.Visible = true; //_obj_Smhr_Employee_Inhold = new SMHR_EMPLOYEE_INHOLD(); //_obj_Smhr_Employee_Inhold.OPERATION = operation.Check; //_obj_Smhr_Employee_Inhold.INH_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedValue); //_obj_Smhr_Employee_Inhold.INH_FIN_PRDDTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue); //_obj_Smhr_Employee_Inhold.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //DataTable dtChk = BLL.get_Employee_Inhold(_obj_Smhr_Employee_Inhold); //if (dtChk.Rows.Count > 0) //{ // if (Convert.ToString(dtChk.Rows[0][0]) == "0") // { // _obj_Smhr_Attendance.OPERATION = operation.CHKATT; // _obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmbBusinessUnit.SelectedValue); // _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue); // DataTable dtEmp = BLL.get_Attendance(_obj_Smhr_Attendance); // if (dtEmp.Rows.Count > 0) // { // rgMain.DataSource = dtEmp; // rgMain.DataBind(); // btnSave.Visible = true; // btnUpdate.Visible = false; // btnCancel.Visible = true; // } // } // else // { // _obj_Smhr_Employee_Inhold.OPERATION = operation.Select; // DataTable dtEmp = BLL.get_Employee_Inhold(_obj_Smhr_Employee_Inhold); // if (dtEmp.Rows.Count > 0) // { // rgMain.DataSource = dtEmp; // rgMain.DataBind(); // CheckBox chk = new CheckBox(); // for (int dtIndex = 0; dtIndex < dtEmp.Rows.Count; dtIndex++) // { // chk = rgMain.Items[dtIndex].FindControl("chkEmployee") as CheckBox; // if (Convert.ToString(dtEmp.Rows[dtIndex]["HOLD_STATUS"]) == "1") // { // chk.Checked = true; // } // else // { // chk.Checked = false; // } // } // btnSave.Visible = false; // btnUpdate.Visible = true; // btnCancel.Visible = true; // } // } //} } else { BLL.ShowMessage(this, "Select Period Element"); return; } } 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"); } }
protected void LoadGrid() { try { _obj_smhr_ottrans = new SMHR_EMPOTTRANS(); _obj_smhr_ottrans.BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value); _obj_smhr_ottrans.MODE = 1; _obj_smhr_ottrans.EMPOTTRANS_PERIODDTL_ID = Convert.ToInt32(rcmb_PeriodElement.SelectedItem.Value); _obj_smhr_ottrans.OTCALC_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate); //To pass Overtime Date _obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); dt_Load = BLL.calculate_OT(_obj_smhr_ottrans); Rg_OTDetails.DataSource = dt_Load; // NEED TO CALL A METHOD FOR MAKING THE FIELDS AS READ ONLY Rg_OTDetails.DataBind(); LoadEmpData(); /* To disable no. of hours textbox */ Telerik.Web.UI.RadNumericTextBox rntxt = new RadNumericTextBox(); Label lblempid = new Label(); for (int i = 0; i <= Rg_OTDetails.Items.Count - 1; i++) { //ddlList = Rg_OTDetails.Items[i].FindControl("rcmb_AttDtls_Status") as RadComboBox; rntxt = Rg_OTDetails.Items[i].FindControl("txt_nofdays") as RadNumericTextBox; rntxt.Enabled = false; //TO GET PAYROLL STATUS //chk = Rg_OTDetails.Items[i].FindControl("chckbtn_Select") as CheckBox; lblempid = Rg_OTDetails.Items[i].FindControl("lbl_empid") as Label; SMHR_ATTENDANCE _obj_Smhr_Attendance = new SMHR_ATTENDANCE(); _obj_Smhr_Attendance.OPERATION = operation.Select1; _obj_Smhr_Attendance.ATTENDANCE_BU_ID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_ID = Convert.ToInt32(rcmb_PeriodMaster.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_PERIOD_DTL_ID = Convert.ToInt32(rcmb_PeriodElement.SelectedItem.Value); _obj_Smhr_Attendance.ATTENDANCE_EMP_ID = Convert.ToInt32(lblempid.Text); DataTable dt_status = BLL.get_Attendance(_obj_Smhr_Attendance); bool st = false; if (dt_status.Rows.Count > 0) { for (int count = 0; count < dt_status.Rows.Count; count++) { if (Convert.ToString(dt_status.Rows[count]["COUNT"]) != "0") { st = true;//IF PAYROLL IS IN PENDING OR APPROVED } } } if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][2]))).Trim() != "") { if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "0") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("P")); ////ddlList.BackColor = Color.Red; //ddlList.ForeColor = Color.Black; rntxt.Enabled = true; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "1") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("L")); //ddlList.ForeColor = Color.Magenta; rntxt.Enabled = false; rntxt.Text = "0.00"; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "2") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("W")); //ddlList.ForeColor = Color.Blue; rntxt.Enabled = false; rntxt.Text = "0.00"; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "3") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("H")); //ddlList.ForeColor = Color.DarkGreen; rntxt.Enabled = false; rntxt.Text = "0.00"; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "4") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("HL")); //ddlList.ForeColor = Color.DarkGoldenrod; rntxt.Enabled = false; rntxt.Text = "0.00"; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "5") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("A")); //ddlList.ForeColor = Color.Red; rntxt.Enabled = false; rntxt.Text = "0.00"; } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][3]))).Trim() == "-1") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("A")); //ddlList.ForeColor = Color.Red; //ddlList.Enabled = false; rntxt.Enabled = false; rntxt.Text = "0.00"; } } else if ((Convert.ToString(Convert.ToString(dt_Load.Rows[i][2]))).Trim() == "") { //ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("A")); //ddlList.ForeColor = Color.Red; rntxt.Enabled = false; rntxt.Text = "0.00"; } if (st == true) { //ddlList.Enabled = false; rntxt.Enabled = false; //chk.Enabled = false; } else { //ddlList.Enabled = true; rntxt.Enabled = true; //chk.Enabled = true; //EMP_COUNT++; } //if (Convert.ToString(Convert.ToString(DT_Employee.Rows[i][3])) == "0") // ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("P")); //else if (Convert.ToString(Convert.ToString(DT_Employee.Rows[i][3])) == "1") // ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("L")); //else if (Convert.ToString(Convert.ToString(DT_Employee.Rows[i][3])) == "2") // ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("W")); //else if (Convert.ToString(Convert.ToString(DT_Employee.Rows[i][3])) == "3") // ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("H")); //else if (Convert.ToString(Convert.ToString(DT_Employee.Rows[i][3])) == " ") // ddlList.SelectedIndex = ddlList.FindItemIndexByValue(Convert.ToString("A")); } /* To disable no. of hours textbox */ } 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"); } }