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