public void UpDatePreferances(int UserID, string Code, object value) { dtUserPreferance pr = DB.dtUserPreferances.Single(x => x.Code == Code && x.UserID == UserID); pr.Value = value.ToString(); DB.SubmitChanges(); }
public void UpDatePreferances(List <skPreference> Preferances, int UserID) { foreach (skPreference Pref in Preferances) { dtUserPreferance pr = DB.dtUserPreferances.Single(x => x.Code == Pref.Code && x.UserID == UserID); pr.Value = Pref.Value.ToString(); 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(); }