/**
* GET request that get one cash register
*/
public cash_register GetCashRegisterbyId(int cash, int subsidiary, int employee, DateTime initial_time)
{
var query = "SELECT * FROM getcashregister(" + cash + "," + subsidiary + ",'" + initial_time.ToString("yyyy-MM-dd HH:mm") + "'," + employee + ");";
cash_register pharma = _context.Database.SqlQuery <cash_register>(query).FirstOrDefault();
return(pharma);
}
/**
* PUT request that updates a cash register
*/
public Response UpdateCashRegister(cash_register c)
{
Response res = new Response();
res.success = true;
res.code = "1";
res.message = "SUCCESSFUL";
try
{
var query = "SELECT updatecashregister(" + c.cash + "," + c.subsidiary + ",'" + c.initial_time.ToString("yyyy-MM-dd HH:mm") + "'," + c.employee + ",'" + c.final_time.ToString("yyyy-MM-dd HH:mm") + "'," + c.final_cash.ToString("0.00", System.Globalization.CultureInfo.InvariantCulture) + ");";
_context.Database.SqlQuery <Int32>(query).FirstOrDefault();
}
catch (NpgsqlException ex)
{
res.success = false;
res.code = ex.Code;
res.message = ex.BaseMessage;
}
return(res);
}
/**
* PUT request that updates a cash register
*/
public Response Put(cash_register c)
{
return(repository.UpdateCashRegister(c));
}
/**
* POST request that inserts a cash register
*/
public Response Post(cash_register c)
{
return(repository.AddCashRegister(c));
}
