public async Task AddOrderIncome(CreateViewModel orderModel) { // we create the date with the current date var dateOrderIncome = DateTime.Now; OrderIncome order = new OrderIncome { IdProvider = orderModel.IdProvider, IdUser = orderModel.IdUser, Total = orderModel.Total, State = "Accept" }; _context.OrderIncomes.Add(order); await _context.SaveChangesAsync(); // Adding details to detailOrder var IdOrderIncome = order.IdOrderIncome; // We loop de property details in CreateViewModel to add every // detail in OrderDetail Table in the same method Add of OrderIncome foreach (var det in orderModel.Details) { OrderIncomeDetails detail = new OrderIncomeDetails { IdOrderIncome = IdOrderIncome, IdProduct = det.IdProduct, Amount = det.Amount, DueDate = det.DueDate, UnitCost = det.UnitCost }; _context.OrderIncomeDetails.Add(detail); } await _context.SaveChangesAsync(); }
public async Task AddLoss(CreateViewModel lossModel) { Losses losses = new Losses { Cause = lossModel.Cause, State = lossModel.State }; _context.Losses.Add(losses); await _context.SaveChangesAsync(); }
public async Task AddLaboratory(CreateViewModel model) { Laboratory lab = new Laboratory { LaboratoryName = model.LaboratoryName, Description = model.Description, Condition = model.Condition }; _context.Laboratories.Add(lab); await _context.SaveChangesAsync(); }
public async Task AddRole(CreateViewModel model) { var role = new Role { RoleName = model.RoleName, Description = model.Description, Condition = model.State }; await _context.Roles.AddAsync(role); await _context.SaveChangesAsync(); }
public async Task AddAsync(CreateViewModel model) { Category category = new Category { Name = model.Name, Description = model.Description, Condition = model.Condition }; _context.Categories.Add(category); await _context.SaveChangesAsync(); }
public async Task AddDelivery(CreateViewModel deliveryModel) { Delivery delivery = new Delivery { IdSale = deliveryModel.IdSale, IdClient = deliveryModel.IdClient, Adress = deliveryModel.Adress, State = deliveryModel.State }; _context.Deliveries.Add(delivery); await _context.SaveChangesAsync(); }
public async Task AddProvider(CreateViewModel providerModel) { Provider provider = new Provider { ProviderName = providerModel.ProviderName, DocumentNumber = providerModel.DocumentNumber, Address = providerModel.Address, PhoneNumber = providerModel.PhoneNumber, Email = providerModel.Email }; _context.Providers.Add(provider); await _context.SaveChangesAsync(); }
public async Task AddClient(CreateViewModel clientModel) { Client client = new Client { Name = clientModel.Name, LastName = clientModel.LastName, DocumentType = clientModel.DocumentType, DocumentNumber = clientModel.DocumentNumber, PhoneNumber = clientModel.PhoneNumber, Condition = clientModel.Condition, }; _context.Clients.Add(client); await _context.SaveChangesAsync(); }
public async Task AddAsync(CreateViewModel model) { //Product product = new Product //{ // IdCategory = model.IdCategory, // IdLaboratory = model.IdLaboratory, // ProductName = model.ProductName, // BarCode = model.BarCode, // Indicative = model.Indicative, // Stock = model.Stock, // UnitPrice = model.UnitPrice, // SalePrice = model.SalePrice, // Condition = model.Condition //}; Product product = _mapper.Map <Product>(model); await _context.Products.AddAsync(product); await _context.SaveChangesAsync(); }
public async Task AddSale(CreateViewModel saleModel) { // we create the date with the current date var dateOrderIncome = DateTime.Now; Sale sale = new Sale { IdUser = saleModel.IdUser, IdClient = saleModel.IdClient, TypeSale = saleModel.TypeSale, VoucherSeries = saleModel.VoucherSeries, VoucherNumber = saleModel.VoucherNumber, TotalPrice = saleModel.TotalPrice, State = "Accepted" }; _context.Sales.Add(sale); await _context.SaveChangesAsync(); // Addind Details to DetailSale var id = sale.IdSale; // We loop de property details in CreateViewModel to add every // detail in SaleDetail Table in the same method Add of Sale foreach (var det in saleModel.Details) { SaleDetail detail = new SaleDetail { IdSale = id, IdProduct = det.IdProduct, Amount = det.Amount, Discount = det.Discount, UnitPrice = det.UnitPrice, SalePrice = det.SalePrice }; _context.saleDetails.Add(detail); } await _context.SaveChangesAsync(); }
public async Task UpdateUser(UpdateViewModel UserModel) { var user = await _context.Users.FirstOrDefaultAsync(u => u.IdUser == UserModel.IdUser); user.IdUser = UserModel.IdUser; user.IdRole = UserModel.IdRole; user.UserName = UserModel.UserName; user.DocumentType = UserModel.DocumentType; user.DocumentNumber = UserModel.DocumentNumber; user.Address = UserModel.Address; user.PhoneNumber = UserModel.PhoneNumber; user.Email = UserModel.Email; if (UserModel.Act_Password == true) { CreatePassword(UserModel.Password, out byte[] passwordHash, out byte[] passwordSalt); user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; } await _context.SaveChangesAsync(); }