private void button1_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { Student student = new Student { full_name = nameText.Text, username = usernameText.Text, password = PasswordText.Text }; StudentDAO studentDAO = new StudentDAO(); studentDAO.addStudent(student); } if (comboBox1.SelectedIndex == 1) { Teacher teacher = new Teacher { full_name = nameText.Text, username = usernameText.Text, password = PasswordText.Text }; TeacherDAO teacherDAO = new TeacherDAO(); teacherDAO.addTeacher(teacher); } }
public ClassGUI() { InitializeComponent(); classDAO = new ClassDAO(); teacherDAO = new TeacherDAO(); flag = ""; }
public Object GetTeachherByUsername(string name) { TeacherDTO tchr = TeacherDAO.GetTeachherByUsername(name); var Teacher = new { teacher = tchr }; return(Teacher); }
private void deleteButton_Click(object sender, EventArgs e) { int id = Convert.ToInt32(idNumeric.Value); TeacherDAO teacherDAO = new TeacherDAO(); teacherDAO.deleteTeacher(id); }
public ActionResult SignIn(string email, string password, string remember) { if (cookie == null) { cookie = new HttpCookie("loginCookie", "Invalid"); } Object data = null; TeacherDTO d = TeacherDAO.GetTeachherByUsername(email); if (d.TeaPassword == password) { data = new { valid = true, urlToRedirect = "/Teacher/Dashboard" }; cookie.Value = "Valid"; Session["Name"] = d.TeaFirstName + " " + d.TeaLastName; Session["login"] = email; Session["password"] = password; Session["remember"] = remember; cookie.Expires = DateTime.Now.AddHours(24); } else { Session["login"] = null; Session.Abandon(); return(null); } return(Json(data, JsonRequestBehavior.AllowGet)); }
// GET: Admin/Teachers public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { var dao = new TeacherDAO(); var model = dao.ListAllPaging(searchString, page, pageSize); ViewBag.SearchString = searchString; return(View(model)); }
public TeacherSubjectManagement() { InitializeComponent(); sdb = new SubjectDAO(); tdb = new TeacherDAO(); flag = ""; check = false; }
public Teacher GetByID(int IDd) { using (var dao = new TeacherDAO()) { var query = dao.Query(e => true); return(query.Where(e => e.ID == IDd).First().Map()); } }
public TeacherDictantModel(Dictant dictant) { currentTeacher = new TeacherDAO(); currentDictant = dictant; if (currentDictant != null) { currentTeacher.getPositionAndAnswer(currentDictant.ID, out positions, out answers); } }
private void selectButton_Click(object sender, EventArgs e) { TeacherDAO teacherDAO = new TeacherDAO(); var allTeacher = teacherDAO.GetTeachers(); foreach (var item in allTeacher) { richTextBox1.Text += $"Full Name : {item.full_name} Username : { item.username}"; } }
public void ValidateTeacher(Course info) { using (var dao = new TeacherDAO()) { var query = dao.Query(e => true); var qTeacher = query.Where(e => e.ID == info.Teacher.ID); if (!qTeacher.Any()) { throw new Exception(Common.Constants.Messages.PROFESOR_NO_ENCONTRADO); } } }
public JsonResult DeleteTeacher(Teacher teacher) { if (teacher == null) { return(Json(new { Message = "Erro", HasError = true })); } var dao = new TeacherDAO(); var message = dao.DeleteTeacher(teacher); return(Json(new { Message = message })); }
private void insertButton_Click(object sender, EventArgs e) { Teacher teacher = new Teacher { full_name = fullNameText.Text, username = uernameText.Text, password = passwordText.Text }; TeacherDAO teacherDAO = new TeacherDAO(); teacherDAO.addTeacher(teacher); }
public List <Teacher> Get(string text) { using (var dao = new TeacherDAO()) { var query = dao.Query(e => true); if (!string.IsNullOrWhiteSpace(text)) { query = query.Where(e => e.NOMBRE.Contains(text)); } return(query.ToArray().Select(e => e.Map()).ToList()); } }
public ControllerClass() { classDAO = new ClassDAO(); teacherDAO = new TeacherDAO(); pupilDAO = new PupilDAO(); lessonDAO = new LessonDAO(); junctionDAO = new JunctionDAO(); fullTextSearch = new FullTextSearch(); view = new ViewClass(classDAO.GetList(), lessonDAO.GetList()); //DAO<Junction>.RandomDB(classDAO, teacherDAO, lessonDAO, pupilDAO, junctionDAO); }
private void updateButton_Click(object sender, EventArgs e) { Teacher teacher = new Teacher { id = Convert.ToInt32(idNumeric.Value), full_name = fullNameText.Text, username = uernameText.Text, password = passwordText.Text }; TeacherDAO teacherDAO = new TeacherDAO(); teacherDAO.updateTeacher(teacher); }
public static TeacherDTO Login(string User, string Password) { Global.Teacher = TeacherDAO.Login(User, Password); if (Global.Teacher == null) { return(null); } else { string BirthDay = Global.Teacher.DateofBith; StandalizedBirthDayToUI(ref BirthDay); Global.Teacher.DateofBith = BirthDay; return(Global.Teacher); } }
public Course GetByID(int IDd) { using (var dao = new CourseDAO()) { var query = dao.Query(e => true); var courses = query.ToArray(); using (var teaDAO = new TeacherDAO()) { var ids = courses.Select(e => e.IDPROFESOR).Distinct(); var teachers = teaDAO.Query(e => e.ID == IDd).ToArray(); return(courses.Select(e => e.Map(teachers)).First()); } } }
public static List <string> loadListSubjectToComboBoxInSearch(string idTeacher, string nameClass, string schoolYear) { if (TeacherBUS.isMaster(idTeacher, nameClass, schoolYear)) { List <string> temp = SubjectBUS.loadListNameSubject(); List <string> result = new List <string>(); result.Add("All"); for (int i = 0; i < temp.Count; i++) { result.Add(temp[i]); } return(result); } return(TeacherDAO.loadListSubjectToComboBox(idTeacher, nameClass, schoolYear)); }
public static bool changeMyInfomation(string idTeacher, string Name, string Gender, string Email, string Phone, string BirthDay) { if (!marchEmail(Email)) { return(false); } if (!marchBirthDay(BirthDay)) { return(false); } StandalizedBirthDayToDatabase(ref BirthDay); return(TeacherDAO.changeMyInfomation(idTeacher, Name, Gender, Email, Phone, BirthDay)); }
public void ValidateNoDuplicates(Teacher info, bool isNew = true) { using (var dao = new TeacherDAO()) { var query = isNew ? dao.Query(e => true) : dao.Query(e => e.ID != info.ID); var qName = query.Where(e => e.NOMBRE == info.Name); if (qName.Any()) { var qLastName = query.Where(e => e.APELLIDOS == info.LastName); if (qLastName.Any()) { throw new Exception(Common.Constants.Messages.PROFESOR_NOMBRE_REPETIDO); } } } }
public object Delete(Teacher info) { try { ValidateNoTeacherInstan(info); var model = info.Map(); using (var dao = new TeacherDAO()) { return(dao.Delete(model)); } } catch (Exception) { throw; } }
public object Register(Teacher info) { try { ValidateNoDuplicates(info); var model = info.Map(); using (var dao = new TeacherDAO()) { return(dao.Register(model)); } } catch (Exception) { throw; } }
public object Modify(Teacher info) { try { ValidateNoDuplicates(info, false); var model = info.Map(); using (var dao = new TeacherDAO()) { return(dao.Modify(model)); } } catch (Exception) { throw; } }
public JsonResult ListTeacher(Teacher teacher) { if (teacher == null) { return(Json(new { Message = "Error", HasError = true })); } var dao = new TeacherDAO(); var List = dao.ListTeacher(); if (!List.Any()) { return(Json(new { Message = "No entry found" })); } return(Json(List, JsonRequestBehavior.AllowGet)); }
private void LoadTeacher() { TeacherDAO cd = new TeacherDAO(); DataSet set = cd.GetAllTeacher(); foreach (DataRow r in set.Tables[0].Rows) { DataRow newRow = tabTeacher.NewRow(); newRow["Id"] = r["Id"]; newRow["StaffNumber"] = r["StaffNumber"]; newRow["Name"] = r["Name"]; newRow["Status"] = "Added"; tabTeacher.Rows.Add(newRow); } gridCtrlTeacher.DataSource = tabTeacher; }
public ActionResult SearchTeacher(string strKeyWord, int intSubjectID, bool bolIsBlock, int intPageIndex = 0) { try { //Lấy config số trang hiển thị trên thanh phân trang int intVisiblePages = Convert.ToInt32(ConfigurationManager.AppSettings["visiblePages"]); int intTotalPages = 0; int intTotalRows = 0; //Gen HTML StringBuilder strHTMLTeacher = new StringBuilder(); DataTable dtbTeacher = new TeacherDAO().SearchTeacher(strKeyWord, intPageIndex, intVisiblePages, intSubjectID, bolIsBlock); if (dtbTeacher != null && dtbTeacher.Rows.Count > 0) { strHTMLTeacher = GenHTMLTeacher(dtbTeacher); //Lấy tổng số lưởng dòng intTotalRows = Convert.ToInt32(dtbTeacher.Rows[0]["TotalRows"]); //Lấy tổng số lượng trang intTotalPages = intTotalRows / intVisiblePages; //Trường hợp số phần tử không chia hết cho intVisiblePages if (intTotalRows % intVisiblePages != 0) { intTotalPages = intTotalPages + 1; } } else { strHTMLTeacher.Append("<tr><td colspan='12' class='table-content-null'>Hiện không có nội dung</td></tr>"); } return(Json(new { iserror = false, content = Convert.ToString(strHTMLTeacher), totalpages = intTotalPages, totalrows = intTotalRows })); } catch { return(Json(new { iserror = true })); } }
public void ValidateMaxTeacherCourses(Course info) { using (var dao = new TeacherDAO()) { var query = dao.Query(e => true); var qTeacher = query.Where(e => e.ID == info.Teacher.ID).First().Map(); if (!qTeacher.HasPlaza) { using (var coursedao = new CourseDAO()) { var coursequery = coursedao.Query(e => true); var qCourse = coursequery.Where(e => e.IDPROFESOR == info.Teacher.ID).ToArray(); if (qCourse.Length >= Common.Constants.Constants.MAX_TEACHER_CURSOS) { throw new Exception(Common.Constants.Messages.PROFESOR_MAXIMO_MATERIAS); } } } } }
private void simpleButtonOK_Click(object sender, EventArgs e) { TeacherDAO d = new TeacherDAO(); TeacherBean b = new TeacherBean(); foreach (DataRow r in tabTeacher.Rows) { b.StaffNumber = r["StaffNumber"].ToString(); b.Id = Convert.ToInt32(r["Id"].ToString()); string status = r["Status"].ToString(); if (status == "Adding") { d.AddTeacher(b); } else if (status == "Deleting") { d.DeleteTeacher(b); } } }
public List <Course> Get(string text) { using (var dao = new CourseDAO()) { var query = dao.Query(e => true); if (!string.IsNullOrWhiteSpace(text)) { query = query.Where(e => e.NOMBRE.Contains(text)); } var courses = query.ToArray(); var coursesLe = courses.Length; using (var teadao = new TeacherDAO()) { var ids = courses.Select(e => e.IDPROFESOR).Distinct(); var teachers = teadao.Query(e => ids.Contains(e.ID)).ToArray(); return(courses.Select(e => e.Map(teachers)).ToList()); } } }