public List<Teacher> GetAllTeacher()
{
List<Teacher> teacherList = new List<Teacher>();
string query = "SELECT * FROM t_teacher";
aSqlCommand = new SqlCommand(query, aSqlConnection);
aSqlConnection.Open();
SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader();
while (aSqlDataReader.Read())
{
Teacher teacher = new Teacher();
teacher.Id = (int)aSqlDataReader["id"];
teacher.Name = aSqlDataReader["name"].ToString();
teacher.Address = aSqlDataReader["address"].ToString();
teacher.Email = aSqlDataReader["email"].ToString();
teacher.Contact_No = aSqlDataReader["contact_no"].ToString();
teacher.Designation_id =(int) aSqlDataReader["designation_id"];
teacher.Department_id = (int)aSqlDataReader["department_id"];
teacher.Credit_Taken = (double)aSqlDataReader["credit_taken"];
teacherList.Add(teacher);
}
aSqlDataReader.Close();
aSqlConnection.Close();
return teacherList;
}
public Teacher FindEmail(string email)
{
string query = "SELECT * FROM t_teacher WHERE email='" + email + "'";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
SqlDataReader aSqlDataReader = aSqlCommand.ExecuteReader();
Teacher aTeacher;
if (aSqlDataReader.HasRows)
{
aTeacher = new Teacher();
aSqlDataReader.Read();
aTeacher.Email = aSqlDataReader["email"].ToString();
aSqlDataReader.Close();
aSqlConnection.Close();
return aTeacher;
}
else
{
aSqlDataReader.Close();
aSqlConnection.Close();
return null;
}
}
public CourseAssignToTeacher( int teacherId, int courseId, Department department, Teacher teacher, Course course)
{
Teacher_id = teacherId;
Course_id = courseId;
Department = department;
Teacher = teacher;
Course = course;
}
public void Save(Teacher atTeacher)
{
string query = "INSERT INTO t_teacher VALUES('" + atTeacher.Name + "', '" + atTeacher.Address + "', '" + atTeacher.Email + "', '" + atTeacher.Contact_No + "', '" + atTeacher.Designation_id + "', '" + atTeacher.Department_id + "','" + atTeacher.Credit_Taken + "')";
aSqlConnection.Open();
aSqlCommand = new SqlCommand(query, aSqlConnection);
aSqlCommand.ExecuteNonQuery();
aSqlConnection.Close();
}
public string Save(Teacher teacher)
{
Teacher emailCheck = teacherGateway.FindEmail(teacher.Email);
if (emailCheck==null)
{
teacherGateway.Save(teacher);
return "Teacher Added";
}
return "Email Already Exists";
}
private void saveButton_Click(object sender, EventArgs e)
{
if (nameTextBox.Text == "")
{
MessageBox.Show("insert name value");
return;
}
else if (addressTextBox.Text == "")
{
MessageBox.Show("insert address value");
return;
}
else if (emailTextBox.Text == "")
{
MessageBox.Show("insert email value");
return;
}
else if (contactTextBox.Text == "")
{
MessageBox.Show("insert contact value");
return;
}
else if (creditTextBox.Text == "")
{
MessageBox.Show("insert credit value");
return;
}
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})$";
string email = emailTextBox.Text;
if (Regex.IsMatch(email, pattern))
{
string name = nameTextBox.Text;
string address = addressTextBox.Text;
string contactNo = contactTextBox.Text;
double credit = Convert.ToDouble(creditTextBox.Text);
int deptId = (int)deptComboBox.SelectedValue;
int designationId = (int)designationComboBox.SelectedValue;
Teacher teacher = new Teacher(name, address, email, contactNo, designationId, deptId, credit);
string msg = teacherManager.Save(teacher);
MessageBox.Show(msg);
}
else
{
MessageBox.Show("Not a valid Email address ");
}
}
