public static bool DoiMatKhauGiaoVien(int ID, string pass) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.TEACHERs.Where(s => s.ID == ID).Select(s => s).SingleOrDefault(); if (rs != null) { rs.teacherPassword = pass; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool SuaKyThiThat(COMPETION cEdit) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.COMPETIONs.Where(s => (s.id == cEdit.id && s.subtractID == cEdit.subtractID)).SingleOrDefault(); if (rs != null) { rs.testTimeToLive = cEdit.testTimeToLive; rs.testDateBegin = cEdit.testDateBegin; rs.gradeid = cEdit.gradeid; rs.idtest = cEdit.idtest; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool DoiMatKhauHocSinh(int ID, string pass) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.STUDENTs.Where(s => s.id == ID).Select(s => s).SingleOrDefault(); if (rs != null) { rs.studentPassword = pass; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool SuaThongTinGiaoVien(int id, string ten, string mail, DateTime t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.TEACHERs.Where(s => s.ID == id).Select(s => s).SingleOrDefault(); if (rs != null) { rs.teacherFullname = ten; rs.teacherEmail = mail; rs.teacherBirthday = t; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool XoaCauHoi(int id, string maMon) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.QUIZs.Where(s => (s.id == id && s.idSubtract.Trim() == maMon)).Select(s => s).SingleOrDefault(); if (rs != null) { httn.QUIZs.DeleteOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool SuaCauHoi(QUIZ qEdit) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var s = httn.QUIZs.Where(t => (t.id == qEdit.id && t.idSubtract == qEdit.idSubtract)).Select(t => t).SingleOrDefault(); if (s != null) { s.quizz = qEdit.quizz; s.a = qEdit.a; s.b = qEdit.b; s.c = qEdit.c; s.d = qEdit.d; s.answer = qEdit.answer; s.rateHard = qEdit.rateHard; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool SuaThongTinHocSinh(int id, string hoten, string email, DateTime db) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.STUDENTs.Where(s => s.id == id).Select(s => s).SingleOrDefault(); if (rs != null) { rs.studentFullname = hoten; rs.studentEmail = email; rs.studentBirthday = db; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool XoaBoDeThi(TEST t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { //lấy 1 test_detail var rs = httn.TEST_DETAILs.Where(s => (s.testID == t.id && s.subtractID == t.subtractID)); if (rs != null) { httn.TEST_DETAILs.DeleteAllOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool XoaBangTamThiThu() { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.DEMO_RESULT_TEMPs.Select(s => s); if (rs != null) { httn.DEMO_RESULT_TEMPs.DeleteAllOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool GhiKetQuaLai(RESULT t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.RESULTs.Where(s => s.idCom == t.idCom && s.idStudent == t.idStudent && s.idSubtract == t.idSubtract).SingleOrDefault(); if (rs != null) { rs.score = t.score; } else { httn.RESULTs.InsertOnSubmit(t); } try { httn.SubmitChanges(); } catch { rt = false; } } return(rt); }
public static bool XoaBangTam(int idc, int ids, string idsub) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.RESULT_TEMPs.Where(s => (s.idCompe == idc && s.idStudent == ids && s.idSubtract == idsub)).Select(s => s); if (rs != null) { httn.RESULT_TEMPs.DeleteAllOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool XoaKyThiThu(int code, string subtract) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.DEMO_COMPETIONs.Where(s => (s.demoCompID == code && s.subtractID == subtract)).Select(s => s).SingleOrDefault(); if (rs != null) { httn.DEMO_COMPETIONs.DeleteOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static bool SuaKyThiThu(DEMO_COMPETION t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.DEMO_COMPETIONs.Where(s => (s.demoCompID == t.demoCompID && s.subtractID == t.subtractID)).SingleOrDefault(); if (rs != null) { rs.expDate = t.expDate; rs.gradeid = t.gradeid; rs.iddemotest = t.iddemotest; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { rt = false; } } return(rt); }
public static IList <DEMO_TEST_DETAIL> LayDanhSachCauHoiTrongDeThiThu(string mamon, int made) { IList <DEMO_TEST_DETAIL> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.DEMO_TEST_DETAILs.Where(s => s.demoIdTest == made & s.subtractID.Trim() == mamon.Trim()).ToList(); } return(rt); }
public static IList <DEMO_TEST> LayDanhSachDeThiThu() { IList <DEMO_TEST> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.DEMO_TESTs.ToList(); } return(rt); }
public static IList <TEACHER> LayDanhSachGiaoVien() { IList <TEACHER> rs; using (var httn = new DBTracNghiemDataContext()) { rs = httn.TEACHERs.ToList(); } return(rs); }
public static IList <RESULT> LayDanhSachKetQua() { IList <RESULT> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.RESULTs.ToList(); } return(rt); }
public static int SoCauTraLoiDungThiThu() { int rt = 0; using (var httn = new DBTracNghiemDataContext()) { rt = httn.DEMO_RESULT_TEMPs.Where(s => (s.truefalse == true)).Count(); } return(rt); }
public static IList <TEST_DETAIL> LayDeThi() { IList <TEST_DETAIL> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.TEST_DETAILs.ToList(); } return(rt); }
public static int SoCauTraLoiDung(int ids, int idc) { int rt = 0; using (var httn = new DBTracNghiemDataContext()) { rt = httn.RESULT_TEMPs.Where(s => (s.idCompe == idc && s.idStudent == ids && s.truefalse == true)).Count(); } return(rt); }
public static IList <DEMO_COMPETION> LayDanhSachKyThiThu() { IList <DEMO_COMPETION> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.DEMO_COMPETIONs.ToList(); } return(rt); }
public static IList <GUEST> LayDanhSachGuest() { IList <GUEST> rt; using (var httn = new DBTracNghiemDataContext()) { rt = httn.GUESTs.ToList(); } return(rt); }
public static IList <TEST> LayDanhSachDeThi() { IList <TEST> rs; using (var httn = new DBTracNghiemDataContext()) { rs = httn.TESTs.ToList(); } return(rs); }
public static IList <COMPETION> LayDanhSachKyThi() { IList <COMPETION> rs; using (var httn = new DBTracNghiemDataContext()) { rs = httn.COMPETIONs.ToList(); } return(rs); }
public static IList <STUDENT> LayDanhSachHocSinh() { IList <STUDENT> rs; using (var httn = new DBTracNghiemDataContext()) { httn.DeferredLoadingEnabled = false; rs = httn.STUDENTs.ToList(); } return(rs); }
public static IList <GRADE> LayDanhSachKhoi() { IList <GRADE> rs; using (var httn = new DBTracNghiemDataContext()) { httn.DeferredLoadingEnabled = false; rs = httn.GRADEs.ToList(); } return(rs); }
public static IList <TYPE> LayDanhSachLoaiTaiKhoan() { IList <TYPE> rs; using (var httn = new DBTracNghiemDataContext()) { httn.DeferredLoadingEnabled = false; rs = httn.TYPEs.ToList(); } return(rs); }
public static IList <SUBTRACT> LayDanhSachMonHoc() { IList <SUBTRACT> rs; using (var httn = new DBTracNghiemDataContext()) { httn.DeferredLoadingEnabled = false; rs = httn.SUBTRACTs.ToList(); } return(rs); }
public static IList <LEVELQUIZ> LayDanhSachDoKho() { IList <LEVELQUIZ> rs; using (var httn = new DBTracNghiemDataContext()) { httn.DeferredLoadingEnabled = false; rs = httn.LEVELQUIZs.ToList(); } return(rs); }
public static bool ThemDeThi(TEST t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { httn.TESTs.InsertOnSubmit(t); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } return(rt); }