protected void lnkEdit_Click(object sender, EventArgs e)
{
try
{
EnableDisableCommandButtons(true);
LinkButton lnkBtn = (LinkButton)sender;
AttendanceAmendmentID = int.Parse(lnkBtn.CommandArgument);
AttendanceAmendment objAttendanceAmendment = new AttendanceAmendment();
objAttendanceAmendment = AttendanceAmendmentManagement.GetAttendanceAmendmentByAttendanceAmendmentID(AttendanceAmendmentID);
lbl_AttendanceAmmendmentApproval.Text = String.Format("{0} details of {1}", objAttendanceAmendment.EmployeeName, objAttendanceAmendment.AttendanceType);
txt_EmpCode.Text = objAttendanceAmendment.EmployeeCode;
txt_EmpName.Text = objAttendanceAmendment.EmployeeName;
txt_Designation.Text = objAttendanceAmendment.DesignationDescription;
txt_AttendanceDate.Text = objAttendanceAmendment.DateOfAttendance.ToShortDateString();
txt_OldTime.Text = objAttendanceAmendment.OldTime.ToString("HH:mm:ss");
txt_NewTime.Text = objAttendanceAmendment.NewTime.ToString("HH:mm:ss");
txt_Reason.Text = objAttendanceAmendment.Reason;
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public int UpdateAttendanceAmendment(AttendanceAmendment _AttendanceAmendment)
{
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("@AttendanceAmendmentID", SqlDbType.Int, _AttendanceAmendment.AttendanceAmendmentID));
SqlCmd.Parameters.Add(GetParameter("@DateOfAttendance", SqlDbType.DateTime, _AttendanceAmendment.DateOfAttendance));
SqlCmd.Parameters.Add(GetParameter("@AttendanceType", SqlDbType.VarChar, _AttendanceAmendment.AttendanceType));
SqlCmd.Parameters.Add(GetParameter("@OldTime", SqlDbType.DateTime, _AttendanceAmendment.OldTime));
SqlCmd.Parameters.Add(GetParameter("@NewTime", SqlDbType.DateTime, _AttendanceAmendment.NewTime));
SqlCmd.Parameters.Add(GetParameter("@Reason", SqlDbType.VarChar, _AttendanceAmendment.Reason));
SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
SqlCmd.CommandText = "pHRM_AttendanceAmendments_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 ApproveOrRejectAttendanceAmendment(AttendanceAmendment _AttendanceAmendment)
{
try
{
return(AttendanceAmendmentDataAccess.GetInstance.ApproveOrRejectAttendanceAmendment(_AttendanceAmendment));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static int DeletetAttendanceAmendment(AttendanceAmendment _AttendanceAmendment)
{
try
{
return(AttendanceAmendmentIntegration.DeletetAttendanceAmendment(_AttendanceAmendment));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
private static List <AttendanceAmendment> SetAttendaneAmendmentList(DataTable AttendanceAmendmentDataTable)
{
try
{
List <AttendanceAmendment> AttendanceAmendmentList = new List <AttendanceAmendment>();
foreach (DataRow DtRow in AttendanceAmendmentDataTable.Rows)
{
AttendanceAmendment ObjAttendanceAmendment = new AttendanceAmendment();
ObjAttendanceAmendment.AttendanceAmendmentID = int.Parse(DtRow["AttendanceAmendmentID"].ToString());
ObjAttendanceAmendment.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
ObjAttendanceAmendment.EmployeeName = DtRow["EmployeeName"].ToString();
ObjAttendanceAmendment.EmployeeCode = DtRow["EmployeeCode"].ToString();
ObjAttendanceAmendment.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
ObjAttendanceAmendment.DesignationDescription = DtRow["DesignationDescription"].ToString();
ObjAttendanceAmendment.DateOfAttendance = DateTime.Parse(DtRow["DateOfAttendance"].ToString());
ObjAttendanceAmendment.AttendanceType = DtRow["AttendanceType"].ToString();
// ObjAttendanceAmendment.OldTime = DateTime.Parse(DtRow["OldTime"].ToString()).ToString(MicroConstants.TimeFormat);
// ObjAttendanceAmendment.NewTime = DateTime.Parse(DtRow["NewTime"].ToString()).ToString(MicroConstants.TimeFormat);
ObjAttendanceAmendment.OldTime = DateTime.Parse(DtRow["OldTime"].ToString());
ObjAttendanceAmendment.NewTime = DateTime.Parse(DtRow["NewTime"].ToString());
ObjAttendanceAmendment.Reason = DtRow["Reason"].ToString();
ObjAttendanceAmendment.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
ObjAttendanceAmendment.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
ObjAttendanceAmendment.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
//ObjAttendanceAmendment.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
ObjAttendanceAmendment.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
else
{
ObjAttendanceAmendment.ApprovalOrRejectionReason = "-";
}
ObjAttendanceAmendment.IsActive = (Boolean)DtRow["IsActive"];
ObjAttendanceAmendment.IsDeleted = (Boolean)DtRow["IsDeleted"];
AttendanceAmendmentList.Add(ObjAttendanceAmendment);
}
return(AttendanceAmendmentList);
}
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();
TheAttendanceAmendment.EmployeeID = TheEmployee.EmployeeID;
TheAttendanceAmendment.DateOfAttendance = DateTime.Parse(txt_AttendanceDate.Text);
TheAttendanceAmendment.AttendanceType = ddl_AttendanceType.SelectedValue;
TheAttendanceAmendment.OldTime = DateTime.Parse(txt_OldTime.Text);
TheAttendanceAmendment.Reason = txt_Reason.Text;
TheAttendanceAmendment.NewTime = DateTime.Parse(txt_NewTime.Text);
ProcReturnValue = AttendanceAmendmentManagement.InsertAttendanceAmendment(TheAttendanceAmendment);
return(ProcReturnValue);
}
public static AttendanceAmendment GetAttendanceAmendmentByAttendanceAmendmentID(int AttendanceAmendmentID)
{
try
{
DataRow DtRow = AttendanceAmendmentDataAccess.GetInstance.GetAttendanceAmendmentByAttendanceAmendmentID(AttendanceAmendmentID);
AttendanceAmendment _AttendanceAmendment = new AttendanceAmendment();
_AttendanceAmendment.AttendanceAmendmentID = int.Parse(DtRow["AttendanceAmendmentID"].ToString());
_AttendanceAmendment.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString());
_AttendanceAmendment.EmployeeName = DtRow["EmployeeName"].ToString();
_AttendanceAmendment.EmployeeCode = DtRow["EmployeeCode"].ToString();
_AttendanceAmendment.DepartmentDescription = DtRow["DepartmentDescription"].ToString();
_AttendanceAmendment.DesignationDescription = DtRow["DesignationDescription"].ToString();
_AttendanceAmendment.DateOfAttendance = DateTime.Parse(DtRow["DateOfAttendance"].ToString());
_AttendanceAmendment.AttendanceType = DtRow["AttendanceType"].ToString();
_AttendanceAmendment.OldTime = DateTime.Parse(DtRow["OldTime"].ToString());
_AttendanceAmendment.NewTime = DateTime.Parse(DtRow["NewTime"].ToString());
_AttendanceAmendment.Reason = DtRow["Reason"].ToString();
_AttendanceAmendment.Status = DtRow["Status"].ToString();
if (DtRow["Status"].ToString() != "Pending")
{
_AttendanceAmendment.ApprovedBy.EmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
_AttendanceAmendment.ApprovedByEmployeeID = int.Parse(DtRow["ApprovedBy"].ToString());
//_AttendanceAmendment.ApproveDate = DateTime.Parse(DtRow["ApprovedOn"].ToString());
_AttendanceAmendment.ApprovalOrRejectionReason = DtRow["ApprovalOrRejectionReason"].ToString();
}
_AttendanceAmendment.IsActive = (Boolean)DtRow["IsActive"];
_AttendanceAmendment.IsDeleted = (Boolean)DtRow["IsDeleted"];
return(_AttendanceAmendment);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
int ProcReturnValue;
AttendanceAmendment TheAttendanceAmendment = new AttendanceAmendment();
TheAttendanceAmendment.AttendanceAmendmentID = AttendanceAmendmentID;
TheAttendanceAmendment.Status = ddl_AttendanceApproval.SelectedValue;
TheAttendanceAmendment.ApproveDate = DateTime.Now.Date;
TheAttendanceAmendment.ApprovalOrRejectionReason = txt_Reason.Text;
ProcReturnValue = AttendanceAmendmentManagement.ApproveOrRejectAttendanceAmendment(TheAttendanceAmendment);
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_ATTENDANCEAMMENDMENTAPPLICATION_APRPOVED");
dialog_Message.Show();
BindGridLeaveApplicationsToApproveReject();
ResetTextBoxes();
}
else if (ProcReturnValue < 0)
{
lbl_TheMessage.Text = ReadXML.GetSuccessMessage("KO_ATTENDANCEAMMENDMENTAPPLICATION_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(AttendanceAmendment theAttendanceAmendment)
{
if (theAttendanceAmendment.Status != "Pending")
{
txt_AttendanceDate.Text = theAttendanceAmendment.DateOfAttendance.ToShortDateString();
txt_OldTime.Text = theAttendanceAmendment.OldTime.ToString("h:mm tt");
txt_NewTime.Text = theAttendanceAmendment.NewTime.ToString("h:mm tt");
txt_Reason.Text = theAttendanceAmendment.Reason;
txt_AttendanceDate.Enabled = false;
txt_NewTime.Enabled = false;
txt_Reason.Enabled = false;
txt_Status.Text = theAttendanceAmendment.Status;
txt_ApprovedBy.Text = theAttendanceAmendment.ApprovedByEmployeeName;
txt_Remarks.Text = theAttendanceAmendment.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 = theAttendanceAmendment.DateOfAttendance.ToShortDateString();
ddl_AttendanceType.Text = theAttendanceAmendment.AttendanceType;
txt_OldTime.Text = theAttendanceAmendment.OldTime.ToString("h:mm tt");
txt_NewTime.Text = theAttendanceAmendment.NewTime.ToString("h:mm tt");
txt_Reason.Text = theAttendanceAmendment.Reason;
txt_Status.Text = theAttendanceAmendment.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));
}
public int DeleteAttendanceAmendment(AttendanceAmendment _AttendanceAmendment)
{
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("@AttendanceAmendmentID", SqlDbType.Int, _AttendanceAmendment.AttendanceAmendmentID));
SqlCmd.CommandText = "pHRM_AttendanceAmendments_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 int DeleteRecord(AttendanceAmendment theAttendanceAmendment)
{
int ProcReturnValue = AttendanceAmendmentManagement.DeletetAttendanceAmendment(theAttendanceAmendment);
return(ProcReturnValue);
}
