public string ChangePassword(PreferenceModel pref)
{
uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
try
{
string encryptedNewPassword = UtilityFunction.EncryptPassword(pref.NewPasswordOne);
user.Password = encryptedNewPassword;
user.ModifiedBy = SessionHelper.LoginStatus.UserID;
user.ModifiedDate = DateTime.Now;
pref.db.Entry(user).State = System.Data.Entity.EntityState.Modified;
pref.db.SaveChanges();
}
catch (Exception ex) {
Debug.Write("Change password: "******"Change password: Error changing if force change password.");
}
}
return("success");
}
/// <summary>
/// Takes a LoginStatus and creates corresponding LoginInfo.
/// </summary>
/// <param name="loginStatus"></param>
/// <returns></returns>
private LoginInfo FillLoginInfo(LoginStatus loginStatus)
{
LoginInfo loginInfo = new LoginInfo();
using (var context = DataContext.getUasDbContext())
{
uas_User result = null;
try
{
result = context.uas_User.Where(u => u.UserID == loginStatus.UserID).Select(u => u).FirstOrDefault();
}
catch (Exception ex)
{
Debug.WriteLine("FillLoginInfo exception: " + ex.Message);
}
if (result != null)
{
loginInfo.LoginID = result.LoginID;
}
loginInfo.SessionData = Session.SessionID;
}
return(loginInfo);
}
public string checkOldPass(PreferenceModel pref)
{
uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
if (UtilityFunction.EncryptPassword(pref.Password) == user.Password)
{
return("success");
}
else if (String.IsNullOrEmpty(user.Password) && user.ChangePassword && UtilityFunction.EncryptPassword(pref.Password) == user.TempPassword)
{
return("success");
}
return("fail");
}
public string GetInterviewerInfo(string userId)
{
int uid = Int32.Parse(userId);
using (var context = DataContext.getUasDbContext())
{
context.Configuration.LazyLoadingEnabled = false;
uas_User user = (from i in context.uas_User
where i.UserID == uid
select i).FirstOrDefault();
context.Entry(user).Collection(u => u.uas_UserAddress).Load();
context.Entry(user).Collection(u => u.uas_UserPhone).Load();
context.Entry(user).Collection(u => u.uas_UserEmail).Load();
string jsonInfo = fastJSON.JSON.ToJSON(user);
return(jsonInfo);
}
}
/*
* Method to get the uas_User
* *** Only needed fields are being populated. ***
*/
public static uas_User GetUserByLogin(DbConnection dbConn, string loginID)
{
uas_User usr = null;
DbDataReader reader = null;
try
{
using (DbCommand command = dbConn.CreateCommand())
{
command.CommandText = "SELECT UserID,EnterpriseID,Password,FirstName,LastName,StatusFlag FROM [dbo].uas_User WHERE LoginID = '" + loginID + "'";
command.CommandType = CommandType.Text;
reader = command.ExecuteReader();
reader.Read();
if (!reader.IsDBNull(0))
{
Debug.WriteLine("* * * GetUserByLogin uas_User FieldCount: " + reader.FieldCount.ToString());
Debug.WriteLine("* * * GetUserByLogin uas_User : "******"FirstName"] + " " + reader["LastName"]);
var fname = reader["FirstName"];
var lname = reader["LastName"];
usr = new uas_User();
usr.UserID = reader.GetInt32(0);
usr.EnterpriseID = reader.GetInt32(1);
usr.Password = reader.GetString(2);
usr.FirstName = (fname == null)? String.Empty : fname.ToString();
usr.LastName = (lname == null) ? String.Empty : lname.ToString();
usr.StatusFlag = reader.GetString(5);
}
reader.Close();
}
}
catch (Exception ex)
{
Debug.WriteLine("* * * GetUserByLogin Exception: " + loginID + " - " + ex.Message);
throw; // throw the same exception
}
return(usr);
}
public string Save(PreferenceModel pref)
{
Debug.WriteLine("PreferencesController.Save from form - first last:" + pref.user.FirstName + " " + pref.user.LastName);
Debug.WriteLine("PreferencesController.Save address: " + pref.address.Address1);
if (!SessionHelper.IsUserLoggedIn)
{
return("User not logged in");
}
uas_User user = pref.db.uas_User.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
uas_UserPhone userPhone = pref.db.uas_UserPhone.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
uas_UserAddress userAddress = pref.db.uas_UserAddress.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
uas_UserEmail userEmail = pref.db.uas_UserEmail.Where(u => u.UserID == SessionHelper.LoginStatus.UserID).FirstOrDefault();
user.FirstName = pref.user.FirstName;
user.LastName = pref.user.LastName;
user.MiddleName = pref.user.MiddleName;
user.Title = pref.user.Title;
user.Area = pref.user.Area;
userPhone.PhoneNumber = pref.phone.PhoneNumber;
userPhone.Extension = pref.phone.Extension;
userAddress.Address1 = pref.address.Address1;
userAddress.City = pref.address.City;
userAddress.StateProvince = pref.address.StateProvince;
userAddress.PostalCode = pref.address.PostalCode;
userEmail.EmailAddress = pref.email.EmailAddress;
user.ModifiedBy = SessionHelper.LoginStatus.UserID;
user.ModifiedDate = DateTime.Now;
userPhone.ModifiedBy = SessionHelper.LoginStatus.UserID;
userPhone.ModifiedDate = DateTime.Now;
userAddress.ModifiedBy = SessionHelper.LoginStatus.UserID;
userAddress.ModifiedDate = DateTime.Now;
userEmail.ModifiedBy = SessionHelper.LoginStatus.UserID;
userEmail.ModifiedDate = DateTime.Now;
pref.db.Entry(user).State = System.Data.Entity.EntityState.Modified;
pref.db.Entry(userAddress).State = System.Data.Entity.EntityState.Modified;
pref.db.Entry(userPhone).State = System.Data.Entity.EntityState.Modified;
pref.db.Entry(userEmail).State = System.Data.Entity.EntityState.Modified;
pref.user = user;
pref.address = userAddress;
pref.phone = userPhone;
pref.email = userEmail;
try
{
pref.db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
Debug.WriteLine("Save DbEntityValidation Exception: ");
string errors = "";
foreach (DbEntityValidationResult devr in dbEx.EntityValidationErrors)
{
foreach (DbValidationError dve in devr.ValidationErrors)
{
Debug.WriteLine(" DbEntityValidationResult: " + dve.ErrorMessage);
errors += dve.ErrorMessage + "<br />";
}
}
return(errors);
}
catch (System.Data.DataException de)
{
Debug.WriteLine("Save DataException: " + de.Message);
return(de.Message);
}
catch (Exception xcptn)
{
Debug.WriteLine("Save Exception: " + xcptn.Message);
return(xcptn.Message);
}
return("success");
}
public MoveModel(int frID, IFormsRepository fr)
{
LoginIDs = new List <SelectListItem>();
formResultId = frID;
formsRepo = fr;
def_FormResults formResult = formsRepo.GetFormResultById(formResultId);
def_ResponseVariables rvFirst = formsRepo.GetResponseVariablesByFormResultIdentifier(formResultId, "sis_cl_first_nm");
if (rvFirst != null)
{
firstName = rvFirst.rspValue;
}
def_ResponseVariables rvLast = formsRepo.GetResponseVariablesByFormResultIdentifier(formResultId, "sis_cl_last_nm");
if (rvLast != null)
{
lastName = rvLast.rspValue;
}
recipientID = formResult.subject;
using (var context = DataContext.getUasDbContext())
{
if (formResult.EnterpriseID != null)
{
enterprise = context.uas_Enterprise.Where(e => e.EnterpriseID == formResult.EnterpriseID).Select(e => e.EnterpriseName).FirstOrDefault();
selectedEnterprise = (int)formResult.EnterpriseID;
}
if (formResult.GroupID != null)
{
group = context.uas_Group.Where(g => g.GroupID == formResult.GroupID).Select(g => g.GroupName).FirstOrDefault();
selectedGroup = (int)formResult.GroupID;
}
if (formResult.assigned != null)
{
uas_User assignedUser = context.uas_User.Where(u => u.UserID == formResult.assigned).Select(u => u).FirstOrDefault();
selectedUser = (int)formResult.assigned;
if (assignedUser != null)
{
assigned = assignedUser.UserName;
//if (assignedUser.StatusFlag != "A")
//{
// assigned += " (inactive)";
//}
}
}
LoginIDs.Add(new SelectListItem {
Value = "", Text = ""
});
if (SessionHelper.LoginStatus.EnterpriseID == 0) // User has site wide (all enterprise) access
{
Enterprises = new List <SelectListItem>();
Groups = new List <SelectListItem>();
List <uas_Enterprise> enterprises = context.uas_Enterprise.Where(e => e.StatusFlag == "A").Select(e => e).ToList();
foreach (uas_Enterprise ent in enterprises)
{
Enterprises.Add(new SelectListItem {
Value = ent.EnterpriseID.ToString(), Text = ent.EnterpriseName
});
}
List <uas_Group> groups = context.uas_Group.Where(g => g.StatusFlag == "A" && g.EnterpriseID == selectedEnterprise).Select(g => g).ToList();
Groups.Add(new SelectListItem {
Value = "", Text = ""
});
foreach (uas_Group grp in groups)
{
Groups.Add(new SelectListItem {
Value = grp.GroupID.ToString(), Text = grp.GroupName
});
}
List <uas_User> users = null;
if (selectedGroup > 0)
{
List <int> userIdsForUserGroup = context.uas_GroupUserAppPermissions.Where(g =>
selectedGroup == g.uas_Group.GroupID && g.StatusFlag == "A").Select(g => g.UserID).ToList();
users = context.uas_User.Where(u => u.EnterpriseID == selectedEnterprise &&
userIdsForUserGroup.Contains(u.UserID) && u.StatusFlag == "A").Select(u => u).ToList();
}
else
{
users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID).Select(u => u).ToList();
}
foreach (uas_User user in users)
{
LoginIDs.Add(new SelectListItem {
Value = user.UserID.ToString(), Text = user.UserName
});
}
}
else if (SessionHelper.LoginStatus.appGroupPermissions[0].authorizedGroups.Contains(0)) // User has enterprise wide access (all groups/users in enterprise)
{
Groups = new List <SelectListItem>();
List <uas_User> users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && u.StatusFlag == "A").Select(u => u).ToList();
foreach (uas_User user in users)
{
LoginIDs.Add(new SelectListItem {
Value = user.UserID.ToString(), Text = user.UserName
});
}
List <uas_Group> groups = context.uas_Group.Where(g => g.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && g.StatusFlag == "A").Select(g => g).ToList();
Groups.Add(new SelectListItem {
Value = "", Text = ""
});
foreach (uas_Group grp in groups)
{
Groups.Add(new SelectListItem {
Value = grp.GroupID.ToString(), Text = grp.GroupName
});
}
}
else // Regular user. No selection for enterprise or group.
{
var authorizedGroups = SessionHelper.LoginStatus.appGroupPermissions[0].authorizedGroups;
List <int> userIdsForUserGroup = context.uas_GroupUserAppPermissions.Where(g =>
authorizedGroups.Contains(g.uas_Group.GroupID) && g.StatusFlag == "A").Select(g => g.UserID).ToList();
List <uas_User> users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID &&
userIdsForUserGroup.Contains(u.UserID) && u.StatusFlag == "A").Select(u => u).ToList();
foreach (uas_User user in users)
{
LoginIDs.Add(new SelectListItem {
Value = user.UserID.ToString(), Text = user.UserName
});
}
}
}
}
