public ActionResult Index()
{
StudentTransactions st = new StudentTransactions();
List <Student> listStudents = st.loadStudents();
return(View(listStudents));
}
void DataGridViewStudents()
{
StudentTransactions c = new StudentTransactions();
string sql = "SELECT * FROM Student";
DataTable dt = c.searchData(sql);
metroGridStudents.DataSource = dt;
}
private void StudentHome_Load(object sender, EventArgs e)
{
metroLabelUser.Text = Login.u; //logged in user name
StudentTransactions st = new StudentTransactions();
s = st.getStudentId(metroLabelUser.Text); // get user id
stdId = s.getid();
//execute methods onload
loadCombo();
loadComboShowMods();
loadComboTab();
}
private void metroButton3_Click(object sender, EventArgs e)
{
StudentTransactions c = new StudentTransactions();
string sql = "SELECT * FROM StudentModule";
DataTable dt = c.searchData(sql);
metroGridMRos.DataSource = dt;
if (dt.Rows.Count > 0)
{
metroLabeltotal.Text = metroGridMRos.Rows.Count.ToString();
}
else
{
MetroMessageBox.Show(this, "Still no one has registered for the " + metroComboBoxMr.Text + " Courses.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
void loadComboTab()
{
StudentTransactions std = new StudentTransactions();
std.getStudentId(metroLabelUser.Text);
String stid = s.getid();
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT mid FROM StudentModule WHERE sid = '" + stid + "'";
DataTable dt = c.searchData(sql);
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxModl.ValueMember = "mid";
metroComboBoxModl.DisplayMember = "mid";
metroComboBoxModl.DataSource = dt;
}
}
private void metroButtonRegister_Click(object sender, EventArgs e)
{
//validate data
if (metroTextBoxModId.Text == "" || metroTextBoxMod.Text == "" || metroComboBoxFaculty.Text == "" || metroTextBoxSem.Text == "" || metroTextBoxDuration.Text == "" || metroTextBoxMFee.Text == "" || metroTextBoxMOverview.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
else
{
modId = metroTextBoxModId.Text;
StudentTransactions st = new StudentTransactions();
string uname = metroLabelUser.Text;
CommonDBTransaction c = new CommonDBTransaction();
string sqlcheck = "SELECT SId FROM Student WHERE username= '******'";
DataTable d = c.searchData(sqlcheck);//validate data from db
string profid = d.ToString();
CommonDBTransaction co = new CommonDBTransaction();
modId = metroTextBoxModId.Text;
string sql = "SELECT * FROM StudentModule WHERE sid = '" + profid + "'AND mid='" + modId + "'";
DataTable dt = co.searchData(sql);//validate data from db
if (dt.Rows.Count > 0)
{
MetroMessageBox.Show(this, "You have already registered for this module!", "Warning");
metroGridModules.DataSource = dt;
metroGridModules.Refresh();
}
else
{
st.addstudentModule(); // insert data
modFee = metroTextBoxMFee.Text;
Bill b = new Bill(modFee, stdId, modId);
BillTransaction bt = new BillTransaction();
bt.addBill(b); //insert data
this.Hide();
Billing bill = new Billing();
bill.Show();
MetroMessageBox.Show(this, "Registration successful");
}
}
}
private void metroButtonSearch_Click(object sender, EventArgs e)
{
Student obj = new Student();
StudentTransactions tr2 = new StudentTransactions();
try
{
obj = tr2.dataFill(metroTextSearch.Text);
metroTextBoxStudentId.Text = obj.getid();
metroTextBoxFirstName.Text = obj.getFirstName();
metroTextBoxLastName.Text = obj.getLastName();
metroTextBoxDOB.Text = obj.getDOB();
metroTextBoxMobileNo.Text = obj.getContactNo();
metroTextBoxEmail.Text = obj.getEmail();
metroTextBoxAddress.Text = obj.getAddress();
metroComboBoxGen.Text = obj.getGender();
metroTextBoxUsername.Text = obj.getUsername();
metroTextBoxPassword.Text = obj.getPassword();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Stafford University Registration System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void metroButtonProceed_Click(object sender, EventArgs e)
{
if (metroComboBoxOptStd.Text == "Add")
{
if (metroTextBoxStudentId.Text == "" || metroTextBoxFirstName.Text == "" || metroTextBoxLastName.Text == "" || metroTextBoxDOB.Text == "" || metroTextBoxMobileNo.Text == "" || metroTextBoxEmail.Text == "" || metroTextBoxAddress.Text == "" || metroComboBoxGen.Text == "" || metroTextBoxUsername.Text == "" || metroTextBoxPassword.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
if (!Regex.Match(metroTextBoxMobileNo.Text, @"^\d{10}$").Success)
{
MetroMessageBox.Show(this, "Please re-enter the contact number", "Warning");
metroTextBoxMobileNo.Focus();
}
if (!Regex.Match(metroTextBoxEmail.Text, @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,4})+)$").Success)
{
MetroMessageBox.Show(this, "Invalid E-Mail address Please re-enter correct address");
metroTextBoxEmail.Focus();
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Student WHERE SId = '" + metroTextBoxStudentId.Text + "' or Username = '******'";
DataTable d = c.searchData(sql);
metroGridStudents.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Student obj = new Student(metroTextBoxStudentId.Text, metroTextBoxFirstName.Text, metroTextBoxLastName.Text, metroTextBoxDOB.Text, metroTextBoxMobileNo.Text, metroTextBoxEmail.Text, metroTextBoxAddress.Text, metroComboBoxGen.Text, metroTextBoxUsername.Text, metroTextBoxPassword.Text);
StudentTransactions tr = new StudentTransactions();
tr.addstudent(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearStudent();
metroGridStudents.Refresh();
}
}
}
else if (metroComboBoxOptStd.Text == "Update")
{
if (metroTextBoxStudentId.Text == "" || metroTextBoxFirstName.Text == "" || metroTextBoxLastName.Text == "" || metroTextBoxDOB.Text == "" || metroTextBoxMobileNo.Text == "" || metroTextBoxEmail.Text == "" || metroTextBoxAddress.Text == "" || metroComboBoxGen.Text == "" || metroTextBoxUsername.Text == "" || metroTextBoxPassword.Text == "")
{
MetroMessageBox.Show(this, "Fields cannot be left empty");
}
if (!Regex.Match(metroTextBoxMobileNo.Text, @"^\d{10}$").Success)
{
MetroMessageBox.Show(this, "Please re-enter the contact number", "Warning");
metroTextBoxMobileNo.Focus();
}
if (!Regex.Match(metroTextBoxEmail.Text, @"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,4})+)$").Success)
{
MetroMessageBox.Show(this, "Invalid E-Mail address Please re-enter correct address");
metroTextBoxEmail.Focus();
}
else
{
Student obj = new Student(metroTextBoxStudentId.Text, metroTextBoxFirstName.Text, metroTextBoxLastName.Text, metroTextBoxDOB.Text, metroTextBoxMobileNo.Text, metroTextBoxEmail.Text, metroTextBoxAddress.Text, metroComboBoxGen.Text, metroTextBoxUsername.Text, metroTextBoxPassword.Text);
StudentTransactions tr = new StudentTransactions();
tr.updateStudent(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearStudent();
metroGridStudents.Refresh();
}
}
else if (metroComboBoxOptStd.Text == "Search")
{
Student obj = new Student();
StudentTransactions tr2 = new StudentTransactions();
try
{
obj = tr2.dataFill(metroTextSearch.Text);
metroTextBoxStudentId.Text = obj.getid();
metroTextBoxFirstName.Text = obj.getFirstName();
metroTextBoxLastName.Text = obj.getLastName();
metroTextBoxDOB.Text = obj.getDOB();
metroTextBoxMobileNo.Text = obj.getContactNo();
metroTextBoxEmail.Text = obj.getEmail();
metroTextBoxAddress.Text = obj.getAddress();
metroComboBoxGen.Text = obj.getGender();
metroTextBoxUsername.Text = obj.getUsername();
metroTextBoxPassword.Text = obj.getPassword();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Stafford University Registration System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (metroComboBoxOptStd.Text == "Delete")
{
if (metroGridStudents.Rows.Count == 0)
{
MetroMessageBox.Show(this, "No data found to delete");
}
else
{
DialogResult del = MessageBox.Show("Are you Sure you want to delete :" + metroTextBoxStudentId.Text + "", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (del == DialogResult.Yes)
{
StudentTransactions tr3 = new StudentTransactions();
try
{
tr3.deleteFromStudentModule(metroTextBoxStudentId.Text);
tr3.deleteStudent(metroTextBoxStudentId.Text);
MetroMessageBox.Show(this, "Successfully Deleted");
clearStudent();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Delete Student", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Ok. As per confirmation, this record has not been deleted.");
}
}
}
else
{
MetroMessageBox.Show(this, "Please select a option button to Proceed!");
}
}
