public int UpdateAttendanceApplication(AttendanceApplication _AttendanceApplication)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("@AttendanceApplicationID", SqlDbType.Int, _AttendanceApplication.AttendanceApplicationID));
SqlCmd.Parameters.Add(GetParameter("@DateOfAttendance", SqlDbType.DateTime, _AttendanceApplication.DateOfAttendance));
SqlCmd.Parameters.Add(GetParameter("@InTime", SqlDbType.DateTime, _AttendanceApplication.InTime));
SqlCmd.Parameters.Add(GetParameter("@OutTime", SqlDbType.DateTime, _AttendanceApplication.OutTime));
SqlCmd.Parameters.Add(GetParameter("@Reason", SqlDbType.VarChar, _AttendanceApplication.ApplicationReason));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_AttendanceApplications_Update";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int DeleteRecord(AttendanceApplication theAttendanceApplication)
{
int ProcReturnValue = AttendanceApplicationManagement.DeletetAttendanceApplication(theAttendanceApplication);
return(ProcReturnValue);
}
public int DeleteAttendanceApplication(AttendanceApplication _AttendanceApplication)
{
try
{
int ReturnValue = 0;
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
SqlCmd.Parameters.Add(GetParameter("@AttendanceApplicationID", SqlDbType.Int, _AttendanceApplication.AttendanceApplicationID));
SqlCmd.CommandText = "pHRM_AttendanceApplications_Delete";
ExecuteStoredProcedure(SqlCmd);
ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <AttendanceApplication> SetAttendanceApplicationList(DataTable AttendanceApplicationTable)
{
try
{
List <AttendanceApplication> AttendanceApplicationList = new List <AttendanceApplication>();
foreach (DataRow DtRow in AttendanceApplicationTable.Rows)
{
AttendanceApplication _AttendanceApplication = new AttendanceApplication();
_AttendanceApplication.AttendanceApplicationID = int.Parse(DtRow["AttendanceApplicationID"].ToString());
_AttendanceApplication.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
_AttendanceApplication.EmployeeName = DtRow["EmployeeName"].ToString();
_AttendanceApplication.EmployeeCode = DtRow["EmployeeCode"].ToString();
_AttendanceApplication.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
_AttendanceApplication.DesignationDescription = DtRow["DesignationDescription"].ToString();
_AttendanceApplication.DateOfAttendance = DateTime.Parse(DtRow["DateOfAttendance"].ToString());
if (DtRow["InTime"].ToString() != "")
{
_AttendanceApplication.InTime = DateTime.Parse(DtRow["InTime"].ToString());
}
if (DtRow["OutTime"].ToString() != "")
{
_AttendanceApplication.OutTime = DateTime.Parse(DtRow["OutTime"].ToString());
}
_AttendanceApplication.ApplicationReason = DtRow["Reason"].ToString();
_AttendanceApplication.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
_AttendanceApplication.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_AttendanceApplication.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
//_AttendanceApplication.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
_AttendanceApplication.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
else if (DtRow["Status"].ToString() == "Pending")
{
_AttendanceApplication.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
_AttendanceApplication.IsActive = Boolean.Parse(DtRow["IsActive"].ToString());
_AttendanceApplication.IsDeleted = Boolean.Parse(DtRow["IsDeleted"].ToString());
AttendanceApplicationList.Add(_AttendanceApplication);
}
return(AttendanceApplicationList);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int DeletetAttendanceApplication(AttendanceApplication _AttendanceApplication)
{
try
{
return(AttendanceApplicationIntegration.DeletetAttendanceApplication(_AttendanceApplication));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int ApproveOrRejectAttendanceApplication(AttendanceApplication _AttendanceApplication)
{
try
{
return(AttendanceApplicationDataAccess.GetInstance.ApproveOrRejectAttendanceApplication(_AttendanceApplication));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static AttendanceApplication GetAttendanceApplicationByAttendanceApplicationID(int AttendanceApplicationID)
{
try
{
DataRow DtRow = AttendanceApplicationDataAccess.GetInstance.GetAttendanceApplicationByAttendanceApplicationID(AttendanceApplicationID);
AttendanceApplication _AttendanceApplication = new AttendanceApplication();
_AttendanceApplication.AttendanceApplicationID = int.Parse(DtRow["AttendanceApplicationID"].ToString());
_AttendanceApplication.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
_AttendanceApplication.EmployeeName = DtRow["EmployeeName"].ToString();
_AttendanceApplication.EmployeeCode = DtRow["EmployeeCode"].ToString();
_AttendanceApplication.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
_AttendanceApplication.DesignationDescription = DtRow["DesignationDescription"].ToString();
_AttendanceApplication.DateOfAttendance = DateTime.Parse(DtRow["DateOfAttendance"].ToString());
if (DtRow["InTime"].ToString() != "")
{
_AttendanceApplication.InTime = DateTime.Parse(DtRow["InTime"].ToString());
}
if (DtRow["OutTime"].ToString() != "")
{
_AttendanceApplication.OutTime = DateTime.Parse(DtRow["OutTime"].ToString());
}
_AttendanceApplication.ApplicationReason = DtRow["Reason"].ToString();
_AttendanceApplication.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
_AttendanceApplication.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_AttendanceApplication.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_AttendanceApplication.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
_AttendanceApplication.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
{
_AttendanceApplication.ApprovalOrRejectionReason = "-";
}
_AttendanceApplication.IsActive = Boolean.Parse(DtRow["IsActive"].ToString());
_AttendanceApplication.IsDeleted = Boolean.Parse(DtRow["IsDeleted"].ToString());
return(_AttendanceApplication);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
private int InsertRecord()
{
int ProcReturnValue = 0;
PageVariables.TheUserReferenceID = Connection.LoggedOnUser.UserReferenceID;
Employee TheEmployee = EmployeeManagement.GetInstance.GetEmployeeByID(PageVariables.TheUserReferenceID);
// AttendanceAmendment TheAttendanceAmendment = new AttendanceAmendment();
AttendanceApplication TheAttendanceApplication = new AttendanceApplication();
TheAttendanceApplication.EmployeeID = TheEmployee.EmployeeID;
TheAttendanceApplication.DateOfAttendance = DateTime.Parse(txt_AttendanceDate.Text);
TheAttendanceApplication.InTime = DateTime.Parse(txt_InTime.Text);
TheAttendanceApplication.OutTime = DateTime.Parse(txt_OutTime.Text);
TheAttendanceApplication.ApplicationReason = txt_Reason.Text;
ProcReturnValue = AttendanceApplicationManagement.InsertAttendanceApplication(TheAttendanceApplication);
return(ProcReturnValue);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
int ProcReturnValue;
AttendanceApplication TheAttendanceApplication = new AttendanceApplication();
TheAttendanceApplication.AttendanceApplicationID = AttendanceApplicationID;
TheAttendanceApplication.Status = ddl_AmmendmentStatus.SelectedValue;
TheAttendanceApplication.ApproveDate = DateTime.Now.Date;
TheAttendanceApplication.ApprovalOrRejectionReason = txt_Reason.Text;
ProcReturnValue = AttendanceApplicationManagement.ApproveOrRejectAttendanceApplication(TheAttendanceApplication);
if (ProcReturnValue > 0)
{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", String.Format("alert('successfully {0} the leave application.');", TheLeaveApplication.Status), true);
lbl_TheMessage.Text = ReadXML.GetSuccessMessage("OK_ATTENDANCEAPPLICATION_APRPOVED");
dialog_Message.Show();
BindGridLeaveApplicationsToApproveReject();
ResetTextBoxes();
}
else if (ProcReturnValue < 0)
{
lbl_TheMessage.Text = ReadXML.GetSuccessMessage("KO_ATTENDANCEAPPLICATION_APRPOVED");
BindGridLeaveApplicationsToApproveReject();
dialog_Message.Show();
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('Sorry! failed to approve / reject the leave application.');", true);
ResetTextBoxes();
}
EnableDisableCommandButtons(false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private void PopulatePageFields(AttendanceApplication theAttendanceApplication)
{
if (theAttendanceApplication.Status != "Pending")
{
txt_AttendanceDate.Text = theAttendanceApplication.DateOfAttendance.ToShortDateString();
txt_InTime.Text = theAttendanceApplication.InTime.ToString("h:mm tt");;
txt_OutTime.Text = theAttendanceApplication.OutTime.ToString("h:mm tt");;
txt_Reason.Text = theAttendanceApplication.ApplicationReason;
txt_AttendanceDate.Enabled = false;
txt_OutTime.Enabled = false;
txt_InTime.Enabled = false;
txt_Reason.Enabled = false;
txt_Status.Text = theAttendanceApplication.Status;
txt_ApprovedBy.Text = theAttendanceApplication.ApprovedByEmployeeName;
txt_Remarks.Text = theAttendanceApplication.ApprovalOrRejectionReason;
Btn_Save.Visible = false;
}
else
{
//(tmEditInTime.Text == "01-01-0001 00:00:00" ? "" : DateTime.Parse(tmEditInTime.Text).ToString("HH:mm:ss"));
txt_AttendanceDate.Text = theAttendanceApplication.DateOfAttendance.ToShortDateString();
txt_InTime.Text = theAttendanceApplication.InTime.ToString("h:mm tt");
txt_OutTime.Text = theAttendanceApplication.OutTime.ToString("h:mm tt");
txt_Reason.Text = theAttendanceApplication.ApplicationReason;
//txt_Status.Text = theAttendanceApplication.Status;
// txt_ApprovedBy.Text = "";
//txt_Remarks.Text = "";
Btn_Save.Visible = true;
}
//txt_DepartmentDescription.Text = theDepartment.DepartmentDescription;
//ddl_ParentDepartment.SelectedIndex = GetDropDownSelectedIndex(ddl_ParentDepartment, Convert.ToString(theDepartment.ParentDepartmentId));
}
protected void lnkEdit_Click(object sender, EventArgs e)
{
EnableDisableCommandButtons(true);
LinkButton lnkBtn = (LinkButton)sender;
AttendanceApplicationID = int.Parse(lnkBtn.CommandArgument);
AttendanceApplication objAttendanceApplication = new AttendanceApplication();
objAttendanceApplication = AttendanceApplicationManagement.GetAttendanceApplicationByAttendanceApplicationID(AttendanceApplicationID);
// objAttendanceAmendment = AttendanceAmendmentManagement.GetAttendanceAmendmentByAttendanceAmendmentID(AttendanceAmendmentID);
// lbl_AttandanceApproval.Text = String.Format("{0} details of {1}", objAttendanceApplication.EmployeeName, objAt);
txt_EmpCode.Text = objAttendanceApplication.EmployeeCode;
txt_EmpName.Text = objAttendanceApplication.EmployeeName;
txt_Designation.Text = objAttendanceApplication.DesignationDescription;
txt_AttendanceDate.Text = objAttendanceApplication.DateOfAttendance.ToShortDateString();
txt_InTime.Text = objAttendanceApplication.InTime.ToString("HH:mm:ss");
txt_OutTime.Text = objAttendanceApplication.OutTime.ToString("HH:mm:ss");
}
