public void LeaveApplicationUpdae(LeaveApplicationDTOs Record)
{
_unitOfWork.LeaveApplicationRepository.Update(LeaveApplicationMapper.LeaveApplicationDTOsToLeaveApplication(Record));
//if leave is approved
if (Record.LeaveStatus == 2 || Record.LeaveStatus == 3)
{
//call store proecudre for leave application attendance record
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_LeaveBalanceUpdate", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LeaveId", Record.LeaveId);
cmd.Parameters.AddWithValue("@LeaveStatus", Record.LeaveStatus);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
else if (Record.LeaveStatus == 5)
{
//call store proecudre for leave application attendance record
SqlConnection conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_LeaveBalanceUpdate", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LeaveId", Record.LeaveId);
cmd.Parameters.AddWithValue("@LeaveStatus", Record.LeaveStatus);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
public IEnumerable <LeaveApplicationDTOs> LeaveapplicationList()
{
List <LeaveApplication> Result = _unitOfWork.LeaveApplicationRepository.All().ToList();
return(LeaveApplicationMapper.ListLeaveApplicationToLeaveApplicationDTOssList(Result));
}
public void LeaveApplicationCreate(LeaveApplicationDTOs Record)
{
LeaveApplication data = _unitOfWork.LeaveApplicationRepository.Create(LeaveApplicationMapper.LeaveApplicationDTOsToLeaveApplication(Record));
}
public LeaveApplicationDTOs LeaveDetails(int LeaveId, int empcode)
{
LeaveApplication Detail = _unitOfWork.LeaveApplicationRepository.All().Where(x => x.LeaveId == LeaveId).FirstOrDefault();
return(LeaveApplicationMapper.LeaveApplicationToLeaveApplicationDTOss(Detail));
}
