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