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