public void updateUser(string pUserId, string pPassword, string pRole, string pSection)
{
try
{
loMySqlTransaction = GlobalVariables.goMySqlConnection.BeginTransaction();
loUser = new User();
loUser.userID = pUserId;
loUser.password = pPassword;
loUser.defaultSection = pSection;
loUser.update(ref loMySqlTransaction);
loUserRole = new UserRole();
loUserRole.RoleName = pRole;
loUserRole.UserId = pUserId;
loUserRole.insert(ref loMySqlTransaction);
loMySqlTransaction.Commit();
}
catch (Exception)
{
loMySqlTransaction.Rollback();
throw;
}
}
public void deleteUser(string pUserId)
{
loUser = new User();
loUser.delete(pUserId);
}
public DataTable getUsers()
{
loUser = new User();
return loUser.get();
}
public User getUserDetailsById(string pUserId)
{
loUser = new User(pUserId);
return loUser;
}
public DataTable getSections()
{
loUser = new User();
return loUser.getSections();
}
private void ViewUser_Load(object sender, EventArgs e)
{
cboRole.DataSource = loAdministration.getRoles();
cboRole.DisplayMember = "RoleName";
cboRole.ValueMember = "RoleName";
cboDefaultSection.DataSource = loAdministration.getSections();
cboDefaultSection.DisplayMember = "Section";
cboDefaultSection.ValueMember = "SectionId";
loUser = loAdministration.getUserDetailsById(UserId);
txtUserId.Text = UserId;
cboRole.Text = loUser.role;
cboDefaultSection.SelectedValue = loUser.defaultSection;
txtPassword.Text = loUser.password;
txtConfirmPassword.Text = loUser.password;
}
public DataTable getUsers()
{
User _user = new User();
return _user.get();
}
