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 "); } }