// PUT api/Data/5
public HttpResponseMessage PutEmployee(Int32 id, Employee employee)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != employee.Id)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public IHttpActionResult PutUser(int id, User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user.User_ID)
{
return(BadRequest());
}
db.Entry(user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static Sale DeleteSale(int saleID)
{
using (var context = new ServicesContext())
{
var selectedSale = context.Sales.FirstOrDefault(b => b.ID == saleID);
// Checking if the category exists within the database.
if (selectedSale != null)
{
// Minus one from the counter of the daily and monthly sale stats.
var selectedDailyStat = context.dailyStats.FirstOrDefault(b => b.salesDate == selectedSale.saleDate);
var selectedMonthlyStat = context.monthlyStats.FirstOrDefault
(b => b.salesMonth == selectedSale.saleDate.Month && b.salesYear == selectedSale.saleDate.Year);
if (selectedDailyStat != null)
{
selectedDailyStat.productsSold--;
}
if (selectedMonthlyStat != null)
{
selectedMonthlyStat.productsSold--;
}
context.Sales.Remove(selectedSale);
context.SaveChanges();
return(selectedSale);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public ActionResult DeleteUser(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
User u = db.Users.Find(id);
if (u != null)
{
db.Users.Remove(u);
db.SaveChanges();
}
return(Redirect("~/Account/DeleteUser"));
}
public static JArray EliminarFactura(int facturaID)
{
JArray arrayJSON = BuscarFactura(facturaID);
using (var context = new ServicesContext())
{
var factura = context.facturas.Where(x => x.ID == facturaID).
Select(x => new { x.ID, x.fecha, x.clienteFK }).FirstOrDefault();
// La factura no existe, retornar nulo.
if (factura == null)
{
return(null);
}
else
{
var encontrarFactura = context.facturas.SingleOrDefault(x => x.ID == facturaID);
context.facturas.Remove(encontrarFactura);
ServiciosDetallesFactura.RemoverDetallesFactura(facturaID);
context.SaveChanges();
return(arrayJSON);
}
}
}
public ActionResult AddComment(int?serviceId)
{
if (serviceId == null)
{
return(HttpNotFound());
}
Comment comment = new Comment();
comment.Text = Request.Form["commentText"];
comment.ServiceId = (int)serviceId;
comment.SenderId = ((User)Session["User"]).Id;
db.Comments.Add(comment);
db.SaveChanges();
return(Redirect("ServiceInfo/" + serviceId));
}
public static Product CreateProduct(Product product)
{
using (var context = new ServicesContext())
{
// Check if product already exists within database.
var findExistingProduct = context.Products.FirstOrDefault
(b => b.productName.ToUpper() == product.productName.ToUpper());
// Product object corrections
product.productName = product.productName.Trim();
product.productDescription = product.productDescription.Trim();
// Product doesn't exist.
if (findExistingProduct == null)
{
// Sum one to the counter of the product's category
var category = context.Categories.Single(b => b.ID == product.categoryID);
category.ammountProducts++;
context.Products.Add(product);
context.SaveChanges();
var newestProduct = context.Products.ToArray().Last();
return(newestProduct);
}
// Product already exists
else
{
return(null);
}
}
}
public static Product DeleteProduct(int productID)
{
using (var context = new ServicesContext())
{
var selectedProduct = context.Products.FirstOrDefault(b => b.ID == productID);
// Checking if the category exists within the database.
if (selectedProduct != null)
{
// Minus one from the counter of the product's category.
var selectedCategory = context.Categories.FirstOrDefault(b => b.ID == selectedProduct.categoryID);
selectedCategory.ammountProducts--;
context.Products.Remove(selectedProduct);
context.SaveChanges();
return(selectedProduct);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static Product UpdateProduct(int productID, Product product)
{
using (var context = new ServicesContext())
{
var selectedProduct = context.Products.FirstOrDefault(b => b.ID == productID);
// Checking if the product does exist within the database.
if (selectedProduct != null)
{
// Update category counters if a new category has been set for the product.
if (selectedProduct.categoryID != product.categoryID)
{
var oldCategory = context.Categories.Single(b => b.ID == selectedProduct.categoryID);
oldCategory.ammountProducts--;
var newCategory = context.Categories.Single(b => b.ID == product.categoryID);
newCategory.ammountProducts++;
}
selectedProduct.categoryID = product.categoryID;
selectedProduct.productName = product.productName.Trim();
selectedProduct.productDescription = product.productDescription.Trim();
selectedProduct.productAmmount = product.productAmmount;
selectedProduct.productPrice = product.productPrice;
context.SaveChanges();
return(selectedProduct);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static DailyStats DeleteDailyStat(int statID)
{
using (var context = new ServicesContext())
{
var selectedDailyStat = context.dailyStats.FirstOrDefault(b => b.ID == statID);
// Checking if the daily stats exists within the database.
if (selectedDailyStat != null)
{
// Remove daily sales from the monthly stats counter.
var selectedMonthlyStat = context.monthlyStats.FirstOrDefault
(b => b.salesMonth == selectedDailyStat.salesDate.Month &&
b.salesYear == selectedDailyStat.salesDate.Year);
if (selectedMonthlyStat != null)
{
selectedMonthlyStat.productsSold -= selectedDailyStat.productsSold;
}
context.dailyStats.Remove(selectedDailyStat);
context.SaveChanges();
return(selectedDailyStat);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static Category CreateCategory(Category category)
{
using (var context = new ServicesContext())
{
// Check if category already exists within database.
var findExistingCategory = context.Categories.FirstOrDefault
(b => b.categoryName.ToUpper() == category.categoryName.ToUpper());
// Category object corrections
category.categoryName = category.categoryName.Trim();
// Category doesn't exist.
if (findExistingCategory == null)
{
context.Categories.Add(category);
context.SaveChanges();
var newestCategory = context.Categories.ToArray().Last();
return(newestCategory);
}
// Category already exists
else
{
return(null);
}
}
}
public static Cliente EliminarCliente(int numeroRUT)
{
using (var context = new ServicesContext())
{
var encontrarCliente = context.clientes.SingleOrDefault(x => x.RUT == numeroRUT);
context.clientes.Remove(encontrarCliente);
context.SaveChanges();
return(encontrarCliente);
}
}
public static Sale CreateSale(Sale sale)
{
using (var context = new ServicesContext())
{
var currentDate = DateTime.Now.Date;
// Check if there's already a sales stat for this day.
var findDailyStat = context.dailyStats.FirstOrDefault
(b => b.salesDate == currentDate);
var findMonthlyStat = context.monthlyStats.FirstOrDefault
(b => b.salesMonth == DateTime.Now.Month && b.salesYear == DateTime.Now.Year);
// If there is an existing daily stat, sum one to the counter.
if (findDailyStat != null)
{
findDailyStat.productsSold++;
}
// If there isn't, create a new stat for this day.
else
{
DailyStats newStats = new DailyStats();
newStats.productsSold++;
context.dailyStats.Add(newStats);
}
// If the monthly stat already exists, sum one to the counter of that month.
if (findMonthlyStat != null)
{
findMonthlyStat.productsSold++;
}
// If there isn't an existing monthly stat, create one.
else
{
MonthlyStats newStats = new MonthlyStats();
newStats.productsSold++;
context.monthlyStats.Add(newStats);
}
// Sale object corrections
sale.saleDescription = sale.saleDescription.Trim();
context.Sales.Add(sale);
context.SaveChanges();
return(sale);
}
}
public static Producto EliminarProducto(int productoID)
{
using (var context = new ServicesContext())
{
var encontrarProducto = context.productos.SingleOrDefault(x => x.ID == productoID);
if (encontrarProducto == null)
{
return(null);
}
else
{
context.productos.Remove(encontrarProducto);
context.SaveChanges();
return(encontrarProducto);
}
}
}
public static Producto EditarProducto(int productoID, Producto producto)
{
using (var context = new ServicesContext())
{
var encontrarProducto = context.productos.SingleOrDefault(x => x.ID == productoID);
if (encontrarProducto == null)
{
return(null);
}
else
{
encontrarProducto.nombreProducto = producto.nombreProducto.Trim();
encontrarProducto.precioProducto = producto.precioProducto;
context.SaveChanges();
return(encontrarProducto);
}
}
}
public static Cliente ModificarCliente(int numeroRUT, Cliente cliente)
{
using (var context = new ServicesContext())
{
var encontrarCliente = context.clientes.SingleOrDefault(x => x.RUT == numeroRUT);
if (encontrarCliente != null)
{
encontrarCliente.nombreCliente = cliente.nombreCliente.Trim();
encontrarCliente.RUT = cliente.RUT;
encontrarCliente.cargoCliente = cliente.cargoCliente.Trim();
context.SaveChanges();
return(encontrarCliente);
}
else
{
return(null);
}
}
}
public static Producto CrearProducto(Producto producto)
{
using (var context = new ServicesContext())
{
var encontrarProducto = context.productos.
Where(x => x.nombreProducto.ToUpper() == producto.nombreProducto.ToUpper()).SingleOrDefault();
if (encontrarProducto != null)
{
return(null);
}
else
{
context.productos.Add(producto);
context.SaveChanges();
var ultimoProducto = context.productos.OrderByDescending(x => x.ID).FirstOrDefault();
return(ultimoProducto);
}
}
}
public static JArray CrearFactura(Factura factura)
{
using (var context = new ServicesContext())
{
context.facturas.Add(factura);
context.SaveChanges();
var ultimaFactura = context.facturas.OrderByDescending(x => x.ID).
Select(x => new { x.ID, x.fecha, x.clienteFK }).Take(1).FirstOrDefault();
for (int i = 0; i < factura.detallesVenta.Count; i++)
{
factura.detallesVenta.ElementAt(i).facturaFK = ultimaFactura.ID;
}
ServiciosDetallesFactura.CrearDetallesFactura(factura.detallesVenta);
JArray arrayJSON = BuscarFactura(ultimaFactura.ID);
return(arrayJSON);
}
}
public static Category DeleteCategory(int categoryID)
{
using (var context = new ServicesContext())
{
var selectedCategory = context.Categories.FirstOrDefault(b => b.ID == categoryID);
// Checking if the category exists within the database.
if (selectedCategory != null)
{
context.Categories.Remove(selectedCategory);
context.SaveChanges();
return(selectedCategory);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static MonthlyStats DeleteMonthlyStat(int statID)
{
using (var context = new ServicesContext())
{
var selectedMonthlyStat = context.monthlyStats.FirstOrDefault(b => b.ID == statID);
// Checking if the monthly stats exists within the database.
if (selectedMonthlyStat != null)
{
context.monthlyStats.Remove(selectedMonthlyStat);
context.SaveChanges();
return(selectedMonthlyStat);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static DailyStats CreateDailyStat(DailyStats dailyStat)
{
using (var context = new ServicesContext())
{
// Check if there's already a daily stat for this day.
var findDailyStat = context.dailyStats.FirstOrDefault
(b => b.salesDate == dailyStat.salesDate);
// If there isn't, create one.
if (findDailyStat == null)
{
context.dailyStats.Add(dailyStat);
context.SaveChanges();
return(dailyStat);
}
// If there is, return null and let the controller handle it.
else
{
return(null);
}
}
}
public static Category UpdateCategory(int categoryID, Category category)
{
using (var context = new ServicesContext())
{
var selectedCategory = context.Categories.FirstOrDefault(b => b.ID == categoryID);
// Checking if the category does exist within the database.
if (selectedCategory != null)
{
selectedCategory.categoryName = category.categoryName.Trim();
selectedCategory.ammountProducts = category.ammountProducts;
context.SaveChanges();
return(selectedCategory);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static DailyStats UpdateDailyStat(int statID, DailyStats dailyStat)
{
using (var context = new ServicesContext())
{
var selectedStat = context.dailyStats.FirstOrDefault(b => b.ID == statID);
// Checking if the stat does exist within the database.
if (selectedStat != null)
{
selectedStat.salesDate = dailyStat.salesDate;
selectedStat.productsSold = dailyStat.productsSold;
context.SaveChanges();
return(selectedStat);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static MonthlyStats CreateMonthlyStat(MonthlyStats monthlyStat)
{
using (var context = new ServicesContext())
{
// Check if there's already a stat for this month.
var findMonthlyStat = context.monthlyStats.FirstOrDefault
(b => b.salesMonth == monthlyStat.salesMonth && b.salesYear == monthlyStat.salesYear);
// If there isn't, create one.
if (findMonthlyStat == null)
{
context.monthlyStats.Add(monthlyStat);
context.SaveChanges();
return(monthlyStat);
}
// If there is, return null and let the controller handle it.
else
{
return(null);
}
}
}
public static Cliente CrearCliente(Cliente cliente)
{
string nombreCliente = cliente.nombreCliente.ToUpper();
using (var context = new ServicesContext())
{
var encontrarCliente = context.clientes.SingleOrDefault(
x => x.nombreCliente.ToUpper() == nombreCliente);
if (encontrarCliente != null)
{
return(null);
}
else
{
context.clientes.Add(cliente);
context.SaveChanges();
var ultimoCliente = context.clientes.OrderByDescending(x => x.ID).FirstOrDefault();
return(ultimoCliente);
}
}
}
public static MonthlyStats UpdateMonthlyStat(int statID, MonthlyStats monthlyStat)
{
using (var context = new ServicesContext())
{
var selectedStat = context.monthlyStats.FirstOrDefault(b => b.ID == statID);
// Checking if the stat does exist within the database.
if (selectedStat != null)
{
selectedStat.salesMonth = monthlyStat.salesMonth;
selectedStat.salesYear = monthlyStat.salesYear;
context.SaveChanges();
return(selectedStat);
}
// If it does not, return null.
else
{
return(null);
}
}
}
public static Sale UpdateSale(int saleID, Sale sale)
{
using (var context = new ServicesContext())
{
var selectedSale = context.Sales.FirstOrDefault(b => b.ID == saleID);
// Checking if the sale does exist within the database.
if (selectedSale != null)
{
selectedSale.saleDate = sale.saleDate;
selectedSale.saleDescription = sale.saleDescription.Trim();
selectedSale.saleTotal = sale.saleTotal;
context.SaveChanges();
return(selectedSale);
}
// If it does not, return null.
else
{
return(null);
}
}
}