private void iAddBtn_Click(object sender, EventArgs e)
{
//validate input
//add instructor details
if (!Validation.isTextBoxValid(errorProvider1, IuserIdTxtBox, iPasswordTxtBox, iFirstNameTxtBox, iLastNameTxtBox, iEmailTxtBox, iPhoneTxtBox))
{
return;
}
//add instructor
adminConnect = new AdminConnect();
InstructorObject instructor = new InstructorObject();
instructor.UserId = IuserIdTxtBox.Text;
instructor.Password = iPasswordTxtBox.Text;
instructor.FirstName = iFirstNameTxtBox.Text;
instructor.LastName = iLastNameTxtBox.Text;
instructor.Phone = iPhoneTxtBox.Text;
instructor.Email = iEmailTxtBox.Text;
if (adminConnect.AddUser(instructor) <= 0)
{
//show error
MessageBox.Show("Instructor not added", "Add error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
}
else
{
//display success message
MessageBox.Show("Instructor added successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
}
}
public UserObject ViewUser(string userId, UserObject.UserRole userRole)
{
try
{
string sqlSelect = $"SELECT u.[userId], u.[password], u.[roleId], u.[fName], u.[lName], u.[email], u.[phone] FROM user_tbl u WHERE userId = @UserId";
if (userRole != UserObject.UserRole.Instructor || userRole != UserObject.UserRole.Student)
{
throw new NullReferenceException();
}
parameters = new List <ParameterList>();
UserObject user = null;
switch (userRole)
{
case UserObject.UserRole.Instructor:
user = new InstructorObject();
break;
case UserObject.UserRole.Student:
user = new StudentObject();
break;
default:
break;
}
parameters.Add(new ParameterList()
{
Key = "@UserId", Value = userId
});
adminDataAccess = new DataAccess();
Task <DataTable> task = Task.Run(() => adminDataAccess.GetDataAsync(sqlSelect, parameters));
user.UserId = task.Result.Columns["userId"].ToString();
user.Password = task.Result.Columns["password"].ToString();
user.userRole = (UserObject.UserRole)Convert.ToInt32(task.Result.Columns["roleId"]);
user.FirstName = task.Result.Columns["fName"].ToString();
user.LastName = task.Result.Columns["lName"].ToString();
user.Email = task.Result.Columns["email"].ToString();
user.Phone = task.Result.Columns["phone"].ToString();
if (user == null)
{
throw new NullReferenceException();
}
else
{
return(user);
}
}
catch (Exception ex)
{
throw;
}
}
