public bool IsLoginNameExist(string loginName)
{
using (DemoDBEntities db = new DemoDBEntities())
{
return db.SYSUsers.Where(o => o.LoginName.Equals(loginName)).Any();
//return db.SYSUsers.Any(o => o.LoginName.Equals(loginName));
}
}
public void AddUserAccount(UserSignUpView user)
{
using (DemoDBEntities db = new DemoDBEntities())
{
SYSUser SU = new SYSUser()
{
LoginName = user.LoginName,
PasswordEncryptedText = user.Password,
RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowCreatedDateTime = DateTime.Now,
RowMOdifiedDateTime = DateTime.Now
};
db.SYSUsers.Add(SU);
db.SaveChanges();
SYSUserProfile SUP = new SYSUserProfile()
{
SYSUserID = SU.SYSUserID,
FirstName = user.FirstName,
LastName = user.LastName,
Gender = user.Gender,
RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowCreatedDateTime = DateTime.Now,
RowModifiedDateTime = DateTime.Now
};
db.SYSUserProfiles.Add(SUP);
db.SaveChanges();
if (user.LOOKUPRoleID > 0)
{
SYSUserRole SUR = new SYSUserRole()
{
LOOKUPRoleID = user.LOOKUPRoleID,
SYSUserID = user.LOOKUPRoleID,
IsActive = true,
RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1,
RowCreatedDateTime = DateTime.Now,
RowModifiedDateTime = DateTime.Now
};
db.SYSUserRoles.Add(SUR);
db.SaveChanges();
}
}
}