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