public static List <Student> getAllStudent(string student) { using (var _context = new DBProjectStudentEntities()) { var students = (from t in _context.Students.AsEnumerable() where t.S_name.Contains(student) select new { S_ID = t.S_ID, S_name = t.S_name, S_fullname = t.S_fullname, S_major = t.S_major, S_gender = t.S_gender, S_birthday = t.S_birthday, S_phone = t.S_phone, S_email = t.S_email, }).Select(x => new Student { S_ID = x.S_ID, S_name = x.S_name, S_fullname = x.S_fullname, S_major = x.S_major, S_gender = x.S_gender, S_birthday = x.S_birthday, S_phone = x.S_phone, S_email = x.S_email, }); return(students.ToList()); } }
public static Student findStudentbySID(string idStudent) { using (var _context = new DBProjectStudentEntities()) { return(_context.Students.SingleOrDefault(s => s.S_ID == idStudent)); } }
public static List <Project> getAllProject() { using (var _context = new DBProjectStudentEntities()) { var project = (from t in _context.Projects.AsEnumerable() select new { P_ID = t.P_ID, P_title = t.P_title, P_description = t.P_description, P_fromtime = t.P_fromtime, P_totime = t.P_totime, P_point = t.P_point, //Students = t.Students, L_ID = t.L_ID, Lecture = t.Lecture }).Select(x => new Project { P_ID = x.P_ID, P_title = x.P_title, P_description = x.P_description, P_fromtime = x.P_fromtime, P_totime = x.P_totime, P_point = x.P_point, //Students = x.Students, L_ID = x.L_ID, Lecture = x.Lecture }); return(project.ToList()); } }
public static List <Progress> getAllProgress() { using (var _context = new DBProjectStudentEntities()) { var progress = (from t in _context.Progresses.AsEnumerable() select new { STT = t.STT, P_ID = t.P_ID, S_ID = t.S_ID, ProgressName = t.ProgressName, LinkSource = t.LinkSource, Note = t.Note, }).Select(x => new Progress { STT = x.STT, P_ID = x.P_ID, S_ID = x.S_ID, ProgressName = x.ProgressName, LinkSource = x.LinkSource, Note = x.Note, }); return(progress.ToList()); } }
public static List <Lecture> getAllLecture(string lecture) { using (var _context = new DBProjectStudentEntities()) { var lectures = (from t in _context.Lectures.AsEnumerable() where t.L_name.Contains(lecture) select new { L_ID = t.L_ID, L_name = t.L_name, L_fullname = t.L_fullname, L_department = t.L_department, L_gender = t.L_gender, L_birthday = t.L_birthday, L_phone = t.L_phone, L_email = t.L_email, }).Select(x => new Lecture { L_ID = x.L_ID, L_name = x.L_name, L_fullname = x.L_fullname, L_department = x.L_department, L_gender = x.L_gender, L_birthday = x.L_birthday, L_phone = x.L_phone, L_email = x.L_email, }); return(lectures.ToList()); } }
public static Student getStudentInfomationAfterLogin(string idLogin) { using (var _context = new DBProjectStudentEntities()) { return(_context.Students.SingleOrDefault(s => s.IDLogin == idLogin)); } }
public static List <Student> getAllStudentbyIDproject(int idproject) { using (var _context = new DBProjectStudentEntities()) { return(_context.ProjectManagements.Where(pm => pm.P_ID == idproject).Select(s => s.Student).ToList()); //dung List<Student>; } }
public static List <Progress> listProgressOfStudent(int P_ID, string S_ID) { using (var _context = new DBProjectStudentEntities()) { var student = _context.Progresses.Where(p => p.P_ID == P_ID && p.S_ID == S_ID).ToList(); return(student); } }
public static List <Student> getStudentDetail() { using (var _context = new DBProjectStudentEntities()) { var student = _context.Students.ToList(); return(student); } }
public static bool addLecture(Lecture lecture) { using (var _context = new DBProjectStudentEntities()) { _context.Lectures.Add(lecture); _context.SaveChanges(); return(true); } }
public static bool addProgress(Progress progress) { using (var _context = new DBProjectStudentEntities()) { _context.Progresses.Add(progress); _context.SaveChanges(); return(true); } }
public static bool addStudent(Student student) { using (var _context = new DBProjectStudentEntities()) { _context.Students.Add(student); _context.SaveChanges(); return(true); } }
public static bool addProjectStudent(ProjectManagement projectM) { using (var _context = new DBProjectStudentEntities()) { _context.ProjectManagements.Add(projectM); _context.SaveChanges(); return(true); } }
public static string getIDfromDB() { using (var _context = new DBProjectStudentEntities()) { var listid = (from t in _context.Lectures select t.L_ID).ToList(); //return int.Parse(listid.Max()) + 1; return(listid.ToString()); } }
public static bool DeleteStudent(string idStudent) { using (var _context = new DBProjectStudentEntities()) { var Student = (from x in _context.Students where x.S_ID == idStudent select x).Single(); _context.Students.Remove(Student); _context.SaveChanges(); return(true); } }
public static bool DeleteProject(int idproject) { using (var _context = new DBProjectStudentEntities()) { var project = (from x in _context.Projects where x.P_ID == idproject select x).Single(); _context.Projects.Remove(project); _context.SaveChanges(); return(true); } }
public static bool DeleteLecture(string idLecture) { using (var _context = new DBProjectStudentEntities()) { var lecture = (from x in _context.Lectures where x.L_ID == idLecture select x).Single(); _context.Lectures.Remove(lecture); _context.SaveChanges(); return(true); } }
public static bool DeleteProjectStudent(int idproject, string idstudent) { using (var _context = new DBProjectStudentEntities()) { var student = (from x in _context.ProjectManagements where x.S_ID == idstudent && x.P_ID == idproject select x).SingleOrDefault(); _context.ProjectManagements.Remove(student); _context.SaveChanges(); return(true); } }
public static bool DeleteProgress(string stt) { using (var _context = new DBProjectStudentEntities()) { var progress = (from x in _context.Progresses where x.STT == stt select x).Single(); _context.Progresses.Remove(progress); _context.SaveChanges(); return(true); } }
public static bool UpdateProgress(Progress progressadd) { using (var _context = new DBProjectStudentEntities()) { var progress = (from u in _context.Progresses where u.STT == progressadd.STT select u).Single(); progress.ProgressName = progressadd.ProgressName; progress.LinkSource = progressadd.LinkSource; progress.Note = progressadd.Note; //_context.Projects.Add(project); _context.SaveChanges(); return(true); } }
private List <string> getIDLecture() { List <string> lectures = new List <string>(); using (var _context = new DBProjectStudentEntities()) { var listid = (from t in _context.Lectures select t.L_ID).ToList(); foreach (var a in listid) { lectures.Add(a); } } return(lectures); }
public static bool checkUser(string username, string password) { using (var _context = new DBProjectStudentEntities()) { var check = from t in _context.UserLogins where (username == t.ID) && (password == t.Pass) select t.ID; foreach (var a in check) { if (a.Length != 0) { return(true); } } return(false); } }
public static bool UpdateProject(Project projectadd) { using (var _context = new DBProjectStudentEntities()) { var project = (from u in _context.Projects where u.P_ID == projectadd.P_ID select u).SingleOrDefault(); project.P_title = projectadd.P_title; project.P_description = projectadd.P_description; project.P_fromtime = projectadd.P_fromtime; project.P_totime = projectadd.P_totime; project.P_point = projectadd.P_point; project.L_ID = projectadd.L_ID; //_context.Projects.Add(project); _context.SaveChanges(); return(true); } }
public static List <ProjectManagement> getAllProjectStudent() { using (var _context = new DBProjectStudentEntities()) { var project = (from t in _context.ProjectManagements.AsEnumerable() select new { P_ID = t.P_ID, S_ID = t.S_ID, Student = t.Student }).Select(x => new ProjectManagement { P_ID = x.P_ID, S_ID = x.S_ID, Student = x.Student }); return(project.ToList()); } }
public static bool UpdateLecture(Lecture lectureadd) { using (var _context = new DBProjectStudentEntities()) { var lecture = (from l in _context.Lectures where l.L_ID == lectureadd.L_ID select l).SingleOrDefault(); lecture.L_name = lectureadd.L_name; lecture.L_fullname = lectureadd.L_fullname; lecture.L_department = lectureadd.L_department; lecture.L_gender = lectureadd.L_gender; lecture.L_birthday = lectureadd.L_birthday; lecture.L_phone = lectureadd.L_phone; lecture.L_email = lectureadd.L_email; //_context.Users.AddOrUpdate(user); _context.SaveChanges(); return(true); } }
public static bool UpdateStudent(Student studentadd) { using (var _context = new DBProjectStudentEntities()) { var student = (from s in _context.Students where s.S_ID == studentadd.S_ID select s).SingleOrDefault(); student.S_name = studentadd.S_name; student.S_fullname = studentadd.S_fullname; student.S_major = studentadd.S_major; student.S_gender = studentadd.S_gender; student.S_birthday = studentadd.S_birthday; student.S_phone = studentadd.S_phone; student.S_email = studentadd.S_email; //_context.Users.AddOrUpdate(user); _context.SaveChanges(); return(true); } }
public static int getIDfromDB() { using (var _context = new DBProjectStudentEntities()) { var listid = (from t in _context.Students select t.S_ID).ToList(); //return int.Parse(listid.Max()) + 1; string maxID = listid.Max() + 1; int i; for (i = 1; i < int.Parse(maxID); i++) { if (listid.Where(x => x == i.ToString()).Count() <= 0) { return(i); } } return(i + 1); } }
public static string getROLL(string username, string password) { string temp1 = "0"; string temp2 = "1"; using (var _context = new DBProjectStudentEntities()) { var check = from t in _context.UserLogins where (username == t.ID) && (password == t.Pass) select t; foreach (var a in check) { if (a.roleuser == "0") { return(temp1); } if (a.roleuser == "1") { return(temp2); } } return("NOTHING"); } }