public virtual bool Add(SystemUserRecord systemUserRecord) { if (UserIsNotValid(systemUserRecord)) return false; string addUserString = PrepareAddString(systemUserRecord); return databaseManager.ExecuteInsert(addUserString); }
public void add_system_user_return_false_when_system_user_is_not_valid() { mockDatabaseManager.Setup(mock => mock.ExecuteInsert(It.IsAny<string>())).Returns(true); sut.SetDatabaseManager(mockDatabaseManager.Object); SystemUserRecord systemUser = new SystemUserRecord { SystemUserName = USERNAME, SystemUserPassword = PASSWORD, Role = string.Empty }; var result = sut.Add(systemUser); Assert.IsFalse(result); mockDatabaseManager.Verify(mock => mock.ExecuteInsert(It.IsAny<string>()),Times.Never()); }
public void add_system_user_returns_true_when_successfully_add_a_user() { mockDatabaseManager.Setup(mock => mock.ExecuteInsert(It.IsAny<string>())).Returns(true); sut.SetDatabaseManager(mockDatabaseManager.Object); SystemUserRecord systemUser = new SystemUserRecord {SystemUserName = USERNAME, SystemUserPassword = PASSWORD, Role = ROLE}; var result = sut.Add(systemUser); Assert.IsTrue(result); mockDatabaseManager.Verify(mock => mock.ExecuteInsert("INSERT INTO SystemUserTable (username, userpassword, role) VALUES ( 'username','password','admin' )"), Times.Once()); }
private SystemUserRecord GetSystemUserWithDataGridViewSelectedRow(DataGridView view, int currentRow) { var systemUserRecord = new SystemUserRecord(); systemUserRecord.ID = view.Rows[currentRow].Cells["Column_SystemUserID"].Value as string; systemUserRecord.SystemUserName = view.Rows[currentRow].Cells["Column_SystemUserName"].Value as string; systemUserRecord.SystemUserPassword = view.Rows[currentRow].Cells["Column_SystemUserPassword"].Value as string; systemUserRecord.Role = view.Rows[currentRow].Cells["Column_SystemUserRole"].Value as string; return systemUserRecord; }
private void SystemUserView_UpdateSystemUser(object sender, EventArgs e) { SystemUserRecord systemUserRecord = new SystemUserRecord(); systemUserRecord.ID = editSystemUserView.SystemUserID; systemUserRecord.SystemUserName = editSystemUserView.SystemUserName; systemUserRecord.SystemUserPassword = editSystemUserView.SystemUserPassword; systemUserRecord.Role = editSystemUserView.SystemUserRole; bool updateSystemUserResult = editSystemUserModel.Update(systemUserRecord); if (updateSystemUserResult) { classScheduleHelper.PopMessage(@"Update user success", @"Update user", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { classScheduleHelper.PopMessage(@"Update user failed", @"Update user", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private bool UserIsNotValid(SystemUserRecord systemUserRecord) { return string.IsNullOrEmpty(systemUserRecord.SystemUserName) || string.IsNullOrEmpty(systemUserRecord.SystemUserPassword) || string.IsNullOrEmpty(systemUserRecord.Role); }
private string PrepareUpdateString(SystemUserRecord systemUserRecord) { return string.Format("UPDATE SystemUserTable " + "SET username = \'{0}\' , " + "userpassword = \'{1}\' , " + "role = \'{2}\' " + "WHERE ID = {3}", systemUserRecord.SystemUserName, systemUserRecord.SystemUserPassword, systemUserRecord.Role,systemUserRecord.ID); }
private string PrepareAddString(SystemUserRecord systemUserRecord) { return string.Format("INSERT INTO SystemUserTable " + "(username, userpassword, role) " + "VALUES ( \'{0}\',\'{1}\',\'{2}\' )", systemUserRecord.SystemUserName, systemUserRecord.SystemUserPassword, systemUserRecord.Role); }
private List<SystemUserRecord> GetSystemUserListFromDataTable(DataTable systemUserTable) { var systemUserList = new List<SystemUserRecord>(); if (systemUserTable == null) return systemUserList; foreach (DataRow dataRow in systemUserTable.Rows) { var systemUser = new SystemUserRecord(); systemUser.ID = dataRow[0].ToString(); systemUser.SystemUserName = dataRow[1].ToString(); systemUser.SystemUserPassword = dataRow[2].ToString(); systemUser.Role = dataRow[3].ToString(); systemUserList.Add(systemUser); } return systemUserList; }
public bool Update(SystemUserRecord systemUserRecord) { if (UserIsNotValid(systemUserRecord)) return false; string updateUserString = PrepareUpdateString(systemUserRecord); return databaseManager.ExecuteUpdate(updateUserString); }
private void SystemUserView_AddUser(object sender, EventArgs e) { SystemUserRecord systemUserRecord = new SystemUserRecord(); systemUserRecord.SystemUserName = systemUserView.SystemUserName; systemUserRecord.SystemUserPassword = systemUserView.SystemUserPassword; systemUserRecord.Role = systemUserView.SystemUserRole; if (systemUserModel.Add(systemUserRecord)) { classScheduleHelper.PopMessage("Add System User success"); }else { classScheduleHelper.PopMessage("Add System User failed"); } }
public void update_system_user_return_true_when_successfully_update_a_user() { SystemUserRecord systemUser = new SystemUserRecord { ID = "1", SystemUserName = USERNAME, SystemUserPassword = PASSWORD, Role = ROLE }; mockDatabaseManager.Setup(foo => foo.ExecuteUpdate(It.IsAny<string>())).Returns(true); sut.SetDatabaseManager(mockDatabaseManager.Object); var result = sut.Update(systemUser); Assert.IsTrue(result); mockDatabaseManager.Verify(foo => foo.ExecuteUpdate("UPDATE SystemUserTable SET username = \'username\' , userpassword = \'password\' , role = \'admin\' WHERE ID = 1"), Times.Once()); }
public void update_system_user_return_false_when_user_is_not_valid() { SystemUserRecord systemUser = new SystemUserRecord { ID = "1", SystemUserName = USERNAME, SystemUserPassword = PASSWORD, Role = string.Empty }; mockDatabaseManager.Setup(foo => foo.ExecuteUpdate(It.IsAny<string>())).Returns(true); sut.SetDatabaseManager(mockDatabaseManager.Object); var result = sut.Update(systemUser); Assert.IsFalse(result); mockDatabaseManager.Verify(foo => foo.ExecuteUpdate(It.IsAny<string>()), Times.Never()); }