public IHttpActionResult Post(SaleExpense salesBalance)
{
var context = new ClipperDBEntities();
context.SaleExpenses.Add(salesBalance);
try
{
context.SaveChanges();
return(Ok());
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public IHttpActionResult Put(int id, SaleExpense salesExpense)
{
var context = new ClipperDBEntities();
Sale salesExpenseStatus = context.Sales.Find(id);
if (salesExpenseStatus == null)
{
return(NotFound());
}
else if (salesExpense == null)
{
ArgumentNullException argumentNullException = new ArgumentNullException();
return(InternalServerError(argumentNullException));
}
else
{
SaleExpense salesExpenseUpdate = context.SaleExpenses
.Where(e => e.SalesExpenseID == salesExpense.SalesExpenseID).FirstOrDefault();
if (salesExpenseUpdate != null)
{
context.Entry(salesExpense).CurrentValues.SetValues(salesExpense);
}
}
context.SaveChanges();
return(Ok(salesExpense));
}
public IHttpActionResult Get(int id)
{
var context = new ClipperDBEntities();
SaleExpense salaryRates = context.SaleExpenses.Find(id);
if (salaryRates == null)
{
return(NotFound());
}
else
{
context.Configuration.ProxyCreationEnabled = false;
var slaryFound = context.Salaries.First(e => e.RoleID == id);
return(Ok(slaryFound));
}
}
public IHttpActionResult Delete(int id)
{
var context = new ClipperDBEntities();
SaleExpense salesExpense = context.SaleExpenses.Find(id);
if (salesExpense == null)
{
return(NotFound());
}
else
{
context.SaleExpenses.Remove(salesExpense);
context.SaveChanges();
return(Ok(salesExpense));
}
}
public IHttpActionResult Get(DateTime saleDate)
{
var context = new ClipperDBEntities();
SaleExpense saleExpense = context.SaleExpenses.Find(saleDate);
if (saleExpense == null)
{
return(NotFound());
}
else
{
context.Configuration.ProxyCreationEnabled = false;
var salesExpenseFoundFound = context.SaleExpenses.First(e => e.Date == saleDate);
return(Ok(salesExpenseFoundFound));
}
}
