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