private void btnXML_Click(object sender, EventArgs e)
{
XmlSerializer serialiser;
XmlWriter xmlWriter;
string filePath = string.Empty;
SaveFileDialog sfd = new SaveFileDialog();
string stID = txtStuNumber.Text;
string fname = txtEditStuFN.Text;
string sname = txtEditStuSN.Text;
string em = txtEditStuEmail.Text;
string ph = txtEditStuPhone.Text;
string add1 = txtEditStuAdd1.Text;
string add2 = txtEditStuAdd2.Text;
string city = txtEditStuCity.Text;
string county = cbEditStCounty.SelectedItem.ToString();
string level = "UnderGrad";
if (rboEditStuUnderGrad.Checked)
{
level = "UnderGrad";
}
else if (rboEditStuPostGrad.Checked)
{
level = "PostGrad";
}
string course = cbEditStuCourses.Text;
AddNewStudent ns = new AddNewStudent(fname, sname, em, ph, add1, add2, city, county, level, course);
if (ns.Validate())
{
sfd.InitialDirectory = "C:\\";
sfd.Filter = "xml files (*.xml)|*.xml";
if (sfd.ShowDialog() == DialogResult.OK)
{
filePath = sfd.FileName;
serialiser = new XmlSerializer(typeof(AddNewStudent));
xmlWriter = XmlWriter.Create(filePath);
serialiser.Serialize(xmlWriter, ns);
MessageBox.Show("XML saved");
}
else
{
MessageBox.Show("Invalid details entered.Please check");
}
}
}
public EditEntry(AddNewStudent Edit)
{
InitializeComponent();
curID = Edit.StudentID;
txtStuNumber.Text = curID.ToString();
txtEditStuFN.Text = Edit.StudentFN;
txtEditStuSN.Text = Edit.StudentSN;
txtEditStuEmail.Text = Edit.StudentEmail;
txtEditStuPhone.Text = Edit.StudentPhone;
txtEditStuAdd1.Text = Edit.StudentAdd1;
txtEditStuAdd2.Text = Edit.StudentAdd2;
txtEditStuCity.Text = Edit.StudentCity;
cbEditStCounty.Text = Edit.StudentCounty;
if (Edit.StudentAcademicLevel.Equals("PostGrad"))
{
this.rboEditStuPostGrad.Select();
}
cbEditStuCourses.Text = Edit.StudentAcademicCourse;
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
if (txtAddStuFN.Text == string.Empty || txtAddStuSN.Text == string.Empty ||
txtAddStuEmail.Text == string.Empty || txtAddStuAdd1.Text == string.Empty ||
txtAddStuAdd2.Text == string.Empty || txtAddStuCity.Text == string.Empty ||
cbAddStCounty.Text == string.Empty || cbAddStuCourses.Text == string.Empty)
{
MessageBox.Show("Please make sure text Fields are not blank");
return;
}
else if (txtAddStuPhone.Text == string.Empty)
{
MessageBox.Show("Please make sure Phone Number format is correct 087123456 or 011234567");
return;
}
else
{
string fname = txtAddStuFN.Text;
string sname = txtAddStuSN.Text;
string em = txtAddStuEmail.Text;
string ph = txtAddStuPhone.Text;
string add1 = txtAddStuAdd1.Text;
string add2 = txtAddStuAdd2.Text;
string city = txtAddStuCity.Text;
string county = cbAddStCounty.Text;
string level = "UnderGrad";
if (rboAddStuUnderGrad.Checked)
{
level = "UnderGrad";
}
else if (rboAddStuPostGrad.Checked)
{
level = "PostGrad";
}
string course = cbAddStuCourses.Text;
AddNewStudent ns = new AddNewStudent(fname, sname, em, ph, add1, add2, city, county, level, course);
if (ns.Validate())
{
ns.AddStuToDB();
MessageBox.Show("Student Database Updated");
txtAddStuFN.Clear();
txtAddStuSN.Clear();
txtAddStuEmail.Clear();
txtAddStuPhone.Clear();
txtAddStuAdd1.Clear();
txtAddStuAdd2.Clear();
txtAddStuCity.Clear();
cbAddStCounty.ResetText();
cbAddStuCourses.ResetText();
this.Close();
}
else
{
MessageBox.Show("Invalid details entered.Please check");
}
}
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
XmlSerializer serialiser;
XmlWriter xmlWriter;
string filePath = string.Empty;
string fname = txtFirstName.Text;
string lname = txtSurname.Text;
string email = txtEmail.Text;
string phone = txtPhone.Text;
string address1 = txtAdrline1.Text;
string address2 = txtAdrline2.Text;
string city = txtCity.Text;
string county = comboBoxCounties.SelectedItem.ToString();
string course = comboCourses.SelectedItem.ToString();
string mobileRegularExpression = ConfigurationManager.AppSettings["MobRegEx"];
try
{
int studentNumber = int.Parse(txStudentNumber.Text);
string level = "";
if (radioUnder.Checked)
{
level = "Undergraduate";
}
else if (radioPost.Checked)
{
level = "Postgraduate";
}
AddNewStudent addNewStudent = new AddNewStudent(fname, lname, email, phone, address1, address2, city, county, level, course, studentNumber);
addNewStudent.AddStudentToDB();
saveFileDialog.InitialDirectory = "C:\\";
saveFileDialog.Filter = "xml files (*.xml)|*.xml";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
filePath = saveFileDialog.FileName;
serialiser = new XmlSerializer(typeof(AddNewStudent));
xmlWriter = XmlWriter.Create(filePath);
serialiser.Serialize(xmlWriter, addNewStudent);
}
else
{
MessageBox.Show("Student details not serialised!");
}
MessageBox.Show("Student successfully added to database!");
this.Hide();
Menu menu1 = new Menu();
menu1.Show();
}
catch (Exception)
{
MessageBox.Show("A student number must have 8 digits. Please enter a valid student number.");
this.Hide();
AddStudent addStudent = new AddStudent();
addStudent.Show();
}
}
private void btnAddStudentAdd_Click(object sender, EventArgs e)
{
int studentId = int.Parse(txtAddStudentSNumber.Text);
string fname = txtAddStudentFirstName.Text;
string surname = txtAddStudentSurname.Text;
string email = txtAddStudentEmail.Text + "@mydbs.ie";
string phone = txtAddStudentPhone.Text;
string addressLine1 = txtAddStudentAddress1.Text;
string addressLine2 = txtAddStudentAddress2.Text;
string city = txtAddStudentCity.Text;
string county = cbAddStudentCounty.SelectedItem.ToString();
string course = cbAddStudentCourse.Text;
string level = "Undergraduate";
if (rdoAddStudentUndergrad.Checked)
{
level = "Undergraduate";
}
else if (rdoAddStudentPostgrad.Checked)
{
level = "Postgraduate";
}
AddNewStudent addNewStudent = new AddNewStudent(studentId, fname, surname, email, phone, addressLine1, addressLine2,
city, county, level, course);
addNewStudent.AddNewStudentToDB();
////----------Move to Correct Tier
//MemoryStream memoryStream = new MemoryStream();
//imgAddStudentPicture.Image.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Jpeg);
//imgAddStudentPicture.Image.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Png);
//byte[] picture = new byte[memoryStream.Length];
//memoryStream.Position = 0;
//memoryStream.Read(picture, 0, picture.Length);
//DAO dao = new DAO();
//SqlCommand command = new SqlCommand("INSERT INTO students (images) VALUES (@img)", dao.OpenConnection());
//command.Parameters.AddWithValue("@img", picture);
//command.ExecuteNonQuery();
//dao.CloseConnection();
////-----------End of Image
MessageBox.Show("Student Added to Database");
txtAddStudentSNumber.Clear();
txtAddStudentFirstName.Clear();
txtAddStudentSurname.Clear();
txtAddStudentCity.Clear();
txtAddStudentEmail.Clear();
txtAddStudentPhone.Clear();
txtAddStudentAddress1.Clear();
txtAddStudentAddress2.Clear();
txtAddStudentCity.Clear();
cbAddStudentCounty.ResetText();
//imgAddStudentPicture.ResetText();
rdoAddStudentPostgrad.Checked = false;
rdoAddStudentUndergrad.Checked = false;
cbAddStudentCourse.ResetText();
}
