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);