public async Task <int> AddUserAsync(NewUserDto newUser) { var user = new User { Name = newUser.Name, Username = newUser.Username, Password = newUser.Password, Birthday = newUser.Birthday, HireDate = newUser.HireDate, IsActive = true }; var userRoles = new List <UserRole>(); foreach (var role in newUser.Roles) { userRoles.Add(new UserRole { RoleId = role.Id, UserId = user.Id }); } user.Roles = userRoles; var userStores = new List <UserStore>(); foreach (var store in newUser.Stores) { userStores.Add(new UserStore() { StoreId = store.Id, UserId = user.Id }); } user.Stores = userStores; await _dbContext.Users.AddAsync(user); if (await _dbContext.SaveChangesAsync() > 0) { return(user.Id); } return(0); }
public async Task <int> AddSizeAsync(NewSizeDto newSize) { var size = new Size { Name = newSize.Name, IsActive = true }; await _dbContext.Sizes.AddAsync(size); if (await _dbContext.SaveChangesAsync() > 0) { return(size.Id); } return(0); }
public async Task <int> AddBrandAsync(NewBrandDto newBrand) { var brand = new Brand { Name = newBrand.Name, IsActive = true }; await _dbContext.Brands.AddAsync(brand); if (await _dbContext.SaveChangesAsync() > 0) { return(brand.Id); } return(0); }
public async Task <int> AddColorAsync(NewColorDto newColor) { var color = new Color { Name = newColor.Name, RgbHex = newColor.RgbHex.ToUpper(), IsActive = true }; await _dbContext.Colors.AddAsync(color); if (await _dbContext.SaveChangesAsync() > 0) { return(color.Id); } return(0); }
public async Task <int> AddCashRegisterAsync(int storeId, NewCashRegisterDto newCashRegister) { var cashRegister = new CashRegister { StoreId = storeId, Name = newCashRegister.Name, IsActive = true }; await _dbContext.CashRegisters.AddAsync(cashRegister); if (await _dbContext.SaveChangesAsync() > 0) { return(cashRegister.Id); } return(0); }
public async Task <int> AddStoreAsync(NewStoreDto newStore) { var store = new Store { Name = newStore.Name, Address = newStore.Address, Phone = newStore.Phone, IsActive = true }; await _dbContext.Stores.AddAsync(store); if (await _dbContext.SaveChangesAsync() > 0) { return(store.Id); } return(0); }
public async Task <int> AddVendorAsync(NewVendorDto newVendor) { var vendor = new Vendor { Name = newVendor.Name, City = newVendor.City, CreationDate = DateTime.Now, Email = newVendor.Email, Phone = newVendor.Phone, Rfc = newVendor.Rfc.ToUpper(), Address = newVendor.Address, StateId = newVendor.State.Id, IsActive = true }; await _dbContext.Vendors.AddAsync(vendor); if (await _dbContext.SaveChangesAsync() > 0) { return(vendor.Id); } return(0); }
public async Task <int> AddClientAsync(NewClientDto newClient) { var client = new Client { Name = newClient.Name, City = newClient.City, CreationDate = DateTime.Now, Email = newClient.Email, Phone = newClient.Phone, Rfc = newClient.Rfc.ToUpper(), Address = newClient.Address, StateId = newClient.State.Id, IsActive = true }; await _dbContext.Clients.AddAsync(client); if (await _dbContext.SaveChangesAsync() > 0) { return(client.Id); } return(0); }
public async Task <int> AddCategoryAsync(NewCategoryDto newCategory) { var category = new Category { Name = newCategory.Name, IsActive = true }; await _dbContext.Categories.AddAsync(category); if (await _dbContext.SaveChangesAsync() > 0) { return(category.Id); } return(0); }
public async Task <int> AddProductHeaderAsync(NewProductHeaderDto newProductHeader) { var productHeader = new ProductHeader { Model = newProductHeader.Model, Description = newProductHeader.Description, ShortDescription = newProductHeader.ShortDescription, SubCategoryId = newProductHeader.SubCategory.Id, BrandId = newProductHeader.Brand.Id, IsActive = true }; var products = new List <Product>(); foreach (var productDto in newProductHeader.Products) { products.Add(new Product { Code = productDto.Code, ExtraDescription = productDto.ExtraDescription, Price = productDto.Price, SpecialPrice = productDto.SpecialPrice, CreateDate = DateTime.Now, SizeId = productDto.Size.Id, ColorPrimaryId = productDto.ColorPrimary.Id, ColorSecondaryId = productDto.ColorSecondary.Id, IsActive = true }); } productHeader.Products = products; await _dbContext.ProductHeaders.AddAsync(productHeader); if (await _dbContext.SaveChangesAsync() > 0) { return(productHeader.Id); } return(0); }
public static async void EnsureSeedDataForContext(this PosRiContext context) { if (!await context.Roles.AnyAsync()) { context.Roles.SeedEnumValues <Role, Role.RoleNames>(@enum => @enum); } if (!await context.Users.AnyAsync()) { var user = new User() { Name = "Ricardo Esqueda Guerrero", Username = "******", Birthday = new DateTime(1994, 6, 6), HireDate = DateTime.Now, Password = "******" }; await context.Users.AddAsync(user); var userRole = new UserRole { RoleId = (int)Role.RoleNames.SuperAdmin, UserId = user.Id }; user.Roles = new List <UserRole> { userRole }; } if (!await context.States.AnyAsync()) { List <State> states = new List <State> { new State { Name = "Aguascalientes", ShortName = "AGS" }, new State { Name = "Baja California", ShortName = "BC" }, new State { Name = "Baja California Sur", ShortName = "BCS" }, new State { Name = "Campeche", ShortName = "CAMP" }, new State { Name = "Chiapas", ShortName = "CHIS" }, new State { Name = "Chihuahua", ShortName = "CHIH" }, new State { Name = "Ciudad de México", ShortName = "CDMX" }, new State { Name = "Coahuila de Zaragoza", ShortName = "COAH" }, new State { Name = "Colima", ShortName = "COL" }, new State { Name = "Durango", ShortName = "DGO" }, new State { Name = "Guanajuato", ShortName = "GTO" }, new State { Name = "Guerrero", ShortName = "GRO" }, new State { Name = "Hidalgo", ShortName = "HGO" }, new State { Name = "Jalisco", ShortName = "JAL" }, new State { Name = "México", ShortName = "MEX" }, new State { Name = "Michoacán de Ocampo", ShortName = "MICH" }, new State { Name = "Morelos", ShortName = "MOR" }, new State { Name = "Nayarit", ShortName = "NAY" }, new State { Name = "Nuevo León", ShortName = "NL" }, new State { Name = "Oaxaca", ShortName = "OAX" }, new State { Name = "Puebla", ShortName = "PUE" }, new State { Name = "Querétaro de Arteaga", ShortName = "QRO" }, new State { Name = "Quintana Roo", ShortName = "QR" }, new State { Name = "San Luis Potosí", ShortName = "SLP" }, new State { Name = "Sinaloa", ShortName = "SL" }, new State { Name = "Sonora", ShortName = "SON" }, new State { Name = "Tabasco", ShortName = "TAB" }, new State { Name = "Tamaulipas", ShortName = "TAMPS" }, new State { Name = "Tlaxcala", ShortName = "TLAX" }, new State { Name = "Veracruz de Ignacio de la Llave", ShortName = "VER" }, new State { Name = "Yucatán", ShortName = "YUC" }, new State { Name = "Zacatecas", ShortName = "ZAC" } }; foreach (var state in states) { await context.States.AddAsync(state); await context.SaveChangesAsync(); } } await context.SaveChangesAsync(); }