public bool UpdateUserAccount(Trainee trainee)
{
// update user account
try
{
string userName = string.Format("{0}{1}{2}", trainee.LastName, trainee.FirstName.Substring(0, 1), trainee.PID.Substring(trainee.PID.Length - 4, 4));
string password = string.Format("{0}{1}", trainee.LastName, trainee.PID.Substring(trainee.PID.Length - 4, 4));
byte[] passwd = DataHash.GetHashData(password, "SHA1");
secdivDataContext db = new secdivDataContext();
var userAccounts = db.UserAccounts.Where(u => u.PID.Equals(trainee.PID));
if (userAccounts.Count() > 0)
{
UserAccount userAccount = userAccounts.First();
if (userAccount.UserName == userName)
{
userAccount.Password = passwd;
userAccount.PID = trainee.PID;
userAccount.TypeOfUser = trainee.OperatorType;
userAccount.UAStatus = "Current";
db.SubmitChanges();
return true;
}
else
{
UserAccount ua = new UserAccount
{
UserName = userName,
Password = passwd,
PID = trainee.PID,
TypeOfUser = trainee.OperatorType,
UAStatus = "Current"
};
db.UserAccounts.InsertOnSubmit(ua);
db.SubmitChanges();
return true;
}
}
else
return false;
}
catch
{
return false;
}
}
private void detach_UserAccounts(UserAccount entity)
{
this.SendPropertyChanging();
entity.Person = null;
}
partial void UpdateUserAccount(UserAccount instance);
partial void DeleteUserAccount(UserAccount instance);
partial void InsertUserAccount(UserAccount instance);
