public void UpdateUser(skUser UserObj, bool ResetPassword) { dtUser user = DB.dtUsers.Single(x => x.uID == UserObj.UserID); if (ResetPassword) { user.PassWord = UserObj.Password; } user.UserName = UserObj.UserName; dtUserDetail userdetail = DB.dtUserDetails.Single(x => x.UserID == UserObj.UserID); userdetail.DateOfBirth = UserObj.DOB; userdetail.Email = UserObj.Email; userdetail.FirstName = UserObj.FistName; userdetail.LastName = UserObj.LastName; userdetail.HomePhone = UserObj.HomePhone; userdetail.WorkPhone = UserObj.WorkPhone; userdetail.Initials = UserObj.Initials; DB.SubmitChanges(); }
public void AddNewUser(skUser UserObj) { dtUser newuser = new dtUser { UserName = UserObj.UserName, PassWord = UserObj.Password, Created = DateTime.Now, IsAdmin = UserObj.IsAdmin }; dtUserDetail newuserdetails = new dtUserDetail { FirstName = UserObj.FistName, LastName = UserObj.LastName, DateOfBirth = UserObj.DOB, Initials = UserObj.Initials, Email = UserObj.Email, HomePhone = UserObj.HomePhone, WorkPhone = UserObj.WorkPhone, dtUser = newuser }; dtUserPreferance newuserpref = new dtUserPreferance { Code = "MAINTOOLCO", Description = "Main tool bar background colour", Name = "Main ToolBar", UserID = GetLatestUserID() + 1, PreferenceTypeID = 1, Value = "Black" }; DB.dtUserDetails.InsertOnSubmit(newuserdetails); DB.dtUserPreferances.InsertOnSubmit(newuserpref); DB.SubmitChanges(); }