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 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 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 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 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 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 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 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 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 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 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 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 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 GhiBangTamThiThu(DEMO_RESULT_TEMP t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.DEMO_RESULT_TEMPs.Where(s => (s.stt == t.stt && s.idQuiz == t.idQuiz)).Select(s => s).SingleOrDefault(); if (rs != null) { //đã tồn tại thì sửa rs.answer = t.answer; rs.truefalse = t.truefalse; try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } else { //chưa tồn tại thì thêm httn.DEMO_RESULT_TEMPs.InsertOnSubmit(t); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } } return(rt); }
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); }
public static bool ThemCauHoi(QUIZ qNew) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { httn.QUIZs.InsertOnSubmit(qNew); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } return(rt); }
public static bool ThemGiaoVien(TEACHER t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { httn.TEACHERs.InsertOnSubmit(t); try { httn.SubmitChanges(); } catch { rt = false; } } return(rt); }
public static bool ThemKyThiThu(DEMO_COMPETION t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { httn.DEMO_COMPETIONs.InsertOnSubmit(t); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } return(rt); }
public static bool XoaDeThi(TEST t) { bool rt = true; using (var httn = new DBTracNghiemDataContext()) { var rs = httn.TESTs.Where(s => s.id == t.id && s.subtractID == t.subtractID); httn.TESTs.DeleteAllOnSubmit(rs); try { httn.SubmitChanges(); } catch (Exception) { rt = false; } } return(rt); }