public static List <ATTEmployeeLeave> LeaveCheck(ATTEmployeeLeave objEmpLeave)
{
List <ATTEmployeeLeave> lstEmpLeaveApp = new List <ATTEmployeeLeave>();
try
{
//foreach (ATTLeaveTypeEmployee var in LSTEmpLeave)
//{
foreach (DataRow drow in DLLEmployeeLeaveApprove.LeaveCheck(objEmpLeave).Rows)
{
ATTEmployeeLeave objEmpAppCheck = new ATTEmployeeLeave();
objEmpAppCheck.OutMessage = drow["Out_Message"].ToString();
objEmpAppCheck.PeriodType = drow["Period_Type"].ToString();
objEmpAppCheck.PeriodCount = int.Parse(drow["Period_Count"].ToString());
objEmpAppCheck.PFY = drow["Fiscal_Year"].ToString();
//if (objEmpAppCheck.OutMessage == "OK")
//{
// get_ok(objEmpAppCheck.PeriodCount, objEmpAppCheck.PFY, objEmpAppCheck.PeriodType);
//}
lstEmpLeaveApp.Add(objEmpAppCheck);
}
//}
return(lstEmpLeaveApp);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnApprAdd_Click(object sender, EventArgs e)
{
if (txtApprName.Text != "")
{
this.btnAppSubmit.Enabled = true;
}
string msg = EmptyMessage();
if (msg != "")
{
this.lblStatusMessage.Text = msg;
this.programmaticModalPopup.Show();
return;
}
else
{
try
{
List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
ATTEmployeeLeave objEmpLST = LSTEmpLeave[grdRecLeaveApplications.SelectedIndex];
//bool a = txtApprName.HasAttributes;
objEmpLST.AppByID = int.Parse(txtApprName.Attributes["ID"].ToString());
objEmpLST.AppByName = this.txtApprName.Text;
objEmpLST.AppDate = this.txtApprDate.Text;
objEmpLST.AppFrom = this.txtApprFrom.Text;
objEmpLST.AppTo = this.txtApprTo.Text;
objEmpLST.AppDays = int.Parse(txtApprDays.Text);
if (chkbxAppr.Checked == true)
{
objEmpLST.Approved = "Y";
}
else
{
objEmpLST.Approved = "N";
}
objEmpLST.AppReason = this.txtApprReason.Text;
objEmpLST.Action = "E";
//LSTEmpLeave[grdRecLeaveApplications.SelectedIndex] = objEmpLST;
//grdRecLeaveApplications.SelectedIndex = -1;
Session["EmployeeLeave"] = LSTEmpLeave;
grdRecLeaveApplications.DataSource = LSTEmpLeave;
grdRecLeaveApplications.DataBind();
btnAppSubmit.Enabled = true;
//grdRecLeaveApplications.SelectedIndex = -1;
ClearControls("Search");
ClearControls("Submit");
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
return;
}
}
}
public static DataTable LeaveCheck(ATTEmployeeLeave var)
{
GetConnection conn = new GetConnection();
OracleConnection DBConn = conn.GetDbConn(Module.PMS);
string InsertUpdateDLSP = "SP_LEAVE_CHECK";
try
{
DataTable dt = new DataTable();
//foreach (ATTEmployeeLeave var in lstEmpLeave)
//{
OracleParameter[] paramArray = new OracleParameter[9];
paramArray[0] = Utilities.GetOraParam(":P_EMP_ID", var.EmpID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam("P_FROM_DATE", var.AppFrom, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam("P_TO_DATE", var.AppTo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam("P_NO_OF_DAYS", var.AppDays, OracleDbType.Int32, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam("P_LEAVE_TYPE_ID", var.LeaveTypeID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam("P_OUT_MSG", null, OracleDbType.Varchar2, ParameterDirection.Output);
paramArray[5].Size = 100;
paramArray[6] = Utilities.GetOraParam("P_PERIOD_TYPE", null, OracleDbType.Varchar2, ParameterDirection.Output);
paramArray[6].Size = 1;
paramArray[7] = Utilities.GetOraParam("P_PERIOD_COUNT", null, OracleDbType.Int32, ParameterDirection.Output);
paramArray[8] = Utilities.GetOraParam("P_FY", null, OracleDbType.Varchar2, ParameterDirection.Output);
paramArray[8].Size = 5;
DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray);
string out_msg = paramArray[5].Value.ToString();
string period_type = paramArray[6].Value.ToString();
int period_count = int.Parse(paramArray[7].Value.ToString());
string p_fy = paramArray[8].ToString();
//making a datatable for the above variables
dt.Columns.Add(new DataColumn("Out_Message"));
dt.Columns.Add(new DataColumn("Period_Type"));
dt.Columns.Add(new DataColumn("Period_Count"));
dt.Columns.Add(new DataColumn("Fiscal_Year"));
DataRow drw = dt.NewRow();
drw["Out_Message"] = out_msg;
drw["Period_Type"] = period_type;
drw["Period_Count"] = period_count;
drw["Fiscal_Year"] = p_fy;
dt.Rows.Add(drw);
//dt = (DataTable)ds.Tables[0];
//}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool LeaveApprove(ATTEmployeeLeave objEmpLeave)
{
try
{
return(DLLEmployeeLeaveApprove.LeaveApprove(objEmpLeave));
}
catch (Exception ex)
{
throw ex;
}
}
protected void OkButton2_Click(object sender, EventArgs e)
{
List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())];
if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
}
protected void btnAppSubmit_Click1(object sender, EventArgs e)
{
try
{
List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())];
objEmp.EntryBy = Session["UserName"].ToString();
if (objEmp.Approved == "N")
{
if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp))
{
this.lblStatusMessage.Text = "Employee Leave Approved Successfully";
this.programmaticModalPopup.Show();
grdRecLeaveApplications.DataSource = BLLEmployeeLeave.GetEmployeeLeave(null, "APP");
grdRecLeaveApplications.DataBind();
}
}
else
{
List <ATTEmployeeLeave> LSTLvAPP = BLLEmployeeLeaveApprove.LeaveCheck(objEmp);
if (LSTLvAPP[0].OutMessage != "OK")
{
this.lblStatusMessage2.Text = LSTLvAPP[0].OutMessage;
this.programmaticModalPopup2.Show();
return;
}
else if (LSTLvAPP[0].OutMessage == "OK")
{
if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp))
{
this.lblStatusMessage.Text = "Employee Leave Approved Successfully";
this.programmaticModalPopup.Show();
this.CollapsiblePanelExtender1.Collapsed = true;
this.CollapsiblePanelExtender1.ClientState = "true";
grdRecLeaveApplications.DataSource = BLLEmployeeLeave.GetEmployeeLeave(null, "APP");
grdRecLeaveApplications.DataBind();
}
}
}
ClearControls("Submit");
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
}
}
protected void btnAppSubmit_Click1(object sender, EventArgs e)
{
try
{
List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
ATTEmployeeLeave objEmp = lstEmployeeLeave[int.Parse(Session["index"].ToString())];
objEmp.EntryBy = Session["UserName"].ToString();
if (objEmp.Approved == "N")
{
if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
}
else
{
List <ATTEmployeeLeave> LSTLvAPP = BLLEmployeeLeaveApprove.LeaveCheck(objEmp);
if (LSTLvAPP[0].OutMessage != "OK")
{
this.lblStatusMessage2.Text = LSTLvAPP[0].OutMessage;
this.programmaticModalPopup2.Show();
}
else if (LSTLvAPP[0].OutMessage == "OK")
{
if (BLLEmployeeLeaveApprove.LeaveApprove(objEmp))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
}
}
//if (BLLEmployeeLeave.SaveEmpLeaveApplication(lstEmployeeLeave))
//{
// this.lblStatusMessage.Text = "Information Saved.";
// this.programmaticModalPopup.Show();
//}
ClearControls("Submit");
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
}
}
protected void btnApplSubmit_Click(object sender, EventArgs e)
{
if (ddlAppType.SelectedIndex == 0)
{
lblStatusMessage.Text = "Please Select leave Type first";
programmaticModalPopup.Show();
return;
}
if (txtEmpDate.Text == "")
{
lblStatusMessage.Text = "Please Enter Application Date first";
programmaticModalPopup.Show();
return;
}
List <ATTEmployeeLeave> LSTEmpLeave = new List <ATTEmployeeLeave>();
try
{
ATTEmployeeLeave att = new ATTEmployeeLeave();
att.EmpID = int.Parse(Session["UserID"].ToString());
att.EmpFullName = Session["UserName"].ToString();
att.ReqdFrom = txtEmpLvFrom.Text;
att.ReqdTo = txtEmpLvTo.Text;
att.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString());
att.EmpDays = int.Parse(txtEmpLvDays.Text.ToString());
att.ApplDate = txtEmpDate.Text;
att.EmpReason = txtEmpLvResn.Text;
att.EntryBy = Session["UserName"].ToString();
att.EntryDate = "";
att.Action = "A";
LSTEmpLeave.Add(att);
if (BLLEmployeeLeave.SaveEmpLeaveApplication(LSTEmpLeave))
{
ClearControls();
lblStatusMessage.Text = "Saved Successfully";
programmaticModalPopup.Show();
}
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message;
programmaticModalPopup.Show();
}
}
public static bool LeaveApprove(ATTEmployeeLeave var)
{
OracleTransaction Tran;
GetConnection conn = new GetConnection();
OracleConnection DBConn = conn.GetDbConn(Module.PMS);
Tran = DBConn.BeginTransaction();
try
{
string InsertUpdateDLSP = "SP_LEAVE_APPROVE";
OracleParameter[] paramArray = new OracleParameter[16];
paramArray[0] = Utilities.GetOraParam("P_IS_OTHERS", null, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_EMP_ID", var.EmpID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":P_LEAVE_TYPE_ID", var.LeaveTypeID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_APPL_DATE", var.ApplDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_APP_BY", var.AppByID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":P_APP_DATE", var.AppDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":P_APP_FROM_DATE", var.AppFrom, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":P_APP_TO_DATE", var.AppTo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":P_APP_NO_OF_DAYS", var.AppDays, OracleDbType.Int32, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":P_APP_YES_NO", var.Approved, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":P_APP_REASON", var.AppReason, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[11] = Utilities.GetOraParam(":P_LEAVE_FY", null, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[12] = Utilities.GetOraParam("P_LEAVE_PERIOD_UNIT", null, OracleDbType.Int32, ParameterDirection.Input);
paramArray[13] = Utilities.GetOraParam("P_PERIOD_TYPE", null, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[14] = Utilities.GetOraParam("P_PERIOD_COUNT", null, OracleDbType.Int32, ParameterDirection.Input);
paramArray[15] = Utilities.GetOraParam("P_LEAVE_TAKEN_CNT", null, OracleDbType.Int32, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray);
Tran.Commit();
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
DBConn.Close();
}
return(true);
}
public static List <ATTEmployeeLeave> GetEmpDesLeave(int eid)
{
List <ATTEmployeeLeave> lstEmployeeLeave = new List <ATTEmployeeLeave>();
try
{
foreach (DataRow row in DLLEmployeeLeave.GetEmpDesLeave(eid).Rows)
{
ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave();
ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
ObjAtt.NoOfDays = int.Parse(row["NO_OF_DAYS"].ToString());
ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
lstEmployeeLeave.Add(ObjAtt);
}
return(lstEmployeeLeave);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTEmployeeLeave> GetaApprovedLeave(string fromdate, string todate, int orgid, int desid)
{
List <ATTEmployeeLeave> LSTApprovedLeaves = new List <ATTEmployeeLeave>();
try
{
foreach (DataRow row in DLLEmployeeLeaveApprove.GetApprovedLeaves(fromdate, todate, orgid, desid).Rows)
{
ATTEmployeeLeave objEmpApprLeaves = new ATTEmployeeLeave();
objEmpApprLeaves.EmpID = int.Parse(row["EMP_ID"].ToString());
objEmpApprLeaves.EmpFullName = row["EMPFULLNAME"].ToString();
//objEmpApprLeaves.AppTo=row["TO_DATE"].ToString();
objEmpApprLeaves.ApprovedLeaves = row["EMP_APPR_LEAVE"].ToString();
LSTApprovedLeaves.Add(objEmpApprLeaves);
}
return(LSTApprovedLeaves);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTEmployeeLeave> GetEmployeeLeave(int?empID, string REQ_REC_APP)
{
List <ATTEmployeeLeave> lstEmployeeLeave = new List <ATTEmployeeLeave>();
try
{
if (REQ_REC_APP == "REQ")
{
foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows)
{
ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave();
ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString());
ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString();
ObjAtt.ApplDate = row["APPL_DATE"].ToString();
ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString();
ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString();
ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString());
ObjAtt.EmpReason = row["REQ_REASON"].ToString();
//ObjAtt.EntryBy = row["ENTRY_BY"].ToString();
//ObjAtt.EntryDate = row["ENTRY_DATE"].ToString();
ObjAtt.Action = "";
lstEmployeeLeave.Add(ObjAtt);
}
}
else if (REQ_REC_APP == "REC")
{
foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows)
{
ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave();
ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString());
ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString();
ObjAtt.ApplDate = row["APPL_DATE"].ToString();
ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString();
ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString();
ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString());
ObjAtt.EmpReason = row["REQ_REASON"].ToString();
ObjAtt.RecByName = row["RCMDNAME"].ToString();
ObjAtt.RecDate = row["REC_DATE"].ToString();
ObjAtt.RecFrom = row["REC_FROM_DATE"].ToString();
ObjAtt.RecTo = row["REC_TO_DATE"].ToString();
if (row["REC_NO_OF_DAYS"].ToString() == "")
{
ObjAtt.RecDays = null;
}
else
{
ObjAtt.RecDays = int.Parse(row["REC_NO_OF_DAYS"].ToString());
}
ObjAtt.Recommended = row["REC_YES_NO"].ToString();
ObjAtt.RecReason = row["REC_REASON"].ToString();
ObjAtt.Action = "";
lstEmployeeLeave.Add(ObjAtt);
}
}
else if (REQ_REC_APP == "APP")
{
foreach (DataRow row in DLLEmployeeLeave.GetEmployeeLeave(empID, REQ_REC_APP).Rows)
{
ATTEmployeeLeave ObjAtt = new ATTEmployeeLeave();
ObjAtt.EmpID = int.Parse(row["EMP_ID"].ToString());
ObjAtt.EmpFullName = row["EMPLOYEENAME"].ToString();
ObjAtt.ApplDate = row["APPL_DATE"].ToString();
ObjAtt.LeaveTypeID = int.Parse(row["LEAVE_TYPE_ID"].ToString());
ObjAtt.LeaveType = row["LEAVE_TYPE_NAME"].ToString();
ObjAtt.ReqdFrom = row["REQ_FROM_DATE"].ToString();
ObjAtt.ReqdTo = row["REQ_TO_DATE"].ToString();
ObjAtt.EmpDays = int.Parse(row["REQ_NO_OF_DAYS"].ToString());
ObjAtt.EmpReason = row["REQ_REASON"].ToString();
ObjAtt.RecByName = row["RCMDNAME"].ToString();
ObjAtt.RecDate = row["REC_DATE"].ToString();
ObjAtt.RecFrom = row["REC_FROM_DATE"].ToString();
ObjAtt.RecTo = row["REC_TO_DATE"].ToString();
if (row["REC_NO_OF_DAYS"].ToString() == "")
{
ObjAtt.RecDays = null;
}
else
{
ObjAtt.RecDays = int.Parse(row["REC_NO_OF_DAYS"].ToString());
}
ObjAtt.RecReason = row["REC_REASON"].ToString();
ObjAtt.Recommended = row["REC_YES_NO"].ToString();
ObjAtt.AppByName = row["APPNAME"].ToString();
ObjAtt.AppDate = row["APP_DATE"].ToString();
ObjAtt.AppFrom = row["APP_FROM_DATE"].ToString();
ObjAtt.AppTo = row["APP_TO_DATE"].ToString();
if (row["APP_NO_OF_DAYS"].ToString() == "")
{
ObjAtt.AppDays = null;
}
else
{
ObjAtt.AppDays = int.Parse(row["APP_NO_OF_DAYS"].ToString());
}
ObjAtt.Approved = row["APP_YES_NO"].ToString();
ObjAtt.AppReason = row["APP_REASON"].ToString();
ObjAtt.Action = "";
lstEmployeeLeave.Add(ObjAtt);
}
}
return(lstEmployeeLeave);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAddRecommendation_Click(object sender, EventArgs e)
{
if (this.grdEmployee.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "**कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
}
string msg = EmptyMessage("rec");
if (msg != "")
{
this.lblStatusMessage.Text = msg;
this.programmaticModalPopup.Show();
return;
}
else
{
try
{
List <ATTEmployeeLeave> lstEmployeeLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
ATTEmployeeLeave objEmpLST = lstEmployeeLeave[grdLeaveApplications.SelectedIndex];
int empid = lstEmployeeLeave[grdLeaveApplications.SelectedIndex].EmpID;
int recid = int.Parse(txtRecName.Attributes["ID"].ToString());
if (recid == empid)
{
btnRecSubmit.Enabled = false;
this.lblStatusMessage.Text = "**सिफारिस गर्ने कर्मचारी मिलेन....</n>**र्कपया अर्को कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
this.txtRecName.Text = "";
this.txtRecName.Focus();
return;
}
objEmpLST.RecByID = int.Parse(txtRecName.Attributes["ID"].ToString());
objEmpLST.RecByName = this.txtRecName.Text;
objEmpLST.RecDate = this.txtRecDate.Text;
objEmpLST.RecFrom = this.txtRecFrom.Text;
objEmpLST.RecTo = this.txtRecTo.Text;
objEmpLST.RecDays = int.Parse(txtRecDays.Text);
if (chkbxRec.Checked == true)
{
objEmpLST.Recommended = "Y";
}
else
{
objEmpLST.Recommended = "N";
}
objEmpLST.RecReason = this.txtRecReason.Text;
//objEmpLST.Approved = "N";
objEmpLST.Action = "E";
//LSTEmpLeave.Add(objEmpLST);
Session["EmployeeLeave"] = lstEmployeeLeave;
grdLeaveApplications.DataSource = lstEmployeeLeave;
grdLeaveApplications.DataBind();
btnRecSubmit.Enabled = true;
grdLeaveApplications.SelectedIndex = -1;
ClearControls(1, 0, 2, 0);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
return;
}
}
}
//button events
protected void btnAddApplication_Click(object sender, EventArgs e)
{
if (this.grdEmployee.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "**कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
}
ddlAppType.Enabled = true;
string msg = EmptyMessage("appl");
if (msg != "")
{
this.lblStatusMessage.Text = msg;
this.programmaticModalPopup.Show();
return;
}
else
{
try
{
List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
if (LSTEmpLeave == null)
{
LSTEmpLeave = new List <ATTEmployeeLeave>();
}
ATTEmployeeLeave objEmpLST = new ATTEmployeeLeave();
if (this.grdLeaveApplications.SelectedIndex > -1)
{
objEmpLST = LSTEmpLeave[grdLeaveApplications.SelectedIndex];
objEmpLST.EmpID = int.Parse(txtEmpName.Attributes["ID"].ToString());
objEmpLST.EmpFullName = this.txtEmpName.Text;
objEmpLST.ApplDate = this.txtEmpDate.Text;
objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString());
objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString();
objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text;
objEmpLST.ReqdTo = this.txtEmpLvTo.Text;
objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString());
objEmpLST.EmpReason = this.txtEmpLvResn.Text;
objEmpLST.EntryBy = Session["UserName"].ToString();
objEmpLST.EntryDate = "";
objEmpLST.Action = "E";
}
else
{
objEmpLST.EmpID = int.Parse(grdEmployee.SelectedRow.Cells[0].Text);
int searchEmp = objEmpLST.EmpID;
List <ATTEmployeeLeave> LST = LSTEmpLeave.FindAll(
delegate(ATTEmployeeLeave obj)
{
return(searchEmp == obj.EmpID);
}
);
if (LST.Count > 0)
{
this.lblStatusMessage.Text = "This employee have already applied for leave and is not yet recommended";
this.programmaticModalPopup.Show();
this.btnApplSubmit.Enabled = false;
return;
}
objEmpLST.EmpFullName = this.txtEmpName.Text;
objEmpLST.ApplDate = this.txtEmpDate.Text;
objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString());
objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString();
objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text;
objEmpLST.ReqdTo = this.txtEmpLvTo.Text;
objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString());
objEmpLST.EmpReason = this.txtEmpLvResn.Text;
objEmpLST.EntryBy = Session["UserName"].ToString();
objEmpLST.EntryDate = "";
objEmpLST.Action = "A";
LSTEmpLeave.Add(objEmpLST);
}
Session["EmployeeLeave"] = LSTEmpLeave;
grdLeaveApplications.DataSource = LSTEmpLeave;
grdLeaveApplications.DataBind();
if (LSTEmpLeave.Count > 0)
{
this.grdLeaveApplications.Visible = true;
btnApplSubmit.Enabled = true;
}
else
{
this.grdLeaveApplications.Visible = false;
btnApplSubmit.Enabled = false;
}
ClearControls(1, 2, 0, 0);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
return;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//int leaveCount=0;
if (ddlMonth.SelectedIndex <= 0)
{
this.lblStatusMessage.Text = "महिना छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
GetCalender();
GetMonthlyHolidays();
int sata = (int)Session["Saturdays_Date"];
int holidayCounts = (int)Session["MonthlyHolidaysCount"];
foreach (GridViewRow rw in this.grdAttendance.Rows)
{
rw.Cells[36].Text = holidayCounts.ToString();
rw.Cells[37].Text = sata.ToString();
}
int orgid = int.Parse(this.ddlOrganization.SelectedValue.ToString());
int desid = 0;
if (this.ddlDesignation.SelectedIndex > 0)
{
desid = int.Parse(this.ddlDesignation.SelectedValue.ToString());
}
//-----------------------------------------------------------------------------------------------------------
#region Leave
DataTable dt = SetDataTable();
string FromDate = ddlYear.SelectedValue + "/" + ddlMonth.SelectedValue + "/" + "01";
string ToDate = "";
if (ddlMonth.SelectedIndex > 0 && ddlMonth.SelectedValue != "12")
{
ToDate = ddlYear.SelectedValue + "/" + 00 + (int.Parse(ddlMonth.SelectedValue) + 1) + "/" + "01";
}
else if (ddlMonth.SelectedIndex > 0 & ddlMonth.SelectedValue == "12")
{
ToDate = (int.Parse(ddlYear.SelectedValue) + 1) + "/" + 00 + (int.Parse(ddlMonth.SelectedValue) + 1) + "/" + "01";
}
List <ATTEmployeeLeave> LSTEmpLeave = BLLEmployeeLeaveApprove.GetaApprovedLeave(FromDate, ToDate, orgid, desid);
List <ATTEmployeeLeave> PersonLv = new List <ATTEmployeeLeave>();
foreach (ATTEmployeeLeave lst in LSTEmpLeave)
{
bool existed = PersonLv.Exists(
delegate(ATTEmployeeLeave obj)
{
return(obj.EmpID == lst.EmpID);
}
);
if (!existed)
{
ATTEmployeeLeave objLeave = new ATTEmployeeLeave();
objLeave = lst;
PersonLv.Add(objLeave);
}
}
if (PersonLv.Count > 0)
{
foreach (ATTEmployeeLeave lsts in PersonLv)
{
DataRow dr = dt.NewRow();
int i = LSTEmpLeave.FindIndex(delegate(ATTEmployeeLeave obj)
{
return(obj.EmpID == lsts.EmpID);
}
);
if (i >= 0)
{
dr[1] = LSTEmpLeave[i].EmpFullName.ToString();
dt.Rows.Add(dr);
}
}
}
if (LSTEmpLeave.Count > 0)
{
int k = 0;
foreach (ATTEmployeeLeave lsts in LSTEmpLeave)
{
if (lsts.ApprovedLeaves.Trim() != "")
{
string[] lvs = lsts.ApprovedLeaves.Split(',');
for (int j = 0; j < lvs.Length; j++)
{
if (lvs[j].Length == 1)
{
lvs[j] = "0" + lvs[j];
}
dt.Rows[k][lvs[j]] = "L";
}
dt.Rows[k]["Leave"] = lvs.Length;
}
k++;
}
}
else
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
//GetCalender();
}
#endregion
//-----------------------------------------------------------------------------------------------------------
#region Present
string yearmonth = this.ddlYear.SelectedValue.ToString() + "/" + ddlMonth.SelectedValue.ToString();
List <ATTAttendance> LSTAttendance = BLLAttendance.GetEmpAttendance(orgid, desid, yearmonth);
List <ATTAttendance> Persons = new List <ATTAttendance>();
foreach (ATTAttendance lst in LSTAttendance)
{
bool existed = Persons.Exists(
delegate(ATTAttendance obj)
{
return(obj.EmpID == lst.EmpID);
}
);
if (!existed)
{
ATTAttendance objAttn = new ATTAttendance();
objAttn = lst;
Persons.Add(objAttn);
}
}
//DataTable dt = SetDataTable();
if (Persons.Count > 0)
{
foreach (ATTAttendance lst in Persons)
{
int i = LSTEmpLeave.FindIndex(delegate(ATTEmployeeLeave obj)
{
return(obj.EmpID == lst.EmpID);
}
);
if (i >= 0)
{
//DataRow dr = dt.NewRow();
//dt.Rows[i]["FullName"] = lst.EmpFullName.ToString();
List <ATTAttendance> LST = LSTAttendance.FindAll(delegate(ATTAttendance obj)
{
return(lst.EmpID == obj.EmpID);
});
foreach (ATTAttendance var in LST)
{
string day = var.PresentDate.Substring((var.PresentDate.LastIndexOf('/') + 1), 2);
if (day != null)
{
dt.Rows[i][day] = "P";
}
}
}
}
}
//else
//{
// DataRow dr = dt.NewRow();
// dt.Rows.Add(dr);
// //GetCalender();
//}
#endregion
//-----------------------------------------------------------------------------------------------------------
string holidays = Session["Month"].ToString();
//string fromDate=holidays.Substring(1,4) ((str.LastIndexOf('/') + 1), (str.Length - (str.LastIndexOf('/') + 1)));
int sat = (int)Session["Saturdays_Date"];
int holidayCount = (int)Session["MonthlyHolidaysCount"];
int daysCount = (int)Session["Days"];
//int leaveCount = (int)Session["ApprovedLeavesCount"];
//foreach (GridViewRow rw in this.grdAttendance.Rows)
//{
// //rw.Cells[35].Text = LeaveCount.ToString();
// rw.Cells.["Holiday"].Text = holidayCount.ToString();
// rw.Cells["Weekend"].Text = sat.ToString();
//}
foreach (DataRow rw in dt.Rows)
{
int leaveCount = 0;
string lvCnt = rw["Leave"].ToString();
if (lvCnt != "")
{
leaveCount = int.Parse(lvCnt);
}
//rw.Cells[35].Text = LeaveCount.ToString();
rw["Holiday"] = holidayCount.ToString();
rw["Weekend"] = sat.ToString();
string workingDays = (daysCount - (holidayCount + sat)).ToString();
rw["WorkingDays"] = workingDays;
Session["WorkDays"] = workingDays;
foreach (DataColumn dc in dt.Columns)
{
string st = rw[dc].ToString().Trim();
if (st == "")
{
rw[dc] = "A";
}
}
string ACheck = rw["Leave"].ToString().Trim();
string FCheck = rw["FullName"].ToString().Trim();
if (ACheck == "A")
{
rw["Leave"] = "";
}
if (FCheck == "A")
{
rw["FullName"] = "";
}
}
int colCount = dt.Columns.Count;
foreach (DataRow dr in dt.Rows)
{
int AbsCount = 0;
int PresCount = 0;
for (int i = 0; i < colCount - 1; i++)
{
if (dr[i].ToString() == "A")
{
AbsCount++;
}
else if (dr[i].ToString() == "P")
{
PresCount++;
}
}
dr["Absent"] = AbsCount.ToString();
dr["Present"] = PresCount.ToString();
}
grdAttendance.DataSource = dt;
grdAttendance.DataBind();
Session["Data"] = dt;
}
//button events
protected void btnAddApplication_Click(object sender, EventArgs e)
{
ddlAppType.Enabled = true;
string msg = EmptyMessage("appl");
if (msg != "")
{
this.lblStatusMessage.Text = msg;
this.programmaticModalPopup.Show();
return;
}
else
{
try
{
List <ATTEmployeeLeave> LSTEmpLeave = (List <ATTEmployeeLeave>)Session["EmployeeLeave"];
if (LSTEmpLeave == null)
{
LSTEmpLeave = new List <ATTEmployeeLeave>();
}
else if (LSTEmpLeave.Count > 0)
{
btnApplSubmit.Enabled = true;
}
ATTEmployeeLeave objEmpLST = new ATTEmployeeLeave();
objEmpLST.EmpID = int.Parse(txtEmpName.Attributes["ID"].ToString());
objEmpLST.EmpFullName = this.txtEmpName.Text;
objEmpLST.ApplDate = this.txtEmpDate.Text;
objEmpLST.LeaveTypeID = int.Parse(this.ddlAppType.SelectedValue.ToString());
objEmpLST.LeaveType = this.ddlAppType.SelectedItem.ToString();
objEmpLST.ReqdFrom = this.txtEmpLvFrom.Text;
objEmpLST.ReqdTo = this.txtEmpLvTo.Text;
objEmpLST.EmpDays = int.Parse(this.txtEmpLvDays.Text.ToString());
objEmpLST.EmpReason = this.txtEmpLvResn.Text;
objEmpLST.EntryBy = Session["UserName"].ToString();
objEmpLST.EntryDate = "";
objEmpLST.Action = "A";
if (grdLeaveApplications.SelectedIndex == -1)
{
//if (lstLeaveTypeEmployee.Count > 0)
//{
foreach (ATTEmployeeLeave leave in LSTEmpLeave)
{
if (leave.LeaveTypeID == int.Parse(ddlAppType.SelectedValue))
{
grdLeaveApplications.SelectedIndex = -1;
this.lblStatusMessage.Text = " This Leave Type Already Exists. ";
this.programmaticModalPopup.Show();
return;
}
}
//}
LSTEmpLeave.Add(objEmpLST);
}
else
{
objEmpLST.Action = (LSTEmpLeave[grdLeaveApplications.SelectedIndex].Action == "A" ? "A" : "E");
LSTEmpLeave[grdLeaveApplications.SelectedIndex] = objEmpLST;
}
Session["EmployeeLeave"] = LSTEmpLeave;
grdLeaveApplications.DataSource = LSTEmpLeave;
grdLeaveApplications.DataBind();
if (LSTEmpLeave.Count > 0)
{
this.grdLeaveApplications.Visible = true;
}
ClearControls(1, 2, 0);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
return;
}
}
}
