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); } }