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