public void create(MasterFormUserData userView)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
User user = new User()
{
name = userView.name,
username = userView.username,
isPC = userView.isPC,
statusId = "A",
password = DefaultPassword.value,
createUser = userView.createUser,
createDatetime = DateTime.Now,
updateDatetime = DateTime.Now,
updateUser = userView.createUser,
userRoleId = userView.userRoleId,
departmentId = userView.departmentId,
branchGroupPrvlgCondition = "A",
branchPrvlgCondition = "S"
};
user.userBranchPrvlgList = new List <UserBranchPrvlg>();
foreach (MasterFormUserEntityData userEntity in userView.userEntity)
{
UserBranchPrvlg userBranchPrvlg = new UserBranchPrvlg()
{
branchId = userEntity.branch.branchId,
username = user.username,
userRoleId = userEntity.userRole.key,
createDatetime = DateTime.Now,
createUser = userView.createUser,
};
user.userBranchPrvlgList.Add(userBranchPrvlg);
}
ctx.Users.Add(user);
ctx.SaveChanges();
scope.Complete();
}
}
}
public void UpdateUser(MasterFormUserData userView)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
ctx.UserBranchPrvlgs.RemoveRange(ctx.UserBranchPrvlgs.Where(z => z.username == userView.username));
ctx.SaveChanges();
User updateUser = ctx.Users.Where(z => z.username == userView.username).SingleOrDefault();
foreach (MasterFormUserEntityData userEntity in userView.userEntity)
{
UserBranchPrvlg userBranchPrvlg = new UserBranchPrvlg()
{
branchId = userEntity.branch.branchId,
username = userView.username,
userRoleId = userEntity.userRole.key,
createDatetime = DateTime.Now,
createUser = userView.createUser
};
ctx.UserBranchPrvlgs.Add(userBranchPrvlg);
}
updateUser.name = userView.name;
updateUser.userRoleId = userView.userRoleId;
updateUser.departmentId = userView.departmentId;
updateUser.updateDatetime = DateTime.Now;
updateUser.updateUser = userView.createUser;
updateUser.statusId = userView.statusId;
ctx.SaveChanges();
scope.Complete();
}
}
}
