public bool Approve(LeaveRequestHistory leave)
{
try
{
SqlConnection sqlconn = new SqlConnection(connectionString);
SqlCommand sqlComm = new SqlCommand("approveLeaveRequest");
sqlconn.Open();
sqlComm.Connection = sqlconn;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.Parameters.AddWithValue("@Id", leave.Id);
sqlComm.Parameters.AddWithValue("@empId", leave.EmpId);
sqlComm.Parameters.AddWithValue("@startDate", leave.StartDate);
sqlComm.Parameters.AddWithValue("@endDate", leave.EndDate);
sqlComm.Parameters.AddWithValue("@leaveId", leave.LeaveId);
sqlComm.Parameters.AddWithValue("@reason", leave.Reason);
SqlParameter returnParameter = sqlComm.Parameters.Add("RetVal", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
sqlComm.ExecuteNonQuery();
int id = (int)returnParameter.Value;
if (id == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <LeaveRequestHistory> GetAllRequest(int id)
{
List <LeaveRequestHistory> lstLeaveRequest = new List <LeaveRequestHistory>();
SqlConnection sqlconn = new SqlConnection(connectionString);
SqlCommand sqlComm = new SqlCommand("allLeaveRequests");
sqlconn.Open();
sqlComm.Connection = sqlconn;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.Parameters.AddWithValue("@Id", id);
SqlDataReader sdr = sqlComm.ExecuteReader();
while (sdr.Read())
{
LeaveRequestHistory leaveRequestHistory = new LeaveRequestHistory();
leaveRequestHistory.Id = (int)sdr["Id"];
leaveRequestHistory.EmpId = (int)sdr["EmployeeId"];
leaveRequestHistory.EmployeeName = sdr["EmpName"].ToString();
leaveRequestHistory.StartDate = Convert.ToDateTime(sdr["StartDate"]).ToString("MM/dd/yyyy");
leaveRequestHistory.EndDate = Convert.ToDateTime(sdr["EndDate"]).ToString("MM/dd/yyyy");
leaveRequestHistory.LeaveId = (int)sdr["LeaveId"];
leaveRequestHistory.Leave = sdr["EType"].ToString();
leaveRequestHistory.Status = sdr["Status"].ToString();
leaveRequestHistory.Reason = sdr["Reason"].ToString();
lstLeaveRequest.Add(leaveRequestHistory);
}
sqlconn.Close();
return(lstLeaveRequest);
}
public bool Edit(LeaveRequestHistory leaveRequest)
{
try
{
return(_leaveRepository.Edit(leaveRequest));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Approve(LeaveRequestHistory leave)
{
try
{
return(_leaveRepository.Approve(leave));
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult Edit(LeaveRequestHistory leaveRequest)
{
try
{
return(Ok(_leaveService.Edit(leaveRequest)));
}
catch (Exception ex)
{
message = ex.Message;
_log.LogError(message);
return(StatusCode(StatusCodes.Status500InternalServerError, message));
}
}
public void Delete(LeaveRequestHistory entity)
{
_leaveRequestHistoryRepository.Delete(entity);
}
public void Update(LeaveRequestHistory entity)
{
_leaveRequestHistoryRepository.Update(entity);
}
public void Add(LeaveRequestHistory entity)
{
_leaveRequestHistoryRepository.Add(entity);
}
