public List <CompanyHolidayDTO> GetAllCompanyHoliday(CompanyHolidayGetDTO objLeave)
{
List <CompanyHolidayDTO> Leave = new List <CompanyHolidayDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectCompanyHoliday");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ActionBy", objLeave.ActionBy);
Leave = dbLayer.GetEntityList <CompanyHolidayDTO>(SqlCmd);
}
return(Leave);
}
public CompanyHolidayDTO GetCompanyHolidayById(CompanyHolidayGetDTO objLeave)
{
CompanyHolidayDTO accounts = new CompanyHolidayDTO();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectCompanyHoliday");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Id", objLeave.Id);
SqlCmd.Parameters.AddWithValue("@ActionBy", objLeave.ActionBy);
accounts = dbLayer.GetEntityList <CompanyHolidayDTO>(SqlCmd).FirstOrDefault();
}
return(accounts);
}
public HttpResponseMessage GetCompanyHolidayById(CompanyHolidayGetDTO objLeave)
{
HttpResponseMessage message;
try
{
// CompanyHolidayDataAccessLayer dal = new CompanyHolidayDataAccessLayer();
var dynObj = new { result = _companyServices.GetCompanyHolidayById(objLeave) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "Leave", "CompanyHolidayById");
}
return(message);
}
