public bool UpdateSalaryTicket(SalaryTicketModel salaryTicket)
{
var checkExistingTicket = ctx.SalaryTickets.Where(c => c.SalaryTicketID == salaryTicket.SalaryTicketID).FirstOrDefault <SalaryTicket>();
if (checkExistingTicket != null)
{
checkExistingTicket.EmployeeID = salaryTicket.EmployeeID;
checkExistingTicket.PeriodID = salaryTicket.PeriodID;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public HttpResponseMessage GetSalaryTicket([FromUri] SalaryTicketModel ticket)
{
try
{
IList <SalaryTicket> listticket = null;
listticket = salaryTicketManager.GetSalaryTickets(ticket);
if (listticket == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There are no ticket's name match the search value!!!"));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { SalaryTicketModel = listticket }));
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing GetSalaryTicket:" + e.Message));
}
}
public IList <SalaryTicket> GetSalaryTickets(SalaryTicketModel ticket)
{
IList <SalaryTicket> listticket = null;
using (var ctx = new SalaryManagement_SWD391_ProjectEntities_SalaryTicket())
{
if (ticket != null)
{
listticket = ctx.SalaryTickets.Where(c => (c.EmployeeID.Contains(ticket.EmployeeID) || ticket.EmployeeID == null) &&
(c.PeriodID.Contains(ticket.PeriodID) || ticket.PeriodID == null) &&
(c.SalaryTicketID.Contains(ticket.SalaryTicketID) || ticket.SalaryTicketID == null)
).ToList <SalaryTicket>();
}
else
{
listticket = ctx.SalaryTickets.ToList <SalaryTicket>();
}
}
return(listticket);
}
public HttpResponseMessage PutTicket(SalaryTicketModel salaryTicket)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid data!!!"));
}
bool check = salaryTicketManager.UpdateSalaryTicket(salaryTicket);
if (check)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Ticket updated!"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Ticket not found!!!"));
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing Put:" + e.Message));
}
}
