public HttpResponseMessage GetHoursBetweenTwoDates(GetHrsByDateAndProjDomainModel model)
{
HttpResponseMessage httpResponse = new HttpResponseMessage();
try
{
model.startdate = DateTime.ParseExact(model.startdate, "dd/MM/yyyy", null).ToString("yyyy/MM/dd");
model.enddate = DateTime.ParseExact(model.enddate, "dd/MM/yyyy", null).ToString("yyyy/MM/dd");
var result = ProjectRepository.GetHoursBetweenTwoDates(model);
if (result == null)
{
httpResponse = Request.CreateResponse(HttpStatusCode.InternalServerError, "Error Occurred");
}
else
{
httpResponse = Request.CreateResponse(HttpStatusCode.OK, result);
}
return(httpResponse);
}
catch (Exception ex)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent("An error occurred, please try again or contact the administrator."),
ReasonPhrase = "An error occurred, please try again or contact the administrator.",
StatusCode = HttpStatusCode.InternalServerError
});
}
}
public List <HoursByDateAndProjDomainModel> GetHoursBetweenTwoDates(GetHrsByDateAndProjDomainModel model)
{
try
{
var records = objHelper.Query <HoursByDateAndProjDomainModel>("GET_HOURS_BETWEEN_TWO_DATES", new
{
ProjectId = model.Projectid,
startdate = Convert.ToDateTime(model.startdate),
enddate = Convert.ToDateTime(model.enddate)
}).ToList();
return(records);
}
catch (Exception ex)
{
return(null);
}
}
