/// <summary> /// Sửa thông tin 1 kỳ thi /// </summary> /// <returns>true</returns> public static void UpdateTrangThaiKt(Kythi item) { try { Conn.ExcuteQuerySql("update KYTHI set TrangThai = '"+item.TrangThai+"' WHERE ID = " + item.ID + ""); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Sửa thông tin 1 kỳ thi /// </summary> /// <returns>true</returns> private static void UpdateKyThi(Kythi item) { try { Conn.ExcuteQuerySql("update KYTHI set TenKT = N'" + item.TenKT + "',NgayThi = '" + item.NgayThi + "',TGLamBai = N'" + item.TGLamBai + "',TGBatDau = N'" + item.TGBatDau + "' ,TGKetThuc = N'" + item.TGKetThuc + "', GhiChu = N'"+item.GhiChu+"' WHERE ID = " + item.ID + ""); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Thêm 1 kỳ thi /// </summary> /// <returns></returns> public static bool ThemKyThi(Kythi item) { try { Conn.ExcuteQuerySql("insert into KYTHI(MaKT,TenKT,NgayThi,TGLamBai,TGBatDau,TGKetThuc,GhiChu,TrangThai) values(N'" + item.MaKT + "',N'" + item.TenKT + "','" + item.NgayThi + "',N'" + item.TGLamBai + "',N'" + item.TGBatDau + "',N'" + item.TGKetThuc + "',N'"+item.GhiChu+"',1)"); return true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return false; } }