protected void rcmb_OTDetPeriodMain_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_OTDetPeriodMain.SelectedItem.Text.ToUpper() != "SELECT")
{
SMHR_EMPOTTRANS _obj_Smhr_EmpOTTrans = new SMHR_EMPOTTRANS();
_obj_Smhr_EmpOTTrans.OPERATION = operation.Update;
_obj_Smhr_EmpOTTrans.EMPOTTRANS_PERIOD_ID = Convert.ToInt32(rcmb_OTDetPeriodMain.SelectedItem.Value);
rcmb_OTDetPeriodDetails.Items.Clear();
rcmb_OTDetPeriodDetails.DataSource = BLL.get_EmpOTTrans(_obj_Smhr_EmpOTTrans);
rcmb_OTDetPeriodDetails.DataTextField = "PRDDTL_NAME";
rcmb_OTDetPeriodDetails.DataValueField = "PRDDTL_ID";
rcmb_OTDetPeriodDetails.DataBind();
rcmb_OTDetPeriodDetails.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
}
else
{
rcmb_OTDetPeriodDetails.Items.Clear();
rcmb_OTDetPeriodDetails.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
}
}
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 btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_EMPOTTRANS _obj_Smhr_EmpOTTrans = new SMHR_EMPOTTRANS();
_obj_Smhr_EmpOTTrans.EMPOTTRANS_EMPID = Convert.ToInt32(rcmb_OTDetEmployeeID.SelectedItem.Value);
_obj_Smhr_EmpOTTrans.EMPOTTRANS_TYPEID = Convert.ToInt32(rcmb_OTDetOTType.SelectedItem.Value);
_obj_Smhr_EmpOTTrans.EMPOTTRANS_PERIOD_ID = Convert.ToInt32(rcmb_OTDetPeriodDetails.SelectedItem.Value);
_obj_Smhr_EmpOTTrans.EMPOTTRANS_DATE = Convert.ToDateTime(rdtp_OTDetOTDate.SelectedDate);
//_obj_Smhr_EmpOTTrans.EMPOTTRANS_HOURS = float.Parse(rtxt_OTDetOTHours.Text);
_obj_Smhr_EmpOTTrans.EMPOTTRANS_HOURS = Convert.ToInt32(rtxt_OTDetOTHours.Text);
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_EmpOTTrans.EMPOTTRANS_ID = Convert.ToInt32(lbl_OTDetID.Text);
_obj_Smhr_EmpOTTrans.OPERATION = operation.Update;
if (BLL.set_EmpOTTrans(_obj_Smhr_EmpOTTrans))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_EmpOTTrans.OPERATION = operation.Insert;
if (BLL.set_EmpOTTrans(_obj_Smhr_EmpOTTrans))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_AOT_page.SelectedIndex = 0;
LoadData();
RG_OTpproval.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OverTime", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadOTandPeriod()
{
try
{
if (rcmb_OTDetEmployeeID.SelectedItem.Text.ToUpper() != "SELECT")
{
SMHR_EMPOTTRANS _obj_Smhr_EmpOTTrans = new SMHR_EMPOTTRANS();
_obj_Smhr_EmpOTTrans.OPERATION = operation.Insert;
_obj_Smhr_EmpOTTrans.EMPOTTRANS_EMPID = Convert.ToInt32(rcmb_OTDetEmployeeID.SelectedItem.Value);
rcmb_OTDetOTType.Items.Clear();
rcmb_OTDetOTType.DataSource = BLL.get_EmpOTTrans(_obj_Smhr_EmpOTTrans);
rcmb_OTDetOTType.DataTextField = "OT";
rcmb_OTDetOTType.DataValueField = "OT_ID";
rcmb_OTDetOTType.DataBind();
rcmb_OTDetOTType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
rcmb_OTDetPeriodMain.Items.Clear();
_obj_Smhr_EmpOTTrans.OPERATION = operation.Check;
rcmb_OTDetPeriodMain.DataSource = BLL.get_EmpOTTrans(_obj_Smhr_EmpOTTrans);
rcmb_OTDetPeriodMain.DataTextField = "PERIOD_NAME";
rcmb_OTDetPeriodMain.DataValueField = "PERIOD_ID";
rcmb_OTDetPeriodMain.DataBind();
rcmb_OTDetPeriodMain.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
_obj_Smhr_EmpOTTrans = new SMHR_EMPOTTRANS();
_obj_Smhr_EmpOTTrans.OPERATION = operation.Check;
//_obj_Smhr_EmpOTTrans.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_Smhr_EmpOTTrans.EMPOTTRANS_EMPID = Convert.ToInt32(rcmb_OTDetEmployeeID.SelectedValue);
DataTable dtdoj = BLL.getValues_EmpOTTrans(_obj_Smhr_EmpOTTrans);
lbl_EmpJoinDate.Text = Convert.ToString(dtdoj.Rows[0]["EMP_DOJ"]);
}
else
{
rcmb_OTDetOTType.Items.Clear();
rcmb_OTDetOTType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
rcmb_OTDetPeriodMain.Items.Clear();
rcmb_OTDetPeriodMain.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
}
}
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");
}
}
private void LoadGrid()
{
try
{
//if (Convert.ToInt32(Session["EMP_ID"]) == 0)
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.MODE = 0;
_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(Session["EMP_ID"]);
DataTable dt_Load = new DataTable();
dt_Load = BLL.calculate_OT(_obj_smhr_ottrans);
Rg_OverTime.DataSource = dt_Load;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalc", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadGrid()
{
try
{
_obj_Smhr_LoginInfo = new SMHR_LOGINTYPE();
_obj_Smhr_LoginInfo.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //getting organisation from session under login.aspx
_obj_Smhr_LoginInfo.LOGTYP_ID = Convert.ToInt32(Session["EMP_TYPE"]); //getting login type id from session under login.aspx
_obj_Smhr_LoginInfo.LOGTYP_UNIQUEID = Convert.ToInt32(Session["USER_GROUP"]); //getting login type code from session under login.aspx
if (_obj_Smhr_LoginInfo.LOGTYP_UNIQUEID != 4) //getting logintype unique id from SMHR_LOGINTYPE table (LOGTYP_UNIQUEID) 4:employee
{
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.OPERATION = operation.Empty1;
_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(Session["EMP_ID"]);
DataTable dt_Load = new DataTable();
dt_Load = BLL.getstatus(_obj_smhr_ottrans);
Rg_OverTime.DataSource = dt_Load;
//Rg_OverTime.MasterTableView.CommandItemDisplay = false;
if (dt_Load.Rows.Count != 0)
{
btn_Submit.Visible = true;
btn_Cancel.Visible = true;
}
else
{
btn_Submit.Visible = false;
btn_Cancel.Visible = false;
}
}
else
{
BLL.ShowMessage(this, "You Cannot Acess..!");
Rg_OverTime.Visible = false;
lbl_OverTime.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcRM", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadData()
{
try
{
_obj_smhr_empottrans = new SMHR_EMPOTTRANS();
_obj_smhr_empottrans.OPERATION = operation.Empty;
_obj_smhr_empottrans.EMPOTTRANS_APPROVEDBY = Convert.ToInt32(rtxt_ReportingMgr.Text);
_obj_smhr_empottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt_Details = new DataTable();
dt_Details = BLL.calculate_OT(_obj_smhr_empottrans);
//dt_Details = BLL.get_EmpOTTrans(_obj_smhr_empottrans);
RG_OTpproval.DataSource = dt_Details;
RG_OTpproval.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OverTime", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadEmployee()
{
try
{
if (rcmb_BusinessUnit.SelectedItem.Text.ToUpper() != "SELECT")
{
SMHR_EMPOTTRANS _obj_Smhr_EmpOTTrans = new SMHR_EMPOTTRANS();
_obj_Smhr_EmpOTTrans.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value);
rcmb_OTDetEmployeeID.Items.Clear();
rcmb_OTDetEmployeeID.DataSource = BLL.getValues_EmpOTTrans(_obj_Smhr_EmpOTTrans);
rcmb_OTDetEmployeeID.DataTextField = "EMPNAME";
rcmb_OTDetEmployeeID.DataValueField = "EMP_ID";
rcmb_OTDetEmployeeID.DataBind();
rcmb_OTDetEmployeeID.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
}
}
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 lbtn_Edit_Command(object sender, CommandEventArgs e)
{
try
{
//clearControls();
btn_Submit.Visible = true;
btn_Submit.Text = "Approve";
//btn_Update.Visible = true;
btn_Cancel.Visible = true;
LoadEmployees();
LoadBusinessUnits();
otid = Convert.ToInt32(e.CommandArgument);
SMHR_EMPOTTRANS _obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_ottrans.EMPOTTRANS_ID = otid;
_obj_smhr_ottrans.MODE = 1;
_obj_smhr_ottrans.OPERATION = operation.Select;
DataTable dt = BLL.calculate_OT(_obj_smhr_ottrans);
if (dt.Rows.Count > 0)
{
rcmb_Employee.SelectedIndex = rcmb_Employee.FindItemIndexByValue(dt.Rows[0]["OTCALC_EMPID"].ToString());
rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.FindItemIndexByValue(dt.Rows[0]["OTCALC_BUID"].ToString());
if (!string.IsNullOrEmpty(dt.Rows[0]["OTCALC_DATE"].ToString()))
{
rdtp_OTDt.SelectedDate = Convert.ToDateTime(dt.Rows[0]["OTCALC_DATE"]);
}
if (dt.Rows[0]["OTCALC_ACTUALHOURS"] != System.DBNull.Value)
{
rtbActHrs.Text = Convert.ToString(Convert.ToInt32(Convert.ToDecimal(dt.Rows[0]["OTCALC_ACTUALHOURS"]) / 60));
}
if (dt.Rows[0]["OTCALC_ACTUALHOURS"] != System.DBNull.Value)
{
rtbActMins.Text = Convert.ToString(Convert.ToInt32(Convert.ToDecimal(dt.Rows[0]["OTCALC_ACTUALHOURS"]) % 60));
}
rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(Convert.ToDecimal(dt.Rows[0]["OTCALC_WORKINGHOURS"]) / 60));
rtbOTMins.Text = Convert.ToString(Convert.ToInt32(Convert.ToDecimal(dt.Rows[0]["OTCALC_WORKINGHOURS"]) % 60));
rtxt_Comments.Text = Convert.ToString(dt.Rows[0]["OTCALC_COMMENTS"]);
if (!string.IsNullOrEmpty(dt.Rows[0]["OTCALC_FROMTIME"].ToString()))
{
rdp_fromtime.SelectedDate = DateTime.Today + new TimeSpan(((System.TimeSpan)((dt.Rows[0]["OTCALC_FROMTIME"]))).Hours, ((System.TimeSpan)((dt.Rows[0]["OTCALC_FROMTIME"]))).Minutes, ((System.TimeSpan)((dt.Rows[0]["OTCALC_FROMTIME"]))).Seconds);
}
if (!string.IsNullOrEmpty(dt.Rows[0]["OTCALC_TOTIME"].ToString()))
{
rdp_totime.SelectedDate = DateTime.Today + new TimeSpan(((System.TimeSpan)((dt.Rows[0]["OTCALC_TOTIME"]))).Hours, ((System.TimeSpan)((dt.Rows[0]["OTCALC_TOTIME"]))).Minutes, ((System.TimeSpan)((dt.Rows[0]["OTCALC_TOTIME"]))).Seconds);
}
if (Convert.ToInt32(dt.Rows[0]["OTCALC_STATUS"]) == 2)
{
btn_Submit.Visible = false;
}
else
{
btn_Submit.Visible = true;
}
}
Rm_OverTime_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcRM", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{
//decimal actHrs = 0, actMins = 0;
//if (rtbActHrs.Text == string.Empty)
// rtbActHrs.Text = actHrs.ToString();
//else
// actHrs = Convert.ToDecimal(rtbActHrs.Text);
//if (rtbActMins.Text == string.Empty)
// rtbActMins.Text = actMins.ToString();
//else
// actMins = Convert.ToDecimal(rtbActMins.Text);
//decimal OTHRS = 0, OTMINS = 0;
//if (rtbOTHrs.Text == string.Empty)
// rtbOTHrs.Text = OTHRS.ToString();
//else
// OTHRS = Convert.ToDecimal(rtbOTHrs.Text);
//if (rtbOTMins.Text == string.Empty)
// rtbOTMins.Text = OTMINS.ToString();
//else
// OTMINS = Convert.ToDecimal(rtbOTMins.Text);
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.EMPOTTRANS_ID = otid;
_obj_smhr_ottrans.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_ottrans.EMPOTTRANS_STATUS = 2;
TimeSpan fromtime = new TimeSpan(Convert.ToDateTime(rdp_fromtime.SelectedDate).Hour, Convert.ToDateTime(rdp_fromtime.SelectedDate).Minute, Convert.ToDateTime(rdp_fromtime.SelectedDate).Second);
_obj_smhr_ottrans.OTCALC_FROMTIME = fromtime;
TimeSpan totime = new TimeSpan(Convert.ToDateTime(rdp_totime.SelectedDate).Hour, Convert.ToDateTime(rdp_totime.SelectedDate).Minute, Convert.ToDateTime(rdp_totime.SelectedDate).Second);
_obj_smhr_ottrans.OTCALC_TOTIME = totime;
//_obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(rcmb_Employee.SelectedValue);
//_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_ottrans.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
////_obj_smhr_ottrans.OTCALC_EMPCODE = rntb_code.Text;
//_obj_smhr_ottrans.EMPOTTRANS_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate);
///*_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32((Convert.ToInt32(rtbOTHrs.Text) * 60) + Convert.ToInt32(rntb_Mins.Text));
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToInt32((Convert.ToInt32(rtbOTHrs.Text) * 60) + Convert.ToInt32(rtbOTMins.Text));*/
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32((actHrs * 60) + actMins);
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToInt32((OTHRS * 60) + OTMINS);
///*_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToDecimal(rtbOTHrs.Text);
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToDecimal(rtbOTMins.Text);
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32(rtbOTHrs.Text);
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32(rntb_Mins.Text);*/
//_obj_smhr_ottrans.OTCALC_COMMENTS = rtxt_Comments.Text;
//_obj_smhr_ottrans.CREATEDBY = Convert.ToInt32(Session["EMP_ID"]);
//_obj_smhr_ottrans.LASTMDFBY = Convert.ToInt32(Session["EMP_ID"]);
//_obj_smhr_ottrans.EMPOTTRANS_STATUS = 0;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SUBMIT":
_obj_smhr_ottrans.OPERATION = operation.Update_New;
bool status = BLL.SetOT(_obj_smhr_ottrans);
if (status == true)
{
BLL.ShowMessage(this, "Approved successfully");
}
else
{
BLL.ShowMessage(this, "Information not Saved");
}
break;
case "BTN_UPDATE":
_obj_smhr_ottrans.OPERATION = operation.Update;
_obj_smhr_ottrans.EMPOTTRANS_ID = otid;
if (BLL.SetOT(_obj_smhr_ottrans))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
default:
break;
}
Rm_OverTime_page.SelectedIndex = 0;
LoadGrid();
Rg_OverTime.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcRM", 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");
}
}
protected void btn_Process_Click(object sender, EventArgs e)
{
try
{
/* To check if record is selected */
int count = 0;
int OtCount = 0;
for (int x = 0; x < Rg_OTDetails.Items.Count; x++)
{
CheckBox chk = Rg_OTDetails.Items[x].FindControl("chk_emp") as CheckBox;
RadNumericTextBox rnt = Rg_OTDetails.Items[x].FindControl("txt_nofdays") as RadNumericTextBox;
if (chk.Checked)
{
count++;
if (rnt.Value != null)
{
OtCount++;
}
}
}
if (count == 0)
{
BLL.ShowMessage(this, "Please Select Atleast one Employee.");
return;
}
if (count != OtCount)
{
BLL.ShowMessage(this, "Please Enter No. Of OT Hours for Selected Employees.");
return;
}
/* To check if record is selected */
int i, a, b;
//int j = 0;
decimal c = 0;
StringBuilder strQry = new StringBuilder();
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
_obj_smhr_ottrans.EMPOTTRANS_PERIOD_ID = Convert.ToInt32(rcmb_PeriodMaster.SelectedItem.Value);
_obj_smhr_ottrans.EMPOTTRANS_PERIODDTL_ID = Convert.ToInt32(rcmb_PeriodElement.SelectedItem.Value);
for (i = 0; i <= Rg_OTDetails.Items.Count - 1; i++)
{
Label lblempid = new Label();
RadNumericTextBox txtgetVal = new RadNumericTextBox();
CheckBox chkChoose = new CheckBox();
Label lblAtt_Status = new Label();
chkChoose = Rg_OTDetails.Items[i].FindControl("chk_emp") as CheckBox;
txtgetVal = Rg_OTDetails.Items[i].FindControl("txt_nofdays") as RadNumericTextBox;
lblempid = Rg_OTDetails.Items[i].FindControl("lbl_empid") as Label;
lblAtt_Status = Rg_OTDetails.Items[i].FindControl("lbl_Att_Status") as Label;
if (Convert.ToString(txtgetVal.Text) != "" && chkChoose.Checked)
{
//if (Convert.ToDouble(txtgetVal.Text) >= 720)
//{
// BLL.ShowMessage(this, "No of working Hours should not exceed 720");
// return;
//}
if (Convert.ToDouble(txtgetVal.Text) > 15)
{
BLL.ShowMessage(this, "No of working Hours should not exceed 15");
return;
}
//if (chkChoose.Checked == false)
//{
// //BLL.ShowMessage(this, "Please select Employee");
// //return;
// continue;
//}
_obj_smhr_employee = new SMHR_EMPLOYEE();
_obj_smhr_employee.EMP_ID = Convert.ToInt32(lblempid.Text);
_obj_smhr_employee.Mode = 1;
DataTable dt = BLL.get_EmpESS(_obj_smhr_employee);
if (dt.Rows.Count != 0)
{
//sal = Convert.ToInt32(dt.Rows[0]["EMP_GROSSSAL"]);
sal = Convert.ToInt32(dt.Rows[0]["EMP_BASIC"]);
}
a = Convert.ToInt32(txtgetVal.Text);
///to caluluate OT hours we should subtract normal working hours 180 from total input
///formula to calculate OT for Weekends
///Basic Salary * 2/480 = Rate * Total Hours Worked = Total Amount
///
///formula to claculate OT for Weekdays
///Basic Salary * 3/480 = Rate * Total Hours Worked = Total Amount
/* Attendance Staus*/
/* Note:
* Present = "P"
* Absent = "A"
* Leave = "L"
* Weekly-Off = "W"
* Travel = "T"
* Comp Off = "C"
* Holiday = "H"
* Half Day Absent = "HD"
* Half Day Leave = "HL"
*/
//To calculate over time
if (lblAtt_Status.Text.Trim() == "P") //WeekDay
{
/* WeekDay Calculation */
b = a;
//c = ((sal * 3 )/ 480) * b;
c = Math.Round(((((Convert.ToDecimal(sal) * 3) / 480)) * b), 0);
string otamount = Convert.ToString(c);
/* For WeekDay Overtime */
}
else if (lblAtt_Status.Text.Trim() == "W") //WeekEnd/WeekOff
{
/* WeekEnds Calculation */
b = a;
c = (sal * 2 / 240) * b;
c = Math.Round(((((Convert.ToDecimal(sal) * 2) / 240)) * b), 0);
string otamount = Convert.ToString(c);
/* For WeekEnds Overtime */
}
else if (lblAtt_Status.Text.Trim() == "WO") //WeekEnd/WeekOff
{
/* WeekEnds Calculation */
b = a;
c = (sal * 2 / 240) * b;
c = Math.Round(((((Convert.ToDecimal(sal) * 2) / 240)) * b), 0);
string otamount = Convert.ToString(c);
/* For WeekEnds Overtime */
}
else if (lblAtt_Status.Text.Trim() == "H") //Holidays
{
/* WeekEnds Calculation */
b = a;
//c = (sal * 2 / 240) * b;
c = Math.Round(((((Convert.ToDecimal(sal) * 2) / 240)) * b), 0);
string otamount = Convert.ToString(c);
/* For WeekEnds Overtime */
}
else
{
continue;
}
/* Previous code */
//b = a;
//c = (b * sal) / 180;
//string otamount = Convert.ToString(c);
/* Previous code */
_obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(lblempid.Text);
_obj_smhr_ottrans.EMPOTTRANS_PERIOD_ID = Convert.ToInt32(rcmb_PeriodMaster.SelectedItem.Value);
_obj_smhr_ottrans.EMPOTTRANS_HOURS = b;
_obj_smhr_ottrans.EMPOTTANS_AMOUNT = Convert.ToSingle(c);
_obj_smhr_ottrans.EMPOTTRANS_STATUS = 0;
_obj_smhr_ottrans.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_ottrans.CREATEDDATE = System.DateTime.Now;
_obj_smhr_ottrans.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_ottrans.LASTMDFDATE = System.DateTime.Now;
_obj_smhr_ottrans.MODE = 2;
_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_ottrans.OTCALC_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate);
strQry.Append("EXEC USP_SMHR_OTCALC ");
string str = " @Mode = '" + _obj_smhr_ottrans.MODE + "'" +
",@BUID = '" + _obj_smhr_ottrans.BUID + "'" +
",@OTCALC_EMPID = '" + _obj_smhr_ottrans.EMPOTTRANS_EMPID + "'" +
",@OTCALC_PERIOD = '" + _obj_smhr_ottrans.EMPOTTRANS_PERIOD_ID + "'" +
",@EMPOTTRANS_PERIODDTL_ID = '" + _obj_smhr_ottrans.EMPOTTRANS_PERIODDTL_ID + "'" +
",@OTCALC_WORKINGHOURS = '" + _obj_smhr_ottrans.EMPOTTRANS_HOURS + "'" +
",@OTCALC_OTAMOUNT = '" + _obj_smhr_ottrans.EMPOTTANS_AMOUNT + "'" +
",@OTCALC_STATUS = '" + _obj_smhr_ottrans.EMPOTTRANS_STATUS + "'" +
",@OTCALC_ORG_ID='" + _obj_smhr_ottrans.ORGANISATION_ID + "'" +
",@OTCALC_CREATEDBY = '" + _obj_smhr_ottrans.EMPOTTRANS_STATUS + "'" +
",@OTCALC_CREATEDDATE = '" + Convert.ToDateTime(_obj_smhr_ottrans.CREATEDDATE).ToString("MM/dd/yyyy") + "'" +
",@OTCALC_LASTMDFBY = '" + _obj_smhr_ottrans.LASTMDFBY + "'" +
",@OTCALC_LASTMDFDATE = '" + Convert.ToDateTime(_obj_smhr_ottrans.LASTMDFDATE).ToString("MM/dd/yyyy") + "'" +
",@OTCALC_DATE = '" + Convert.ToDateTime(_obj_smhr_ottrans.OTCALC_DATE).ToString("MM/dd/yyyy") + "'";
strQry.Append(str);
}
//else
//{
// j = j + 1;
//}
/*As The Tester Wants null can be inserted for the employee if they don't want to give any over time amount*/
/* Sravani */
//if (j == Rg_OTDetails.Items.Count)
//{
// BLL.ShowMessage(this, "Please Enter atleaset one value");
// return;
//}
else
{
//IF THERE IS NO AMOUNT AND NO HOURS AN EMPLOYEE HAS WORKED THEN DELETING THAT RECORD
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
_obj_smhr_ottrans.MODE = 3;
_obj_smhr_ottrans.EMPOTTRANS_PERIODDTL_ID = Convert.ToInt32(rcmb_PeriodElement.SelectedValue);
_obj_smhr_ottrans.BUID = Convert.ToInt32(rcmb_BUI.SelectedValue);
_obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(lblempid.Text);
_obj_smhr_ottrans.OTCALC_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate);
bool Status = BLL.Set_Ot(_obj_smhr_ottrans);
}
}
if (strQry.Length > 0)
{
_obj_smhr_ottrans.MODE = 2;
bool rs = BLL.Cal_OTAmount(_obj_smhr_ottrans, strQry.ToString());
if (rs == true)
{
BLL.ShowMessage(this, "Over Time Calculation Completed Successfully");
//btn_Cancle_Click(null, null);
return;
}
else
{
BLL.ShowMessage(this, "Error found");
}
Rg_OTDetails.DataBind();
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Finalise.Visible = false;
}
else
{
btn_Finalise.Visible = false;
}
btn_Process.Enabled = true;
}
else
{
BLL.ShowMessage(this, "Over Time Calculation Completed Successfully");
}
//}
}
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 btn_Submit_Click(object sender, EventArgs e)
{
try
{
//CheckBox chk_box1 = new CheckBox();
//Label lblid = new Label();
////lblCode
//int j = 0;
//for (int i = 0; i < Rg_OverTime.Items.Count; i++)
//{
// chk_box1 = Rg_OverTime.Items[i].FindControl("chk_Select") as CheckBox;
// if (chk_box1.Checked)
// {
// j = j + 1;
// }
//}
//SMHR_EMPOTTRANS _obj_smhr_ottrans = new SMHR_EMPOTTRANS();
//_obj_smhr_ottrans.OPERATION = operation.Update;
//Label lbl_approveid = new Label();
//Label lbl_sanctionid = new Label();
//SMHR_EMPOTTRANS _obj_ot = new SMHR_EMPOTTRANS();
//_obj_ot.OPERATION = operation.New;
////as we are getting the status of the loans by passing loanstatus id but not checking corresponding with organisation
//_obj_ot.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//DataTable dt_status = BLL.get_EmployeeStatus(_obj_ot);
//if (dt_status.Rows.Count > 0)
//{
// for (int i = 0; i < dt_status.Rows.Count; i++)
// {
// if (Convert.ToString(dt_status.Rows[i]["hr_master_desc"]).Trim() == "Approved")
// {
// lbl_approveid.Text = Convert.ToString(dt_status.Rows[i]["hr_master_id"]);
// }
// else
// {
// lbl_sanctionid.Text = Convert.ToString(dt_status.Rows[i]["hr_master_id"]);
// }
// }
//}
//CheckBox chk_Open = new CheckBox();
//int count = 0;
//for (int i = 0; i < Rg_OverTime.Items.Count; i++)
//{
// chk_Open = Rg_OverTime.Items[i].FindControl("chk_Select") as CheckBox;
// if (chk_Open.Checked == true)
// {
// count++;
// }
//}
//if (count == 0)
//{
// BLL.ShowMessage(this, "Please Select atleast one Employee");
// return;
//}
//decimal actHrs = 0, actMins = 0;
//if (rtbActHrs.Text == string.Empty)
// rtbActHrs.Text = actHrs.ToString();
//else
// actHrs = Convert.ToDecimal(rtbActHrs.Text);
//if (rtbActMins.Text == string.Empty)
// rtbActMins.Text = actMins.ToString();
//else
// actMins = Convert.ToDecimal(rtbActMins.Text);
//decimal OTHRS = 0, OTMINS = 0;
//if (rtbOTHrs.Text == string.Empty)
// rtbOTHrs.Text = OTHRS.ToString();
//else
// OTHRS = Convert.ToDecimal(rtbOTHrs.Text);
//if (rtbOTMins.Text == string.Empty)
// rtbOTMins.Text = OTMINS.ToString();
//else
// OTMINS = Convert.ToDecimal(rtbOTMins.Text);
//for (int i = 0; i < Rg_OverTime.Items.Count; i++)
//{
// lblid = Rg_OverTime.Items[i].FindControl("Label1") as Label;
// //lblCode = Rg_OverTime.Items[i].FindControl("rcmb_Status") as RadComboBox;
// //lMode = Rg_OverTime.Items[i].FindControl("lbl_DPname") as RadDatePicker;
// chk_Open = Rg_OverTime.Items[i].FindControl("chk_Select") as CheckBox;
// if (chk_Open.Checked == true)
// {
// }
//}
_obj_smhr_ottrans = new SMHR_EMPOTTRANS();
// _obj_smhr_ottrans.EMPOTTRANS_EMPID = Convert.ToInt32(rcmb_Employee.SelectedValue);
_obj_smhr_ottrans.EMPOTTRANS_ID = otid;
_obj_smhr_ottrans.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_ottrans.EMPOTTRANS_STATUS = 1;
TimeSpan fromtime = new TimeSpan(Convert.ToDateTime(rdp_fromtime.SelectedDate).Hour, Convert.ToDateTime(rdp_fromtime.SelectedDate).Minute, Convert.ToDateTime(rdp_fromtime.SelectedDate).Second);
_obj_smhr_ottrans.OTCALC_FROMTIME = fromtime;
TimeSpan totime = new TimeSpan(Convert.ToDateTime(rdp_totime.SelectedDate).Hour, Convert.ToDateTime(rdp_totime.SelectedDate).Minute, Convert.ToDateTime(rdp_totime.SelectedDate).Second);
_obj_smhr_ottrans.OTCALC_TOTIME = totime;
//_obj_smhr_ottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
//_obj_smhr_ottrans.BUID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
////_obj_smhr_ottrans.OTCALC_EMPCODE = rntb_code.Text;
//_obj_smhr_ottrans.EMPOTTRANS_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate);
///*_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32((Convert.ToInt32(rtbOTHrs.Text) * 60) + Convert.ToInt32(rntb_Mins.Text));
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToInt32((Convert.ToInt32(rtbOTHrs.Text) * 60) + Convert.ToInt32(rtbOTMins.Text));*/
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32((actHrs * 60) + actMins);
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToInt32((OTHRS * 60) + OTMINS);
///*_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToDecimal(rtbOTHrs.Text);
//_obj_smhr_ottrans.EMPOTTRANS_HOURS = Convert.ToDecimal(rtbOTMins.Text);
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32(rtbOTHrs.Text);
//_obj_smhr_ottrans.OTCALC_ACTUALHOURS = Convert.ToInt32(rntb_Mins.Text);*/
//_obj_smhr_ottrans.OTCALC_COMMENTS = rtxt_Comments.Text;
//_obj_smhr_ottrans.CREATEDBY = Convert.ToInt32(Session["EMP_ID"]);
//_obj_smhr_ottrans.LASTMDFBY = Convert.ToInt32(Session["EMP_ID"]);
// _obj_smhr_ottrans.EMPOTTRANS_STATUS = 1;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_SUBMIT":
_obj_smhr_ottrans.OPERATION = operation.Update_New;
bool status = BLL.SetOT(_obj_smhr_ottrans);
if (status == true)
{
BLL.ShowMessage(this, "Approved successfully");
}
else
{
BLL.ShowMessage(this, "Information not Saved");
}
break;
case "BTN_UPDATE":
_obj_smhr_ottrans.OPERATION = operation.Update;
_obj_smhr_ottrans.EMPOTTRANS_ID = otid;
if (BLL.SetOT(_obj_smhr_ottrans))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
default:
break;
}
Rm_OverTime_page.SelectedIndex = 0;
LoadGrid();
Rg_OverTime.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcHR", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Reject_Click(object sender, EventArgs e)
{
try
{
StringBuilder strQry = new StringBuilder();
CheckBox chkBox = new CheckBox();
Label lblID = new Label();
Label lbl_prddtl_ID = new Label();
Label lbl_BUID = new Label();
Label lbl_EMPid = new Label();
int i = 0;
string str = "";
bool status = false;
for (int index = 0; index <= RG_OTpproval.Items.Count - 1; index++)
{
string str1 = "";
chkBox = RG_OTpproval.Items[index].FindControl("chk_Choose") as CheckBox;
lblID = RG_OTpproval.Items[index].FindControl("lblempottrans_id") as Label;
lbl_prddtl_ID = RG_OTpproval.Items[index].FindControl("lblempottrans_prddtl_ID") as Label;
lbl_BUID = RG_OTpproval.Items[index].FindControl("lblempottrans_BU_ID") as Label;
lbl_EMPid = RG_OTpproval.Items[index].FindControl("lblempID") as Label;
if (chkBox.Checked)
{
if (str == "")
{
str = "" + lblID.Text + "";
}
else
{
str = str + "," + lblID.Text + "";
}
if (str1 == "")
{
str1 = "" + lbl_EMPid.Text + "";
}
}
}
if (string.IsNullOrEmpty(str))
{
BLL.ShowMessage(this, "Please Select Employees");
return;
}
for (int index = 0; index <= RG_OTpproval.Items.Count - 1; index++)
{
string str1 = "";
chkBox = RG_OTpproval.Items[index].FindControl("chk_Choose") as CheckBox;
lblID = RG_OTpproval.Items[index].FindControl("lblempottrans_id") as Label;
lbl_prddtl_ID = RG_OTpproval.Items[index].FindControl("lblempottrans_prddtl_ID") as Label;
lbl_BUID = RG_OTpproval.Items[index].FindControl("lblempottrans_BU_ID") as Label;
lbl_EMPid = RG_OTpproval.Items[index].FindControl("lblempID") as Label;
if (chkBox.Checked)
{
if (str == "")
{
str = "" + lblID.Text + "";
}
else
{
str = str + "," + lblID.Text + "";
}
if (str1 == "")
{
str1 = "" + lbl_EMPid.Text + "";
}
}
//}
//if (string.IsNullOrEmpty(str))
//{
// BLL.ShowMessage(this, "Please Select Employees");
// return;
//}
//bool status = false;
_obj_smhr_empottrans = new SMHR_EMPOTTRANS();
_obj_smhr_empottrans.EMPOTTRANS_EMPLOYEE = str1;
_obj_smhr_empottrans.EMPOTTRANS_STATUS = 2;
_obj_smhr_empottrans.BUID = Convert.ToInt32(lbl_BUID.Text);
_obj_smhr_empottrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_empottrans.EMPOTTRANS_PERIODDTL_ID = Convert.ToInt32(lbl_prddtl_ID.Text);
_obj_smhr_empottrans.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_empottrans.LASTMDFDATE = DateTime.Now;
_obj_smhr_empottrans.MODE = 5;
strQry.Append("EXEC USP_SMHR_OTCALC");
string strQ = " @Mode = '" + _obj_smhr_empottrans.MODE + "'" +
",@BUID = '" + _obj_smhr_empottrans.BUID + "'" +
",@OTCALC_EMPID = '" + _obj_smhr_empottrans.EMPOTTRANS_EMPLOYEE + "'" +
",@EMPOTTRANS_PERIODDTL_ID = '" + _obj_smhr_empottrans.EMPOTTRANS_PERIODDTL_ID + "'" +
",@OTCALC_STATUS = '" + _obj_smhr_empottrans.EMPOTTRANS_STATUS + "'" +
",@OTCALC_ORG_ID='" + _obj_smhr_empottrans.ORGANISATION_ID + "'" +
",@OTCALC_LASTMDFBY = '" + _obj_smhr_empottrans.LASTMDFBY + "'" +
",@OTCALC_LASTMDFDATE = '" + Convert.ToDateTime(_obj_smhr_empottrans.LASTMDFDATE).ToString("MM/dd/yyyy") + "'";
strQry.Append(strQ);
status = BLL.Cal_OTAmount(_obj_smhr_empottrans, strQry.ToString());
//if (status == true)
//{
// BLL.ShowMessage(this, "Selected Overtime Details Rejected");
// //LoadData();
// //return;
//}
}
if (status == true)
{
BLL.ShowMessage(this, "Selected Overtime Details Rejected");
//LoadData();
//return;
}
LoadData();
return;
//_obj_smhr_empottrans.OPERATION = operation.Check;
//status = BLL.set_EmpOTTrans(_obj_smhr_empottrans);
//if (status == true)
//{
// BLL.ShowMessage(this, "Selected Overtime Details Rejected");
// LoadData();
// return;
//}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_OverTime", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
