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