public void InsertData()
{
using (SqlConnection connection = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_AddCourse", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@courseName", name);
cmd.Parameters.AddWithValue("@courseCode", code);
cmd.Parameters.AddWithValue("@credits", credits);
cmd.Parameters.AddWithValue("@faculty", getFaculty);
cmd.Parameters.AddWithValue("@description", description);
cmd.Parameters.AddWithValue("@dateOfAddition", date);
cmd.Parameters.AddWithValue("@courseAps", courseAps);
connection.Open();
cmd.ExecuteNonQuery();
Essentials.DisplayMessage("Course Successfully Added", "Course Addition");
Essentials.ResetControls(edtAPSPoint, edtCourseCode, edtCourseName, edtCredits, txtBoxDescribtion);
connection.Close();
}
}
}
private void GetAllCourses()
{
string selectQuery = string.Format("SELECT name,code,credits,aps,faculty FROM Course");
try
{
using (SqlConnection conn = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand command = new SqlCommand(selectQuery, conn))
{
command.CommandType = CommandType.Text;
DataTable dt = new DataTable();
conn.Open();
SqlDataReader sdr = command.ExecuteReader();
dt.Load(sdr);
conn.Close();
ViewCourseDataGridView.DataSource = dt;
}
}
}
catch (Exception ex)
{
Essentials.SetErrorMessage(ex.Message, "Error");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
const string updateQuery = "Update ApplicationInfotbl SET role=@role,appStatus=@appStatus WHERE name=@name";
try
{
using (SqlConnection conn = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand command = new SqlCommand(updateQuery, conn))
{
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@role", GetRole());
command.Parameters.AddWithValue("@appStatus", GetAdmissionStatus());
command.Parameters.AddWithValue("@name", cboUsers.Text);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
Essentials.DisplayMessage("role changed successfully", "Roles");
Essentials.ResetControls(rdoAdmin, rdoNoAccess, rdoStudent);
}
}
}catch (Exception ex)
{
Essentials.SetErrorMessage(ex.Message, "Role Update Error");
}
}
public void InsertData()
{
using (SqlConnection connection = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_InsertCourse", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@courseName", name);
cmd.Parameters.AddWithValue("@courseCode", code);
cmd.Parameters.AddWithValue("@courseType", type);
cmd.Parameters.AddWithValue("@dateOfAddition", date);
cmd.Parameters.AddWithValue("@courseAps", aps);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
Essentials.DisplayMessage("Course/Subject Successfully Added", "Course Addition");
Essentials.ResetControls(edtName, edtCode, cboxAPS, cboxSubject, edtAps);
Essentials.HideControls(edtAps);
}
}
}
private void btnApply_Click(object sender, EventArgs e)
{
string name, lastName, applicationStatus = "Submitted",role = "NONE",
id, address, phoneNumber, gender, emailAddress,
highestGrade, nameOfSchool, schoolLeavingDate, password = "******", studentNumber;
DateTime applicationDate;
string subject1, subject2, subject3, subject4,
subject5, subject6, subject7;
const int idNumberLength = 13;
int year = DateTime.Today.Year;
int apsSum = 0;
if (!Essentials.ContainsText(edtName, edtLastName, edtMail, edtID, edtAddress, edtPhoneNumber, edtSchoolName))
{
Essentials.SetErrorMessage("Error: Input Field(s) cannot be empty,please fill in all fields", "Error: Empty Field(s)");
}
else
{
name = Essentials.RetrieveInputText(edtName);
lastName = Essentials.RetrieveInputText(edtLastName);
id = Essentials.RetrieveInputText(edtID);
address = Essentials.RetrieveInputText(edtAddress);
phoneNumber = Essentials.RetrieveInputText(edtPhoneNumber);
emailAddress = Essentials.RetrieveInputText(edtMail);
nameOfSchool = Essentials.RetrieveInputText(edtSchoolName);
Student student;
studentNumber = GenerateStudNum().Substring(0, 5).Insert(0, $"{year}");
applicationDate = DateTime.Now;
gender = cboGender.Text;
highestGrade = cboHighestGrade.Text;
schoolLeavingDate = cndarSchoolLeaving.Value.ToString();
subject1 = cboSubject1.Text;
subject2 = cboSubject2.Text;
subject3 = cboSubject3.Text;
subject4 = cboSubject4.Text;
subject5 = cboSubject5.Text;
subject6 = cboSubject6.Text;
subject7 = cboSubject7.Text;
apsSum = ComputeApplicantAPS(cboPercentage1) + ComputeApplicantAPS(cboPercentage2) + ComputeApplicantAPS(cboPercentage3)
+ ComputeApplicantAPS(cboPercentage4) + ComputeApplicantAPS(cboPercentage5) + ComputeApplicantAPS(cboPercentage6)
+ ComputeApplicantAPS(cboPercentage7);
if (InspectComboValidity(cboSubject1, cboSubject3, cboSubject4,
cboSubject5, cboSubject6, cboSubject7))
{
if (Essentials.IsValidNamesInput(Essentials.RetrieveInputText(edtName)))
{
if (Essentials.IsValidMail(Essentials.RetrieveInputText(edtMail)))
{
if (edtID.Text.Length == idNumberLength)
{
using (SqlConnection connection = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_Insert_ApplicantInfo", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@lastName", lastName);
cmd.Parameters.AddWithValue("@identityNum", id);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@phone", phoneNumber);
cmd.Parameters.AddWithValue("@email", emailAddress);
cmd.Parameters.AddWithValue("@school", nameOfSchool);
cmd.Parameters.AddWithValue("@applicationDate", applicationDate);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@highestGrade", highestGrade);
cmd.Parameters.AddWithValue("@sub1", subject1);
cmd.Parameters.AddWithValue("@sub2", subject2);
cmd.Parameters.AddWithValue("@sub3", subject3);
cmd.Parameters.AddWithValue("@sub4", subject4);
cmd.Parameters.AddWithValue("@sub5", subject5);
cmd.Parameters.AddWithValue("@sub6", subject6);
cmd.Parameters.AddWithValue("@sub7", subject7);
cmd.Parameters.AddWithValue("@appStatus", applicationStatus);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@studNum", studentNumber);
cmd.Parameters.AddWithValue("@aps", apsSum);
cmd.Parameters.AddWithValue("@role", role);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
Essentials.DisplayMessage($"Application successfully submitted\nStudent Number {studentNumber}", $"Application");
Essentials.ResetControls(edtName, edtLastName, edtMail, edtID, edtAddress, edtSchoolName,
edtPhoneNumber, cboxGoodHealth, cboxPoorHealth, cboxYesDisabled, cboxNoDisabled);
}
}
}
else
{
Essentials.SetErrorMessage($"Error: Invalid Identity number", $"Invalid ID");
}
}
else
{
Essentials.SetErrorMessage($"Error: Invalid Email address", $"EMail Invalid");
}
}
else
{
Essentials.SetErrorMessage($"Error: Name supplied is not valid", $"Invalid name");
}
}
else
{
Essentials.SetErrorMessage($"Error: Please select all subjects", $"Subject(s) missing");
}
}
}
private void btnCheck_Click(object sender, EventArgs e)
{
if (Essentials.ContainsText(edtIdNum))
{
if (Essentials.GetAllInputText(edtIdNum).Length == 13)
{
string id = Essentials.GetAllInputText(edtIdNum);
int log = 1;
string selectQuery = string.Format("SELECT name,lastName,appStatus,studNum,identityNum From ApplicationInfotbl");
try
{
using (SqlConnection conn = new SqlConnection(Connectivity.ConnectionString()))
{
using (SqlCommand command = new SqlCommand(selectQuery, conn))
{
command.CommandType = CommandType.Text;
conn.Open();
SqlDataReader sdr = command.ExecuteReader();
if (sdr.HasRows)
{
while (sdr.Read())
{
if (sdr["identityNum"].ToString().Equals(id))
{
this.Size = new Size(680, 472);
Essentials.ShowControls(statusGroupBox, btnReset);
lblStudNum.Text = sdr["studNum"].ToString();
lblName.Text = sdr["name"].ToString();
lblLastName.Text = sdr["lastName"].ToString();
lblStatus.Text = sdr["appStatus"].ToString();
log = 0;
}
}
if (log != 0)
{
Essentials.SetErrorMessage($"No record found for: {id}", " Id record not found");
}
}
conn.Close();
}
}
}
catch (Exception ex)
{
Essentials.SetErrorMessage(ex.Message, "Id Error");
}
}
else
{
Essentials.SetErrorMessage("Error: ID number provided is invalid", "Invalid ID");
}
}
else
{
Essentials.SetErrorMessage("Error: ID number is required!", "Empty ID field");
}
}
