internal static void UpdateUserPreference(user_ref_limit url)
{
user_ref_limit current = null;
try
{
current = db.user_ref_limits.Single(c => c.limit_id == url.limit_id && c.user_id == url.user_id);
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
if (current == null)
{
db.user_ref_limits.InsertOnSubmit(url);
db.SubmitChanges();
}
else
{
current.limit_id = url.limit_id;
current.user_id = url.user_id;
current.Partial = url.Partial;
db.SubmitChanges();
}
}
private void OnOk(object parameter)
{
if (EditPersonalDetails.Password1 != EditPersonalDetails.Password2)
{
OneButtonScreen.ShowMessage("פרט שגוי", "הססמאות אינן זהות");
return;
}
if (!(EditPersonalDetails.Address.Length > 0 &&
EditPersonalDetails.Phone.Length > 0 &&
EditPersonalDetails.FirstName.Length > 0 &&
EditPersonalDetails.LastName.Length > 0))
{
OneButtonScreen.ShowMessage("פרט שגוי", "אחד או יותר מהפרטים שגויים");
return;
}
m_User.address = EditPersonalDetails.Address;
m_User.phone = EditPersonalDetails.Phone;
m_User.name = EditPersonalDetails.FirstName;
m_User.last_name = EditPersonalDetails.LastName;
if (EditPersonalDetails.Password1.Length > 0)
{
m_User.password = SecurePasswordHasher.Hash(EditPersonalDetails.Password1);
}
m_User = DataBaseManager.UpdateUser(m_User);
foreach (var item in EditPersonalDetails.LimitationsList)
{
try
{
if (item.HasChanged())
{
user_ref_limit ul = new user_ref_limit();
ul.user_id = m_User.user_id;
ul.limit_id = item.LimitID;
ul.Partial = item.LimitValue == 1;
if (item.LimitValue > 0)
{
DataBaseManager.UpdateUserPreference(ul);
}
else
{
DataBaseManager.RemoveUserPreference(ul);
}
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
m_MainWindow.GoToPrevPage();
}
internal static void RemoveUserPreference(user_ref_limit url)
{
user_ref_limit current = null;
try
{
current = db.user_ref_limits.Single(c => c.limit_id == url.limit_id && c.user_id == url.user_id);
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return;
}
db.user_ref_limits.DeleteOnSubmit(current);
db.SubmitChanges();
}
private void OnOk(object parameter)
{
if (DataBaseManager.DoesUserNameExistsAlready(Registration.UserName))
{
OneButtonScreen.ShowMessage("בחר שם משתמש אחר", "שם המשתמש שבחרת כבר תפוס");
return;
}
if (Registration.Password1 != Registration.Password2)
{
OneButtonScreen.ShowMessage("פרט שגוי", "הססמאות אינן זהות");
return;
}
if (!(Registration.FirstName.Length > 0 &&
Registration.LastName.Length > 0 &&
Registration.Address.Length > 0 &&
Registration.Password1.Length > 0 &&
Registration.Password2.Length > 0 &&
Registration.UserName.Length > 0 &&
Registration.Password1.Length > 0))
{
OneButtonScreen.ShowMessage("פרט שגוי", "אחד או יותר מהפרטים שגויים");
return;
}
string SaltedAndHashedPassword = SecurePasswordHasher.Hash(Registration.Password1);
user u = new user();
u.user_name = Registration.UserName;
u.password = SaltedAndHashedPassword;//textbox_pswd.Text;
u.address = Registration.Address;
u.name = Registration.FirstName;
u.last_name = Registration.LastName;
DataBaseManager.AddUser(u);
if (u.user_id != 0)
{
bool changed = false;
List <user_ref_limit> list = new List <user_ref_limit>();
foreach (var item in Registration.LimitationsList)
{
try
{
if (item.LimitValue > 0)
{
user_ref_limit ul = new user_ref_limit();
ul.user_id = u.user_id;
ul.limit_id = item.LimitID;
ul.Partial = item.LimitValue == 1;
list.Add(ul);
changed = true;
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
if (changed)
{
DataBaseManager.AddUserLimitations(list);
}
}
m_MainWindow.GoToPrevPage();
}
