public void Delete(User user) { var executor = new CommandExecutor("dbo.DeleteUser", connectionString); executor.SetParam("@Username", user.Login, SqlDbType.NVarChar); var result = executor.ExecuteCommand(); result.ThrowIfException(); }
public void Create(User user) { var executor = new CommandExecutor("dbo.CreateUser", connectionString); executor.SetParam("@Username", user.Login, SqlDbType.NVarChar); executor.SetParam("@Password", user.Password, SqlDbType.NVarChar); var userType = (int) user.Type + 1; executor.SetParam("@Usertype", userType, SqlDbType.Int); var result = executor.ExecuteCommand(); result.ThrowIfException(); }
public void InsertUser(Model.User oData) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "Insert Into tbl_user (Username,Fullname,Password,Role,Contact_No,Address,Added_By,Date_Added) Values ('" + oData.USERNAME + "','" + oData.FULLNAME + "','" + oData.PASSWORD + "','" + oData.ROLE + "','" + oData.CONTACT_NO + "','" + oData.ADDRESS + "','" + "Rolly" + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "')"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }
public void UpdateUser(Model.User oData) { try { osb.ConnectionString = sConnectionString; ddq = new DatabaseQuery.DBQuery(); ddq.ConnectionString = osb.ConnectionString; ddq.CommandText = "Update tbl_user set Fullname = '" + oData.FULLNAME + "',Password = '******',Role = '" + oData.ROLE + "',Contact_No = '" + oData.CONTACT_NO + "',Address = '" + oData.ADDRESS + "',Added_By = '" + "Rolly" + "' where Username = '******'"; ddq.ExecuteNonQuery(CommandType.Text); } catch (Exception ex) { throw ex; } }
public UserEditorWindowViewModel(UserEditorWindow view, User user, UserRepository repository) { if (user == null) { CreateMode = true; user = new User(); } this.view = view; this.repository = repository; User = user; if (CreateMode) return; view.SetPasswordDots(); view.Set(User.Type); }
public void Delete(User user) { var result = MessageBox.Show( string.Format(Resources.DeleteUserConfirmatonText, user.Login), Resources.DeleteConfirmationCaption, MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { try { repository.Delete(user); RetrieveData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public void OpenEditor(User user) { try { if (user != null) { user = user.Clone(); } var editor = new UserEditorWindow(user); var result = editor.ShowDialog(); if (result.HasValue && result.Value) { RetrieveData(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }