public async Task <List <TimesheetRequestDTO> > GetRequests()
{
List <TimesheetRequestDTO> requests = new List <TimesheetRequestDTO>();
using (var _context = new DatabaseContext())
{
var reqs = await _context.TimesheetRequest.ToListAsync <TimesheetRequest>();
foreach (TimesheetRequest t in reqs)
{
TimesheetRequestDTO tmp = new TimesheetRequestDTO();
tmp.Id = t.RequestId;
tmp.Empid = t.EmpId;
tmp.Reason = t.Reason;
tmp.Status = t.Status;
tmp.ManagerId = t.ManagerId;
if (t.Status == 1)
{
tmp.Statusvalue = "Pending";
}
else if (t.Status == 2)
{
tmp.Statusvalue = "Approved";
}
else if (t.Status == 3)
{
tmp.Statusvalue = "Rejected";
}
requests.Add(tmp);
}
}
return(requests);
}
public async Task <TimesheetRequestDTO> AddRequest(TimesheetRequestDTO request)
{
try
{
var req = new TimesheetRequest()
{
EmpId = request.Empid,
Reason = request.Reason,
Status = request.Status,
ManagerId = request.ManagerId
};
int requestid;
using (var _context = new DatabaseContext())
{
_context.TimesheetRequest.Add(req);
requestid = await _context.SaveChangesAsync();
}
request.Id = requestid;
return(request);
}
catch (Exception e)
{
throw;
}
}
public async Task <IHttpActionResult> PostRequest(TimesheetRequestDTO request)
{
try
{
var result = await _timesheetService.AddRequest(request);
return(this.JsonDataResult(result));
}
catch (Exception e)
{
//Logger.Log(LogLevel.Error, e);
return(new InternalServerErrorResult(this));
}
}
public async Task <TimesheetRequestDTO> UpdateRequest(TimesheetRequestDTO request)
{
try
{
using (var _context = new DatabaseContext())
{
TimesheetRequest tr = await _context.TimesheetRequest.Where(x => x.RequestId == request.Id).FirstOrDefaultAsync <TimesheetRequest>();
{
tr.Status = request.Status;
_context.SaveChanges();
}
return(request);
}
}
catch (Exception e)
{
throw;
}
}
