public void AddUserAccount(UserSignUpView user)
{
using (DemoDBContext db = new DemoDBContext()) {
Sysuser SU = new Sysuser();
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.Sysuser.Add(SU);
db.SaveChanges();
SysuserProfile SUP = new SysuserProfile();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SysuserProfile.Add(SUP);
db.SaveChanges();
if (user.LOOKUPRoleID > 0)
{
SysuserRole SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
db.SaveChanges();
}
}
}
public void UpdateUserAccount(UserProfileView user)
{
using (DemoDBContext db = new DemoDBContext()) {
using (var dbContextTransaction = db.Database.BeginTransaction()) {
try {
Sysuser SU = db.Sysuser.Find(user.SYSUserID);
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID;
SU.RowModifiedSysuserId = user.SYSUserID;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
var userProfile = db.SysuserProfile.Where(o => o.SysuserId == user.SYSUserID);
if (userProfile.Any())
{
SysuserProfile SUP = userProfile.FirstOrDefault();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID;
SUP.RowModifiedSysuserId = user.SYSUserID;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
if (user.LOOKUPRoleID > 0)
{
var userRole = db.SysuserRole.Where(o => o.SysuserId == user.SYSUserID);
SysuserRole SUR = null;
if (userRole.Any())
{
SUR = userRole.FirstOrDefault();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
}
else
{
SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
}
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch {
dbContextTransaction.Rollback();
}
}
}
}
