public List<Student> GetAllStudents()
{
string query = "SELECT * FROM t_student";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
List<Student> studentList = new List<Student>();
SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader();
if (aSqlDataReader != null)
{
while (aSqlDataReader.Read())
{
Student student = new Student();
student.Name = aSqlDataReader["name"].ToString();
student.Email = aSqlDataReader["email"].ToString();
student.ContactNo = aSqlDataReader["contact_no"].ToString();
student.Date = (DateTime) aSqlDataReader["date"];
student.Address = aSqlDataReader["address"].ToString();
student.DeptId =(int) aSqlDataReader["dept_id"];
student.RegNo = aSqlDataReader["reg_no"].ToString();
studentList.Add(student);
}
aSqlDataReader.Close();
aSqlConnection.Close();
}
return studentList;
}
public bool Save(Student student)
{
if (IsEmailAlreadyExist(student.Email))
{
throw new Exception("Email Already Exist");
}
return studentGateway.Save(student) > 0;
}
public int Save(Student student)
{
string query = "INSERT INTO t_student VALUES('" + student.Name + "', '" + student.Email + "', '" + student.ContactNo + "', '" + student.Date + "', '" + student.Address + "', '" + student.DeptId + "','"+ student.RegNo +"')";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
int rowAffected = aSqlCommand.ExecuteNonQuery();
aSqlConnection.Close();
return rowAffected;
}
private void saveButton_Click(object sender, EventArgs e)
{
string name = nameTextBox.Text;
string email = emailTextBox.Text;
string contactNo = contactNoTextBox.Text;
DateTime date = dateTimePicker.Value;
string address = addressTextBox.Text;
int deptId = (int) deptComboBox.SelectedValue;
string regNo = deptComboBox.Text + "-" + date.Year + "-" +
studentManager.CounterStudentByYearAndDept(date.Year, deptId);
Student student = new Student(name, email, contactNo, date, address, deptId,regNo);
try
{
string pattern = null;
pattern = "^([0-9a-zA-Z]([-\\.\\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\\w]*[0-9a-zA-Z]\\.)+[a-zA-Z]{2,9})$";
if (Regex.IsMatch(email, pattern))
{
if (studentManager.Save(student))
{
MessageBox.Show("Successfully Registered");
}
else
{
MessageBox.Show("Registation Failed");
}
}
else
{
MessageBox.Show("Invalid Email Format");
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}