public RespBase <SalesInvoce> Update(SalesInvoce model)
{
RespBase <SalesInvoce> response = new RespBase <SalesInvoce>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.SalesInvoces.Where(x => x.SalesInvoceID == model.SalesInvoceID).FirstOrDefault();
item.Reason = model.Reason;
item.SellerID = model.SellerID;
item.CustomerID = model.CustomerID;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <SalesInvoceDetail> Update(SalesInvoceDetail model)
{
RespBase <SalesInvoceDetail> response = new RespBase <SalesInvoceDetail>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.SalesInvoceDetails.Where(x => x.SalesInvoceDetailID == model.SalesInvoceDetailID).FirstOrDefault();
item.Price = model.Price;
item.Quantity = model.Quantity;
item.SalesInvoceID = model.SalesInvoceID;
item.ProductID = model.ProductID;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
/// <summary>
/// Esto es para popular la base de datos, lo ignoramos porfa
/// </summary>
/// <param name="cantidad"></param>
public void PopularLaDB(int cantidad)
{
Persona persona;
var randomizer = new Random();
var provincias = new Dictionary <int, string>
{
{ 1, "SanJose" },
{ 2, "Heredia" },
{ 3, "Alajuela" },
{ 4, "Puntarenas" },
{ 5, "Limon" },
{ 6, "Guanacaste" },
{ 7, "Cartago" },
};
for (int i = 0; i < cantidad; i++)
{
persona = new Persona()
{
Nombre = RandomString(7, randomizer),
Edad = randomizer.Next(1, 80),
Genero = randomizer.Next(0, 2) == 1,
Provincia = provincias.GetValueOrDefault(randomizer.Next(1, 8), string.Empty),
Salario = randomizer.Next(300000, 8000001),
};
context.Add(persona);
}
context.SaveChanges();
}
public RespBase <Product> Update(Product model)
{
RespBase <Product> response = new RespBase <Product>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.Products.Where(x => x.ProductID == model.ProductID).FirstOrDefault();
item.Name = model.Name;
item.Stock = model.Stock;
item.Price = model.Price;
item.Remarks = model.Remarks;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <Seller> Update(Seller model)
{
RespBase <Seller> response = new RespBase <Seller>();
try
{
using (var context = new ProyectoFinalContext())
{
var seller = context.Sellers.Where(x => x.SellerID == model.SellerID).FirstOrDefault();
seller.Name = model.Name;
seller.LastName = model.LastName;
seller.Email = model.Email;
seller.Birthdate = model.Birthdate;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <Customer> Update(Customer model)
{
RespBase <Customer> response = new RespBase <Customer>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.Customers.Find(model.CustomerID);
item.Name = model.Name;
item.LastName = model.LastName;
item.Birthdate = model.Birthdate;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <SalesInvoceDetail> Add(SalesInvoceDetail model)
{
RespBase <SalesInvoceDetail> response = new RespBase <SalesInvoceDetail>();
try
{
using (var context = new ProyectoFinalContext())
{
model.State = true;
context.SalesInvoceDetails.Add(model);
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <SalesInvoceDetail> Delete(int ID)
{
RespBase <SalesInvoceDetail> response = new RespBase <SalesInvoceDetail>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.SalesInvoceDetails.Where(x => x.SalesInvoceDetailID == ID).FirstOrDefault();
context.SalesInvoceDetails.Remove(item);
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <Product> Delete(int ID)
{
RespBase <Product> response = new RespBase <Product>();
try
{
using (var context = new ProyectoFinalContext())
{
var item = context.Products.Where(x => x.ProductID == ID).FirstOrDefault();
item.State = false;
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <SalesInvoce> Add(SalesInvoce model)
{
RespBase <SalesInvoce> response = new RespBase <SalesInvoce>();
try
{
using (var context = new ProyectoFinalContext())
{
model.CreateAt = DateTime.Now;
model.State = true;
response.Object = context.SalesInvoces.Add(model);
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
public RespBase <Customer> Add(Customer model)
{
model.State = true;
model.CreateAt = DateTime.Now;
RespBase <Customer> response = new RespBase <Customer>();
try
{
using (var context = new ProyectoFinalContext())
{
context.Customers.Add(model);
context.SaveChanges();
}
response.IsSuccess = true;
response.Message = "Success";
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
response.IsSuccess = false;
return(response);
}
}
