public LeaveRequestView Get(int Id)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetLeaveRequestById", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", Id);
SqlDataReader rdr = cmd.ExecuteReader();
LeaveRequestView view = new LeaveRequestView();
if (rdr.Read())
{
view.Id = Convert.ToInt32(rdr["Id"]);
view.LeaveType = Convert.ToString(rdr["LeaveType"]);
view.LeaveNameType = (LeaveNameType)Convert.ToInt32(rdr["LeaveNameType"]);
view.RequestDate = Convert.ToDateTime(rdr["RequestDate"]);
view.StartDate = Convert.ToDateTime(rdr["StartDate"]);
if (rdr["EndDate"] != DBNull.Value)
{
view.EndDate = Convert.ToDateTime(rdr["EndDate"]);
}
if (rdr["HalfDay"] != DBNull.Value)
{
view.IsHalfDay = Convert.ToBoolean(rdr["HalfDay"]);
}
view.Notes = Convert.ToString(rdr["Notes"]);
view.Employee = Convert.ToString(rdr["Employee"]);
view.AlternateEmployee = Convert.ToString(rdr["AlternateEmployee"]);
if (rdr["ManagerEmployee"] != DBNull.Value)
{
view.ManagerEmployee = Convert.ToString(rdr["ManagerEmployee"]);
}
view.LeaveStatus = (RequestsEnum)Convert.ToInt32(rdr["Status"]);
}
return view;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public List<LeaveRequestView> ListLeaveRequestsApprovedByEmployee(int employeeId, StatusEnum? status)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_ListLeaveRequestsApprovedByEmployee", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeId", employeeId);
if (status != null)
{
cmd.Parameters.AddWithValue("@Status", status);
}
SqlDataReader rdr = cmd.ExecuteReader();
List<LeaveRequestView> list = new List<LeaveRequestView>();
while (rdr.Read())
{
LeaveRequestView view = new LeaveRequestView();
view.Id = Convert.ToInt32(rdr["Id"]);
view.LeaveType = Convert.ToString(rdr["LeaveType"]);
view.LeaveNameType = (LeaveNameType)Convert.ToInt32(rdr["LeaveNameType"]);
view.RequestDate = Convert.ToDateTime(rdr["RequestDate"]);
view.StartDate = Convert.ToDateTime(rdr["StartDate"]);
if (rdr["EndDate"] != DBNull.Value)
{
view.EndDate = Convert.ToDateTime(rdr["EndDate"]);
}
if (rdr["HalfDay"] != DBNull.Value)
{
view.IsHalfDay = Convert.ToBoolean(rdr["HalfDay"]);
}
view.Notes = Convert.ToString(rdr["Notes"]);
view.Employee = Convert.ToString(rdr["Employee"]);
view.AlternateEmployee = Convert.ToString(rdr["AlternateEmployee"]);
if (rdr["ManagerEmployee"] != DBNull.Value)
{
view.ManagerEmployee = Convert.ToString(rdr["ManagerEmployee"]);
}
view.LeaveStatus = (RequestsEnum)Convert.ToInt32(rdr["Status"]);
list.Add(view);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
