public async Task <IActionResult> Edit(int id, [Bind("UserToRoleID,UserID,RoleID")] UserToRole userToRole)
{
if (id != userToRole.UserToRoleID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(userToRole);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserToRoleExists(userToRole.UserToRoleID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(userToRole));
}
private static void InertUsersAnsRoles(IUserToRoleRepository userToRoleRepository)
{
var user1 = new User("Vadim", "Abdullaev", "password", "Abdullaev@email");
//userRepository.Save(user1);
var user2 = new User("Jon", "Willson", "password", "Willson@email");
//userRepository.Save(user2);
var user3 = new User("Serge", "Ibaka", "password", "Ibaka@email");
//userRepository.Save(user3);
var roleAdmin = new Role("Admin");
//roleRepository.Save(roleAdmin);
var roleUser = new Role("User");
//roleRepository.Save(roleUser);
var user1ToAdmin = new UserToRole(user1, roleAdmin);
userToRoleRepository.Save(user1ToAdmin);
var user1ToUserRole = new UserToRole(user1, roleUser);
userToRoleRepository.Save(user1ToUserRole);
user1ToUserRole = new UserToRole(user2, roleUser);
userToRoleRepository.Save(user1ToUserRole);
user1ToUserRole = new UserToRole(user3, roleUser);
userToRoleRepository.Save(user1ToUserRole);
}
public async Task TestAddRoleToUseTrigger()
{
//SETUP
var options = SqliteInMemory.CreateOptions <ExtraAuthorizeDbContext>();
using (var context = new ExtraAuthorizeDbContext(options, new AuthChanges()))
{
context.Database.EnsureCreated();
var rolToPer = RoleToPermissions.CreateRoleWithPermissions
("test", "test", new List <Permissions> {
Permissions.AccessAll
}, context).Result;
context.Add(rolToPer);
context.SaveChanges();
//ATTEMPT
var userToRole = new UserToRole("test", rolToPer);
context.Add(userToRole);
await context.SaveChangesAsync();
//VERIFY
context.TimeStores.Count().ShouldEqual(1);
context.UserToRoles.Count().ShouldEqual(1);
}
}
public static void SeedUserWithTwoRoles(this ExtraAuthorizeDbContext context, string userId = "userId")
{
var userStatus = RoleToPermissions.CreateRoleWithPermissions(
"TestRole1", "TestRole1", new List <Permissions> {
Permissions.StockRead
}, context);
userStatus.IsValid.ShouldBeTrue(userStatus.GetAllErrors());
context.Add(userStatus.Result);
userStatus = RoleToPermissions.CreateRoleWithPermissions(
"TestRole2", "TestRole1", new List <Permissions> {
Permissions.SalesSell
}, context);
userStatus.IsValid.ShouldBeTrue(userStatus.GetAllErrors());
context.Add(userStatus.Result);
var roleStatus = UserToRole.AddRoleToUser(userId, "TestRole1", context);
roleStatus.IsValid.ShouldBeTrue(userStatus.GetAllErrors());
context.Add(roleStatus.Result);
roleStatus = UserToRole.AddRoleToUser(userId, "TestRole2", context);
roleStatus.IsValid.ShouldBeTrue(userStatus.GetAllErrors());
context.Add(roleStatus.Result);
context.SaveChanges();
}
/// <summary>
/// 尝试创建用户，并发送注册邮件到用户邮箱
/// </summary>
/// <param name="registerUser"></param>
/// <param name="roleType"></param>
/// <returns></returns>
private async Task <ValueTuple <bool, MoUserInfo> > TryCreateUser(MoUserInfoSimple registerUser, RoleType roleType)
{
if (registerUser == null)
{
throw new ArgumentNullException(nameof(registerUser));
}
// 因为我们要考虑到已经入库了但邮箱还未激活的用户（也就是还未完成全部注册流程的用户）可能会重复注册，所以我这里改成这样子
User user = _uf.UserRepository.GetFirstOrDefault(x => x.Email.Equals(registerUser.UserName, StringComparison.OrdinalIgnoreCase));
if (user == null)
{
using (var trans = _uf.BeginTransaction())
{
try
{
user = await _uf.UserRepository.CreateUserAsync(registerUser);
//_uf.SaveChanges();
var role = await _uf.RoleRepository.GetOrAddAsync(roleType);
//_uf.SaveChanges();
var userToRole = new UserToRole
{
UserId = user.Id,
RoleId = role.Id
};
await _uf.UserToRoleRepository.InsertAsync(userToRole);
await _uf.SaveChangesAsync();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
this.MsgBox("注册用户失败");
return(false, null);
}
}
}
var userInfo = new MoUserInfo
{
Id = user.Id,
UserStatus = (int)user.UserStatus,
Email = user.Email,
HeadPhoto = user.HeadPhoto,
UserName = user.UserName,
Roles = roleType.ToString()
};
HttpContext.AddUserInfo(userInfo);
this.MsgBox("注册用户成功，请查看您的邮箱，确认激活！");
return(true, userInfo);
}
/// <summary>
/// This ensures there is a UserToRole linking the userId to the given roleName
/// </summary>
/// <param name="userId"></param>
/// <param name="roleName"></param>
public async Task AddRoleToUserAsync(string userId, string roleName)
{
IStatusGeneric <UserToRole> status = await UserToRole.AddRoleToUserAsync(userId, roleName, _repository);
if (status.IsValid)
{
//we assume there is already a link to the role is the status wasn't valid
await _repository.AddAsync(status.Result);
}
}
/// <summary>
/// This ensures there is a UserToRole linking the userId to the given roleName
/// </summary>
/// <param name="userId"></param>
/// <param name="roleName"></param>
public void CheckAddRoleToUser(string userId, string roleName)
{
var status = UserToRole.AddRoleToUser(userId, roleName, _context);
if (status.IsValid)
{
//we assume there is already a link to the role is the status wasn't valid
_context.Add(status.Result);
}
}
/// <summary>
/// 修改用户角色对应表
/// </summary>
/// <param name="index">用户角色对应表对象</param>
/// <returns></returns>
public int Update(UserToRole index)
{
string sql = "update User_To_Role set Id=@Id,User_Id=@User_Id,Role_Id=@Role_Id where Id=@Id";
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@User_Id", index.UserId),
new SQLiteParameter("@Role_Id", index.RoleId)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
/// <summary>
/// 增加用户角色对应表
/// </summary>
/// <param name="index">用户角色对应表对象</param>
/// <returns></returns>
public int Add(UserToRole index)
{
string sql = string.Format("insert into User_To_Role(Id,User_Id,Role_Id) values(@Id,@User_Id,@Role_Id)");
SQLiteParameter[] parm = new SQLiteParameter[] {
new SQLiteParameter("@Id", index.Id),
new SQLiteParameter("@User_Id", index.UserId),
new SQLiteParameter("@Role_Id", index.RoleId)
};
return(SqlLiteHelper.ExecuteNonQuery(sql, CommandType.Text, parm));
}
public async Task <IActionResult> Create([Bind("UserToRoleID,UserID,RoleID")] UserToRole userToRole)
{
if (ModelState.IsValid)
{
_context.Add(userToRole);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(userToRole));
}
public async Task <bool> AddRole(int IdUser, int IdRole)
{
var UR = new UserToRole()
{
IsActive = true,
RoleId = IdRole,
UserId = IdUser
};
await _context.UserRoles.AddAsync(UR);
await _context.SaveChangesAsync();
return(true);
}
public async Task <IActionResult> AddRoleToUser([FromBody] UserToRole userToRole)
{
var user = await _userManager.FindByNameAsync(userToRole.User);
if (!await _userManager.IsInRoleAsync(user, userToRole.Role))
{
await _userManager.AddToRoleAsync(user, userToRole.Role);
return(Ok("Role added to User"));
}
else
{
return(Ok("User has this role already"));
}
}
public async Task <IActionResult> AssigningUserToRole([FromBody] UserToRole userToRole)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var assign = await _auth.UserToRoleAssign(userToRole);
if (!string.IsNullOrEmpty(assign))
{
return(BadRequest(assign));
}
return(Ok(userToRole));
}
public int RemoveRoleFromUser([FromBody] UserToRole usrtoRoleMap)
{
using (DataAccessLayer modelAccess = new DataAccessLayer())
{
try
{
LogHelper.WarnLog("Attempting to remove Role with ID: " + usrtoRoleMap.roleID + " from User with ID: " + usrtoRoleMap.userID);
modelAccess.DeleteUserFromRole(usrtoRoleMap.userID, usrtoRoleMap.roleID);
return(1);
}
catch (Exception ex)
{
LogHelper.ErrorLog("Error Removing Role from User: " + ex.ToString());
return(0);
}
}
}
public async Task <IActionResult> Edit(UserToRole model)
{
IdentityResult result;
if (ModelState.IsValid)
{
foreach (string userId in model.IdToAdd ?? new string[] { })
{
ApplicationUser user = await _userManager.FindByIdAsync(userId);
if (user != null)
{
result = await _userManager.AddToRoleAsync(user, model.RoleName);
if (!result.Succeeded)
{
AddErrorsFromResult(result);
}
}
}
foreach (string userId in model.IdToDelete ?? new string[] { })
{
ApplicationUser user = await _userManager.FindByIdAsync(userId);
if (user != null)
{
result = await _userManager.RemoveFromRoleAsync(user,
model.RoleName);
if (!result.Succeeded)
{
AddErrorsFromResult(result);
}
}
}
}
if (ModelState.IsValid)
{
return(RedirectToAction(nameof(Edit)));
}
else
{
return(await Edit(model.RoleId));
}
}
public int AddRoleToUser([FromBody] UserToRole usrtoRoleMap)
{
using (DataAccessLayer modelAccess = new DataAccessLayer())
{
try
{
LogHelper.WarnLog("Attempting to add Role with ID: " + usrtoRoleMap.roleID + " to user with ID: " + usrtoRoleMap.userID);
modelAccess.AddUserToRole(usrtoRoleMap.userID, usrtoRoleMap.roleID, true);
return(1);
}
catch (Exception ex)
{
LogHelper.ErrorLog("Error Attempting to add Role with ID: " + usrtoRoleMap.roleID + " to user with ID: " + usrtoRoleMap.userID + " with Error: " + ex.ToString());
return(0);
}
}
}
public async Task <string> UserToRoleAssign(UserToRole userRole)
{
var usr = await _userManager.FindByIdAsync(userRole.UserId);
if (usr is null || !await _roleManager.RoleExistsAsync(userRole.roleName))
{
return("Something went wrong");
}
//return usr is null || !await _roleManager.RoleExistsAsync(userRole.roleName) ? "Something went wrong" :
if (await _userManager.IsInRoleAsync(usr, userRole.roleName))
{
return("the user is already assigned to this role");
}
var assigning = await _userManager.AddToRoleAsync(usr, userRole.roleName);
return(assigning.Succeeded ? string.Empty : "something wrong");
}
public async Task <ActionResult> AsignRole(UserToRole model)
{
ApplicationUser User = _context.Users.Where(user => user.Email.Equals(model.UserEmail)).First();
if (User != null)
{
IdentityRole role = _context.Roles.Find(model.RoleId.ToString());
await UserManager.AddToRoleAsync(User.Id, role.Name);
if (role.Name == "Seller" || role.Name == "Administrator")
{
SubmitedProducts submitedProducts = new SubmitedProducts();
submitedProducts.UserId = User.Id;
submitedProducts.Products = new System.Collections.Generic.List <ShoppingItem>();
_context.SubmitedProducts.Add(submitedProducts);
_context.Entry(submitedProducts).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
}
return(RedirectToAction("Index", "Home"));
}
/// <summary>
/// 根据编号查询用户角色对应表
/// </summary>
/// <param name="Id">编号</param>
/// <returns>数据集合</returns>
public UserToRole Select(string Id)
{
String sql = "select * from UserToRole where Id=@Id";
System.Data.SQLite.SQLiteParameter[] parm = new System.Data.SQLite.SQLiteParameter[] {
new SQLiteParameter("@Id", Id),
};
DataTable dt = SqlLiteHelper.GetTable(sql, CommandType.Text, parm);
if (dt.Rows.Count > 0)
{
UserToRole index = new UserToRole();
index.Id = dt.Rows[0]["Id"].GetString();
index.UserId = dt.Rows[0]["User_Id"].GetString();
index.RoleId = dt.Rows[0]["Role_Id"].GetString();
return(index);
}
else
{
return(null);
}
}
/// <summary>
/// 分页查询用户角色对应表
/// </summary>
/// <param name="pageSize">每页多少条数据</param>
/// <param name="start">排除多少条数据</param>
/// <param name="hash">筛选条件</param>
/// <param name="total">总共多少条</param>
/// <returns>数据集合</returns>
public List <UserToRole> Select(int pageSize, int start, HashTableExp hash, out int total, String sqlWhere)
{
List <UserToRole> list = new List <UserToRole>();
sqlWhere = "1=1 " + sqlWhere;
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sqlWhere += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["UserId"] != null)
{
sqlWhere += string.Format(" and User_Id='{0}'", hash["UserId"]);
}
if (hash["RoleId"] != null)
{
sqlWhere += string.Format(" and Role_Id='{0}'", hash["RoleId"]);
}
}
#endregion
DataTable dt = SqlLiteHelper.GetTable("User_To_Role",
"Id,User_Id,Role_Id",
pageSize, start, sqlWhere, "Id", "asc", out total);
for (int i = 0; i < dt.Rows.Count; i++)
{
UserToRole index = new UserToRole();
index.Id = dt.Rows[i]["Id"].GetString();
index.UserId = dt.Rows[i]["User_Id"].GetString();
index.RoleId = dt.Rows[i]["Role_Id"].GetString();
list.Add(index);
}
return(list);
}
public static void SeedUserWithDefaultPermissions(this ExtraAuthorizeDbContext context,
PaidForModules modules = PaidForModules.None, string userId = "userId")
{
var defaultPermissions = new List <Permissions> {
Permissions.StockRead, Permissions.Feature1Access
};
var roleStatus = RoleToPermissions.CreateRoleWithPermissions(
"TestRole1", "TestRole1", defaultPermissions, context);
roleStatus.IsValid.ShouldBeTrue(roleStatus.GetAllErrors());
context.Add(roleStatus.Result);
var moduleUser = new ModulesForUser(userId, modules);
context.Add(moduleUser);
var userStatus = UserToRole.AddRoleToUser(userId, "TestRole1", context);
userStatus.IsValid.ShouldBeTrue(roleStatus.GetAllErrors());
context.Add(userStatus.Result);
context.SaveChanges();
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <returns></returns>
public List <UserToRole> Select(HashTableExp hash, String sqlWhere)
{
List <UserToRole> list = new List <UserToRole>();
string sql = "select Id,User_Id,Role_Id from User_To_Role where 1=1 ";
#region 查询条件
if (hash != null)
{
if (hash["Id"] != null)
{
sql += string.Format(" and Id='{0}'", hash["Id"]);
}
if (hash["UserId"] != null)
{
sql += string.Format(" and User_Id='{0}'", hash["UserId"]);
}
if (hash["RoleId"] != null)
{
sql += string.Format(" and Role_Id='{0}'", hash["RoleId"]);
}
}
#endregion
sql += sqlWhere;
DataTable dt = SqlLiteHelper.GetTable(sql, CommandType.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
UserToRole index = new UserToRole();
index.Id = dt.Rows[i]["Id"].GetString();
index.UserId = dt.Rows[i]["User_Id"].GetString();
index.RoleId = dt.Rows[i]["Role_Id"].GetString();
list.Add(index);
}
return(list);
}
/// <summary>
/// 新增
/// </summary>
/// <returns>影响的行数</returns>
public int Add(UserToRole userToRole)
{
return(dLUserToRole.Add(userToRole));
}
public static async Task InitializeAsync(IServiceProvider services)
{
var databaseDbContext = services.GetRequiredService <StoreOrderDbContext>();
var logger = services.GetRequiredService <ILogger <StoreOrderDbContext> >();
// migration db
databaseDbContext.Database.EnsureCreated();
if (!databaseDbContext.Roles.Any())
{
string password = "******";
var hashPass = Helpers.SercurityHelper.GenerateSaltedHash(password);
//// I will add 1 user to one Role
//var book1 = new Book();
//var book2 = new Book();
var roleAdmin = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleAdmin, Desc = "Admin of Store"
};
var roleOrderUser = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleOrderUser, Desc = "NV Order of Store"
};
var roleCookieUser = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleCookieUser, Desc = "NV phụ bếp of Store"
};
var rolePayUser = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RolePayUser, Desc = "Nv Thanh toán of Store"
};
var roleCustomerUser = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleCustomerUser, Desc = "Role Account of Customer"
};
//// I create the User
//var lib = new Library();
var user1 = new User {
Id = Guid.NewGuid().ToString(), Age = 29, BirthDay = new DateTime(1991, 1, 1).ToUniversalTime(), CountLoginFailed = 0, FirstName = "admin", LastName = "admin", IsActived = 1, Email = "*****@*****.**", UserName = "******", HashPassword = hashPass.Hash, SaltPassword = hashPass.Salt, Gender = 1, OldPassword = hashPass.Hash + ";" + hashPass.Salt, PhoneNumber = "1234567"
};
var nv1 = new User {
Id = Guid.NewGuid().ToString(), Age = 29, BirthDay = new DateTime(1991, 1, 1).ToUniversalTime(), CountLoginFailed = 0, FirstName = "nv1", LastName = "nv1", IsActived = 1, Email = "*****@*****.**", UserName = "******", HashPassword = hashPass.Hash, SaltPassword = hashPass.Salt, Gender = 1, OldPassword = hashPass.Hash + ";" + hashPass.Salt, PhoneNumber = "1234567"
};
var nv2 = new User {
Id = Guid.NewGuid().ToString(), Age = 29, BirthDay = new DateTime(1991, 1, 1).ToUniversalTime(), CountLoginFailed = 0, FirstName = "nv2", LastName = "nv2", IsActived = 1, Email = "*****@*****.**", UserName = "******", HashPassword = hashPass.Hash, SaltPassword = hashPass.Salt, Gender = 1, OldPassword = hashPass.Hash + ";" + hashPass.Salt, PhoneNumber = "1234567"
};
var nv3 = new User {
Id = Guid.NewGuid().ToString(), Age = 29, BirthDay = new DateTime(1991, 1, 1).ToUniversalTime(), CountLoginFailed = 0, FirstName = "nv3", LastName = "nv3", IsActived = 1, Email = "*****@*****.**", UserName = "******", HashPassword = hashPass.Hash, SaltPassword = hashPass.Salt, Gender = 1, OldPassword = hashPass.Hash + ";" + hashPass.Salt, PhoneNumber = "1234567"
};
//// I create two UserToRole which I need them
//// To map between the users and the role
//var b2lib1 = new Library2Book();
//var b2lib2 = new Library2Book();
var userToRole1 = new UserToRole();
var userToRole2 = new UserToRole();
var userToRole3 = new UserToRole();
var userToRole4 = new UserToRole();
//// Mapping the first book to the library.
//// Changed userToRole1.Role to userToRole2.Role
//// Changed b2lib2.Library to b2lib1.Library
//b2lib1.Book = book1;
//b2lib1.Library = lib;
userToRole1.Role = roleAdmin;
userToRole1.User = user1;
//// I map the second book to the library.
//b2lib2.Book = book2;
//b2lib2.Library = lib;
userToRole2.Role = roleOrderUser;
userToRole2.User = nv1;
userToRole3.Role = roleCookieUser;
userToRole3.User = nv2;
userToRole4.Role = rolePayUser;
userToRole4.User = nv3;
//// Linking the books (Library2Book table) to the library
//lib.Library2Books.Add(b2lib1);
//lib.Library2Books.Add(b2lib2);
roleAdmin.UserToRoles.Add(userToRole1);
roleOrderUser.UserToRoles.Add(userToRole2);
roleCookieUser.UserToRoles.Add(userToRole3);
rolePayUser.UserToRoles.Add(userToRole4);
//// Adding the data to the DbContext.
//myDb.Libraries.Add(lib);
databaseDbContext.Roles.Add(roleAdmin);
databaseDbContext.Users.Add(user1);
databaseDbContext.SaveChanges();
databaseDbContext.Roles.Add(roleOrderUser);
databaseDbContext.Users.Add(nv1);
databaseDbContext.SaveChanges();
databaseDbContext.Roles.Add(roleCookieUser);
databaseDbContext.Users.Add(nv2);
databaseDbContext.SaveChanges();
databaseDbContext.Roles.Add(rolePayUser);
databaseDbContext.Users.Add(nv3);
databaseDbContext.SaveChanges();
//myDb.Books.Add(book1);
//myDb.Books.Add(book2);
//// Save the changes and everything should be working!
//myDb.SaveChanges();
//await databaseDbContext.SaveChangesAsync();
logger.LogInformation("DatabaseDbContext", "---initial data of Surveys success---");
}
if (databaseDbContext.Roles.Count() == 4)
{
var roleCustomerUser = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleCustomerUser, Desc = "Role Account of Customer"
};
await databaseDbContext.Roles.AddAsync(roleCustomerUser);
await databaseDbContext.SaveChangesAsync();
}
if (databaseDbContext.Roles.Count() == 5)
{
var roleSysAdmin = new Role {
Id = Guid.NewGuid().ToString(), Code = Guid.NewGuid().ToString(), RoleName = RoleTypeHelper.RoleSysAdmin, Desc = "Role SysAdmin"
};
await databaseDbContext.Roles.AddAsync(roleSysAdmin);
await databaseDbContext.SaveChangesAsync();
}
if (!databaseDbContext.CategoryStores.Any())
{
var catStore = new CategoryStore {
Id = Guid.NewGuid().ToString(), Name = "Nhà hàng"
};
await databaseDbContext.CategoryStores.AddAsync(catStore);
await databaseDbContext.SaveChangesAsync();
var useradmin = databaseDbContext.Users.FirstOrDefault(x => x.UserName.ToLower().Equals("admin01"));
var store1 = new Store();
var optionSize = new StoreOption();
var optionToping = new StoreOption();
if (useradmin != null)
{
if (!databaseDbContext.Stores.Any())
{
store1 = new Store
{
Id = Guid.NewGuid().ToString(),
CategoryStoreId = catStore.Id,
StatusStore = 1,
StoreAddress = "Số 1, Xuân thủy, Cầu Giấy, Việt Nam",
StoreName = "Store 1",
CreateByUserId = useradmin.Id,
};
var lstStoreTable = new List <StoreTable>()
{
new StoreTable
{
Id = Guid.NewGuid().ToString(),
Location = 1,
LocationUnit = 1,
StoreId = store1.Id,
TableCode = Guid.NewGuid().ToString(),
TableName = "Bàn 1",
TableStatus = 1
},
new StoreTable
{
Id = Guid.NewGuid().ToString(),
Location = 1,
LocationUnit = 1,
StoreId = store1.Id,
TableCode = Guid.NewGuid().ToString(),
TableName = "Bàn 2",
TableStatus = 1
},
new StoreTable
{
Id = Guid.NewGuid().ToString(),
Location = 1,
LocationUnit = 1,
StoreId = store1.Id,
TableCode = Guid.NewGuid().ToString(),
TableName = "Bàn 3",
TableStatus = 1
},
new StoreTable
{
Id = Guid.NewGuid().ToString(),
Location = 1,
LocationUnit = 1,
StoreId = store1.Id,
TableCode = Guid.NewGuid().ToString(),
TableName = "Bàn 4",
TableStatus = 1
},
new StoreTable
{
Id = Guid.NewGuid().ToString(),
Location = 1,
LocationUnit = 1,
StoreId = store1.Id,
TableCode = Guid.NewGuid().ToString(),
TableName = "Bàn 5",
TableStatus = 1
}
};
optionSize = new StoreOption {
OptionId = Guid.NewGuid().ToString(), StoreId = store1.Id, StoreOptionName = "size", StoreOptionDescription = "Kích thước"
};
optionToping = new StoreOption {
OptionId = Guid.NewGuid().ToString(), StoreId = store1.Id, StoreOptionName = "toping", StoreOptionDescription = "Toping"
};
var lstStoreOption = new List <StoreOption>()
{
optionSize,
optionToping,
new StoreOption {
OptionId = Guid.NewGuid().ToString(), StoreId = store1.Id, StoreOptionName = "color", StoreOptionDescription = "Màu sắc"
},
new StoreOption {
OptionId = Guid.NewGuid().ToString(), StoreId = store1.Id, StoreOptionName = "class", StoreOptionDescription = "Lớp"
},
new StoreOption {
OptionId = Guid.NewGuid().ToString(), StoreId = store1.Id, StoreOptionName = "devo", StoreOptionDescription = "Dễ vỡ"
},
};
store1.StoreTables = lstStoreTable;
store1.StoreOptions = lstStoreOption;
await databaseDbContext.Stores.AddAsync(store1);
await databaseDbContext.SaveChangesAsync();
}
if (!databaseDbContext.CategoryProducts.Any())
{
var catProduct = new CategoryProduct
{
Id = Guid.NewGuid().ToString(),
CategoryName = "Danh mục 1",
Slug = "danh-muc-1",
Code = "danhmuc1code",
ParentId = null,
};
var lstProducts = new List <Product>()
{
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 1", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 02", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 03", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 04", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 05", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 06", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 07", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 08", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 09", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 10", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 11", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 12", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 13", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
new Product {
Id = Guid.NewGuid().ToString(), CategoryId = catProduct.Id, ProductName = "Sản phẩm 14", CreateByUserId = useradmin.Id, StoreId = store1.Id
},
};
catProduct.Products = lstProducts;
await databaseDbContext.AddAsync(catProduct);
await databaseDbContext.SaveChangesAsync();
}
}
}
if (!databaseDbContext.Permissions.Any())
{
await databaseDbContext.Permissions.AddRangeAsync(new List <Permission>() {
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.SysAdmin.ImportLocation
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.SysAdmin.ViewLogs
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.SysAdmin.DeleteLogs
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Account.Create
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Account.Delete
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Account.Edit
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Account.View
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Users.View
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Users.Create
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Users.Edit
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Users.Delete
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.SysAdmin.GetListCategoryStore
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.GetListStoreOption
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.GetMenuProduct
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.CreateProduct
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.DeleteProduct
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.UpdateProduct
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.AdminStore.GetListProduct
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.ConfirmOrder
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.ConfirmPayOrder
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.CreateOrder
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetCategoryProductsForEmployee
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListOrderWithTableOrProductName
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListProductsOfStoreForEmployee
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListProductsOfStoreForEmployeeV2
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListProductsOfStoreWithCategoryForEmployee
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListProductsOfStoreWithCategoryForEmployeeV2
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetListTables
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetOrderProductsWithTable
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.GetOrderWithTableViewProductsWithTableId
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Employee.UpdateOrder
},
new Permission {
Id = Guid.NewGuid().ToString(), PermissionName = Permissions.Upload.UploadFile
},
});
await databaseDbContext.SaveChangesAsync();
}
if (!databaseDbContext.RoleToPermissions.Any())
{
// get role
var roleSysadmin = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RoleSysAdmin);
var roleAdminStore = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RoleAdmin);
var roleOrderUser = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RoleOrderUser);
var roleCookieUser = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RoleCookieUser);
var rolePayUser = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RolePayUser);
#region update roleSysAdmin
var permissionsSysAdmin = databaseDbContext.Permissions
.Where(x => x.PermissionName == Permissions.SysAdmin.ImportLocation ||
x.PermissionName == Permissions.SysAdmin.ViewLogs ||
x.PermissionName == Permissions.SysAdmin.DeleteLogs ||
x.PermissionName == Permissions.Account.Create ||
x.PermissionName == Permissions.Account.Delete ||
x.PermissionName == Permissions.Account.Edit ||
x.PermissionName == Permissions.Account.View ||
x.PermissionName == Permissions.SysAdmin.GetListStores ||
x.PermissionName == Permissions.SysAdmin.GetListCategoryStore
).Select(x => x).ToList();
foreach (var permission in permissionsSysAdmin)
{
// add Permissions To Role
roleSysadmin.RoleToPermissions.Add(new RoleToPermission
{
Permission = permission,
Role = roleSysadmin,
});
}
// save to db
await databaseDbContext.SaveChangesAsync();
#endregion
#region Update RoleAdminStore
var permissionsAdminStore = databaseDbContext.Permissions
.Where(x => x.PermissionName == Permissions.AdminStore.GetMenuProduct ||
x.PermissionName == Permissions.AdminStore.GetListStoreOption ||
x.PermissionName == Permissions.AdminStore.GetListProduct ||
x.PermissionName == Permissions.AdminStore.CreateProduct ||
x.PermissionName == Permissions.AdminStore.UpdateProduct ||
x.PermissionName == Permissions.AdminStore.DeleteProduct ||
x.PermissionName == Permissions.Upload.UploadFile ||
x.PermissionName == Permissions.AdminStore.CreateCatProduct ||
x.PermissionName == Permissions.AdminStore.UpdateCatProduct ||
x.PermissionName == Permissions.AdminStore.DeleteCatProduct ||
x.PermissionName == Permissions.AdminStore.GetListCatProduct
).Select(x => x).ToList();
foreach (var permission in permissionsAdminStore)
{
// add Permissions To Role
roleAdminStore.RoleToPermissions.Add(new RoleToPermission
{
Permission = permission,
Role = roleAdminStore,
});
}
// save to db
await databaseDbContext.SaveChangesAsync();
#endregion
#region Update RoleOrderUser
var permissionsOrderUsers = databaseDbContext.Permissions
.Where(x => x.PermissionName == Permissions.Employee.GetListTables ||
x.PermissionName == Permissions.Employee.GetCategoryProductsForEmployee ||
x.PermissionName == Permissions.Employee.GetListProductsOfStoreForEmployee ||
x.PermissionName == Permissions.Employee.GetListProductsOfStoreWithCategoryForEmployee ||
x.PermissionName == Permissions.Employee.GetListProductsOfStoreForEmployeeV2 ||
x.PermissionName == Permissions.Employee.GetListProductsOfStoreWithCategoryForEmployeeV2 ||
x.PermissionName == Permissions.Employee.CreateOrder ||
x.PermissionName == Permissions.Employee.UpdateOrder ||
x.PermissionName == Permissions.Employee.GetOrderProductsWithTable
).Select(x => x).ToList();
foreach (var permission in permissionsOrderUsers)
{
// add Permissions To Role
roleOrderUser.RoleToPermissions.Add(new RoleToPermission
{
Permission = permission,
Role = roleOrderUser,
});
}
// save to db
await databaseDbContext.SaveChangesAsync();
#endregion
#region Update RoleCookieUser
var permissionsOrderCookies = databaseDbContext.Permissions
.Where(x => x.PermissionName == Permissions.Employee.GetOrderProductsWithTable ||
x.PermissionName == Permissions.Employee.GetListOrderWithTableOrProductName ||
x.PermissionName == Permissions.Employee.GetOrderWithTableViewProductsWithTableId ||
x.PermissionName == Permissions.Employee.ConfirmOrder ||
x.PermissionName == Permissions.Employee.UpdateOrderProductStatus
).Select(x => x).ToList();
foreach (var permission in permissionsOrderCookies)
{
// add Permissions To Role
roleCookieUser.RoleToPermissions.Add(new RoleToPermission
{
Permission = permission,
Role = roleCookieUser,
});
}
// save to db
await databaseDbContext.SaveChangesAsync();
#endregion
#region Update rolePayUser
var permissionsPayUsers = databaseDbContext.Permissions
.Where(x => x.PermissionName == Permissions.Employee.ConfirmOrder ||
x.PermissionName == Permissions.Employee.ConfirmPayOrder
).Select(x => x).ToList();
foreach (var permission in permissionsPayUsers)
{
// add Permissions To Role
rolePayUser.RoleToPermissions.Add(new RoleToPermission
{
Permission = permission,
Role = rolePayUser,
});
}
// save to db
await databaseDbContext.SaveChangesAsync();
#endregion
}
if (!databaseDbContext.Users.Include(x => x.UserToRoles).ThenInclude(x => x.Role).Any(x => x.UserToRoles.Any(r => r.Role.RoleName == RoleTypeHelper.RoleSysAdmin)))
{
var roleSysAdmin = await databaseDbContext.Roles.FirstOrDefaultAsync(x => x.RoleName == RoleTypeHelper.RoleSysAdmin);
string password = "******";
var hashPass = Helpers.SercurityHelper.GenerateSaltedHash(password);
var userSysAdmin = new User {
Id = Guid.NewGuid().ToString(), Age = 29, BirthDay = new DateTime(1991, 1, 1).ToUniversalTime(), CountLoginFailed = 0, FirstName = "sysadmin", LastName = "sysadmin", IsActived = 1, Email = "*****@*****.**", UserName = "******", HashPassword = hashPass.Hash, SaltPassword = hashPass.Salt, Gender = 1, OldPassword = hashPass.Hash + ";" + hashPass.Salt, PhoneNumber = "0349801673"
};
roleSysAdmin.UserToRoles.Add(new UserToRole
{
Role = roleSysAdmin,
User = userSysAdmin,
});
// save to db
await databaseDbContext.SaveChangesAsync();
}
}
/// <summary>
/// 修改
/// </summary>
/// <returns>影响的行数</returns>
public int Update(UserToRole userToRole)
{
return(dLUserToRole.Update(userToRole));
}
public async Task <IActionResult> AddToRole([FromBody] UserToRole userToRole)
{
return(Ok(await _identityService.AddToRole(userToRole.Username, userToRole.roles)));
}
public async Task <IActionResult> RemoveToRole(UserToRole userToRole)
{
return(Ok(await _identityService.RemoveToRole(userToRole.Username, userToRole.roles)));
}
public async Task <UserLogined> SignInAndSignUpCustomerAsync(CustomerLoginDTO model)
{
// GET roleCustomerUser
var roleCustomerUser = await _context.Roles.FirstOrDefaultAsync(role => role.RoleName.Equals(RoleTypeHelper.RoleCustomerUser));
User userCreate = new User();
// CheckUserExist
var userExist = await _context.Users
.Include(u => u.UserToRoles)
.ThenInclude(x => x.Role)
.Where(u => u.UserToRoles.Any(x => x.RoleId == roleCustomerUser.Id))
.FirstOrDefaultAsync(u => u.Email.ToLower().Equals(model.Email.ToLower()) &&
u.UseExternalSignIns.Count > 0 && u.UserDevices.Count > 0);
// case login lần sau:
if (userExist != null)
{
// if exist then update user
// update To UserDevices
// update To UserExternalSignIns
userCreate = userExist;
_context.Entry(userCreate).State = EntityState.Modified;
userCreate.LastLogin = DateTime.UtcNow;
// check appId & currentUserId Exist
if (!_context.UserDevices.Any(uc => uc.CurrentUserId == userCreate.Id && uc.CodeDevice == model.AppId))
{
// Add to UserDevices
var userDevice = new UserDevice
{
Id = Guid.NewGuid().ToString(),
IsVerified = (int)TypeVerified.Verified,
VerifiedCode = (int)(DateTime.Now.Ticks >> 23),
CodeDevice = model.AppId,
CurrentUserId = userCreate.Id,
LastLogin = DateTime.UtcNow,
TimeCode = 20
};
userCreate.UserDevices.Add(userDevice);
}
else
{
// Update to UserDevices
var userDevice = _context.UserDevices.FirstOrDefault(uc => uc.CurrentUserId == userExist.Id && uc.CodeDevice == model.AppId);
if (userDevice != null)
{
_context.Entry(userDevice).State = EntityState.Modified;
userDevice.LastLogin = DateTime.UtcNow;
// save tp db
await _context.SaveChangesAsync();
}
}
// check exist UseExternalSignIns
if (!_context.ExternalSignIns.Any(ue => ue.UserId == userCreate.Id && ue.TypeLogin == model.TypeLogin))
{
var newUSERExternalSignIn = new ExternalSignIn
{
Id = Guid.NewGuid().ToString(),
IsVerified = (int)TypeVerified.Verified,
LastLogin = DateTime.UtcNow,
TimeLifeToken = 3600,
TokenLogin = model.TokenLogin,
TypeLogin = model.TypeLogin,
UserId = userExist.Id
};
userCreate.UseExternalSignIns.Add(newUSERExternalSignIn);
}
else
{
// update To UserExternalSignIns
var userExternalSignIn = _context.ExternalSignIns.FirstOrDefault(ue => ue.UserId == userExist.Id && ue.TypeLogin == model.TypeLogin);
if (userExternalSignIn != null)
{
_context.Entry(userExternalSignIn).State = EntityState.Modified;
userExternalSignIn.LastLogin = DateTime.UtcNow;
// save tp db
await _context.SaveChangesAsync();
}
}
// save to db
await _context.SaveChangesAsync();
}
else
{
// if not exist then create user
userCreate.Id = Guid.NewGuid().ToString();
userCreate.FirstName = model.FirstName;
userCreate.LastLogin = DateTime.UtcNow;
userCreate.LastName = model.LastName;
userCreate.Email = model.Email;
userCreate.UserName = model.Email;
userCreate.PhoneNumber = model.PhoneNumber;
var userDevice = new UserDevice
{
Id = Guid.NewGuid().ToString(),
CodeDevice = model.AppId,
CurrentUserId = userCreate.Id,
IsVerified = (int)TypeVerified.Verified,
LastLogin = DateTime.UtcNow,
TimeCode = 20,
VerifiedCode = (int)(DateTime.Now.Ticks >> 23)
};
// Save to UserDevices
userCreate.UserDevices.Add(userDevice);
var externalSign = new ExternalSignIn
{
Id = Guid.NewGuid().ToString(),
IsVerified = (int)TypeVerified.Verified,
LastLogin = DateTime.UtcNow,
TimeLifeToken = 3600,
TokenLogin = model.TokenLogin,
TypeLogin = model.TypeLogin,
UserId = userCreate.Id
};
// Save to ExternalSignIns
userCreate.UseExternalSignIns.Add(externalSign);
// Save to UserToRole
var userToRole = new UserToRole();
userToRole.Role = roleCustomerUser;
userToRole.User = userCreate;
roleCustomerUser.UserToRoles.Add(userToRole);
_context.Users.Add(userCreate);
// Save All To Database
await _context.SaveChangesAsync();
}
// create token
string currentUserId = Guid.NewGuid().ToString();
var userLogined = CreateToken(userCreate, currentUserId);
// save to login
await SaveToUserLoginAsync(userCreate, userLogined, currentUserId);
// save to login
// return
return(userLogined);
}
public async Task <IActionResult> RegistrationUser([FromBody] RegistrationUserDTO model, string storeId)
{
_logger.Log(LogLevel.Information, "call registration/{@storeId}", storeId);
await CheckIsSignoutedAsync();
string messager = string.Empty;
if (ModelState.IsValid)
{
// check store exist and open
Store store = await _context.Stores.FindAsync(storeId);
if (store == null)
{
messager = "Không tìm thấy cửa hàng hoặc cửa hàng đã đóng.";
_logger.Log(LogLevel.Information, messager);
throw new ApiException(messager, (int)HttpStatusCode.BadRequest);
}
// get role
Role role = await _context.Roles.FindAsync(storeId);
if (role == null)
{
messager = "Không tìm thấy role.";
_logger.Log(LogLevel.Information, messager);
throw new ApiException(messager, (int)HttpStatusCode.BadRequest);
}
// init user
var hashPass = Helpers.SercurityHelper.GenerateSaltedHash(model.Password);
User user = new User
{
Id = Guid.NewGuid().ToString(),
Age = model.Age,
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
UserName = model.Username,
StoreId = store.Id,
Gender = model.Gender,
IsActived = (int)TypeVerified.Verified,
HashPassword = hashPass.Hash,
SaltPassword = hashPass.Salt
};
// Add user to Role
UserToRole userToRole = new UserToRole();
userToRole.Role = role;
userToRole.User = user;
role.UserToRoles.Add(userToRole);
// save user create to database
try
{
_context.Roles.Add(role);
_context.Users.Add(user);
await _context.SaveChangesAsync();
messager = $"Đã khởi tạo nhân viên {role.Desc}: {user.FirstName} {user.LastName} cho cửa hàng của bạn.";
}
catch (Exception ex)
{
_logger.Log(LogLevel.Warning, $"Log when RegistrationUser {ex.Message}");
#if !DEBUG
throw new ApiException($"Có lỗi xảy ra khi đăng ký {user.FirstName}", (int)HttpStatusCode.BadRequest);
#else
throw new ApiException(ex, (int)HttpStatusCode.BadRequest);
#endif
}
}
_logger.Log(LogLevel.Information, messager);
return(Ok(new { data = messager }));
}
public static void Initialize(MonitoringSystemContext context)
{
if (!context.Database.EnsureCreated())
{
context.Database.Migrate();
}
// Look for any BasicParameters.
if (context.BasicParameters.Any())
{
return; // DB has been seeded
}
var basicParameters = new BasicParameter[]
{
new BasicParameter {
SPNNameRu = "Время включения системы подачи газа", DataSource = "Отсутствует в J1339! (но есть Engine Total Hours of Gaseous Fuel Operation"
},
new BasicParameter {
Acronym = "GFC", SPNName = "Trip Gaseous", SPNNameRu = "Расход газа", DataSource = "CAN-шина, при наличии расходомера газа. Иначе-вычисляется через давление и проходное сечение форсунки впрыска газа"
},
new BasicParameter {
Acronym = "GP", SPNName = "Gas Pressure", SPNNameRu = "Давление газа", DataSource = "Внешний датчик давления"
},
new BasicParameter {
Acronym = "GFC", SPNName = "Trip Fuel", SPNNameRu = "Расход дизельного топлива", DataSource = "CAN шина, или датчик расхода"
},
new BasicParameter {
Acronym = "VD", SPNName = "Total Vehicle Distance", SPNNameRu = "Пробег автомобиля (пройденный путь)", DataSource = "CAN -шина"
},
new BasicParameter {
Acronym = "WBVS", SPNName = "Wheel-Based Vehicle Speed", SPNNameRu = "Скорость движения", DataSource = "CAN -шина"
},
new BasicParameter {
Acronym = "EEC1", SPNName = "Engine Speed", SPNNameRu = "Обороты двигателя", DataSource = "CAN -шина"
},
new BasicParameter {
Acronym = "ECT", SPNName = "Engine Coolant Temperature", SPNNameRu = "Температура двигателя", DataSource = "CAN -шина"
},
new BasicParameter {
Acronym = "TE", SPNName = "Exhaust Temperature", SPNNameRu = "Температура выхлопных газов", DataSource = "Дополнительный датчик на выхлопной трубе"
},
};
foreach (BasicParameter bp in basicParameters)
{
context.BasicParameters.Add(bp);
}
context.SaveChanges();
/*if (context.Vehicles.Any())
* {
* return; // DB has been seeded
* }*/
var vehicles = new Vehicle[]
{
new Vehicle {
Mark = "BMW", ModelType = "E540", СarryingСapacity = 2000, YearIssue = 1998, UsefulVolume = 430, VehicleType = "ГР", OverallDimensions = "20x30x40"
},
new Vehicle {
Mark = "Mersedes", ModelType = "S230", СarryingСapacity = 4000, YearIssue = 1996, UsefulVolume = 930, VehicleType = "ГР", OverallDimensions = "50x70x60"
},
};
foreach (Vehicle vh in vehicles)
{
context.Vehicles.Add(vh);
}
context.SaveChanges();
// Table
var vehiclegroups = new VehicleGroup[]
{
new VehicleGroup {
VehicleGroupName = "TestVehicleGroup1"
},
new VehicleGroup {
VehicleGroupName = "TestVehicleGroup2"
},
new VehicleGroup {
VehicleGroupName = "TestVehicleGroup3"
},
};
foreach (VehicleGroup vhg in vehiclegroups)
{
context.VehicleGroups.Add(vhg);
}
context.SaveChanges();
// Table
var vehicletovehiclegroups = new VehicleToVehicleGroup[]
{
new VehicleToVehicleGroup {
VehicleGroupID = 2, VehicleID = 1
},
new VehicleToVehicleGroup {
VehicleGroupID = 2, VehicleID = 2
},
new VehicleToVehicleGroup {
VehicleGroupID = 3, VehicleID = 1
},
};
foreach (VehicleToVehicleGroup vvg in vehicletovehiclegroups)
{
context.VehicleToVehicleGroups.Add(vvg);
}
context.SaveChanges();
// Table
var parameters = new Parameter[]
{
new Parameter {
VehicleID = 1, BasicParameterID = 2, BasicParameterValue = 112, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 3, BasicParameterValue = 113, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 4, BasicParameterValue = 114, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 5, BasicParameterValue = 115, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 6, BasicParameterValue = 116, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 7, BasicParameterValue = 117, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 8, BasicParameterValue = 118, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 9, BasicParameterValue = 119, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 54)
},
new Parameter {
VehicleID = 1, BasicParameterID = 2, BasicParameterValue = 122, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 3, BasicParameterValue = 123, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 4, BasicParameterValue = 124, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 5, BasicParameterValue = 125, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 6, BasicParameterValue = 126, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 7, BasicParameterValue = 127, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 8, BasicParameterValue = 128, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
new Parameter {
VehicleID = 1, BasicParameterID = 9, BasicParameterValue = 129, BasicParameterTimeValue = new DateTime(2004, 10, 19, 10, 23, 56)
},
};
foreach (Parameter p in parameters)
{
context.Parameters.Add(p);
}
context.SaveChanges();
// Table
var routes = new Route[]
{
new Route {
VehicleID = 1, CoordinateLatitude = 60.001, CoordinateLongitude = 30.001
},
new Route {
VehicleID = 1, CoordinateLatitude = 60.002, CoordinateLongitude = 30.002
},
new Route {
VehicleID = 1, CoordinateLatitude = 60.003, CoordinateLongitude = 30.003
},
new Route {
VehicleID = 1, CoordinateLatitude = 60.004, CoordinateLongitude = 30.004
},
new Route {
VehicleID = 1, CoordinateLatitude = 60.005, CoordinateLongitude = 30.005
},
new Route {
VehicleID = 2, CoordinateLatitude = 60.101, CoordinateLongitude = 30.101
},
};
foreach (Route r in routes)
{
context.Routes.Add(r);
}
context.SaveChanges();
// Table
var users = new User[]
{
new User {
UserLogin = "******", UserPassword = "******", UserName = "******", UserSurname = "Шайтан", UserPhone = "7911", UserRole = 1
},
new User {
UserLogin = "******", UserPassword = "******", UserName = "******", UserSurname = "Иванов", UserPhone = "7921", UserRole = 2
},
};
foreach (User u in users)
{
context.Users.Add(u);
}
context.SaveChanges();
// Table
var roles = new Role[]
{
new Role {
RoleName = "ADMIN"
},
new Role {
RoleName = "USER"
},
};
foreach (Role r in roles)
{
context.Roles.Add(r);
}
context.SaveChanges();
// Table
var usertoroles = new UserToRole[]
{
new UserToRole {
UserID = 1, RoleID = 1
},
new UserToRole {
UserID = 2, RoleID = 2
},
};
foreach (UserToRole ur in usertoroles)
{
context.UserToRoles.Add(ur);
}
context.SaveChanges();
}
