public ActionResult EditActionBaiHoc(BaiHoc hsu)
{
BaiHocDAO dao = new BaiHocDAO();
dao.SuaBH(hsu);
return(RedirectToAction("QLBaiHoc"));
}
public static List <BaiHocDTO> LayDanhSachBaiHocTheoTuan(string strMaTuan)
{
List <BaiHocDTO> KetQua = new List <BaiHocDTO>();
try
{
DataTable DanhSachBai = BaiHocDAO.LayDanhSachBaiTheoTuan(strMaTuan);
int nRow = DanhSachBai.Rows.Count;
for (int i = 0; i < nRow; ++i)
{
BaiHocDTO BaiHoc = new BaiHocDTO();
BaiHoc.Ma = DanhSachBai.Rows[i]["Ma"].ToString();
BaiHoc.MaLoaiMon = DanhSachBai.Rows[i]["MaLoaiMon"].ToString();
BaiHoc.MaTuan = DanhSachBai.Rows[i]["MaTuan"].ToString();
BaiHoc.Ten = DanhSachBai.Rows[i]["Ten"].ToString();
BaiHoc.FileNoiDung = DanhSachBai.Rows[i]["FileNoiDung"].ToString();
BaiHoc.FileAmThanh = DanhSachBai.Rows[i]["FileAmThanh"].ToString();
BaiHoc.FileHinhAnh = DanhSachBai.Rows[i]["FileHinhAnh"].ToString();
KetQua.Add(BaiHoc);
}
}
catch (Exception Ex)
{
throw Ex;
}
return(KetQua);
}
public ActionResult SuaBaiHoc(int id)
{
BaiHocDAO dao = new BaiHocDAO();
BaiHoc bh = dao.FindBaiHocById(id);
return(View(bh));
}
public ActionResult AddBaiHoc(BaiHocDTO hsa)
{
BaiHocDAO dao = new BaiHocDAO();
dao.ThemBH(hsa);
return(RedirectToAction("QLBaiHoc"));
}
public ActionResult XoaBaiHoc(int id)
{
BaiHocDAO dao = new BaiHocDAO();
//BaiHoc bh = dao.FindBaiHocById(id);
dao.XoaBH(id);
return(RedirectToAction("QLBaiHoc"));
}
public ActionResult BaiHoc()
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var model = new BaiHocDAO().ListByGroupId();
return(View(model));
}
}
public ActionResult QLBaiHoc(int?page)
{
int pageNumber = (page ?? 1);
int pageSize = 10;
if (Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
BaiHocDAO dao = new BaiHocDAO();
IQueryable <BaiHoc> hs = dao.DanhSachBaiHoc();
return(View(hs.OrderBy(n => n.MaBH).ToPagedList(pageNumber, pageSize)));
}
}
public JsonResult KiemTraNghia(string txt1, string txt2)
{
BaiHoc bh = new BaiHoc();
//bh.NghiaTu =
BaiHocDAO dao = new BaiHocDAO();
var kq = dao.Kiemtra(txt1, txt2);
//kq = BaiHocDAO().Kiemtra(txt1, txt2);
if (kq == 1)
{
return(Json(new { status = true }));
}
else
{
return(Json(new { status = false }));
}
}
public static BaiHocDTO LayBaiHocTheoMa(string strMaBaiHoc)
{
try
{
BaiHocDTO KetQua = new BaiHocDTO();
DataTable BaiHoc = BaiHocDAO.LayBaiHocTheoMa(strMaBaiHoc);
if (BaiHoc.Rows.Count > 0)
{
KetQua.Ma = BaiHoc.Rows[0]["Ma"].ToString();
KetQua.MaLoaiMon = BaiHoc.Rows[0]["MaLoaiMon"].ToString();
KetQua.MaTuan = BaiHoc.Rows[0]["MaTuan"].ToString();
KetQua.Ten = BaiHoc.Rows[0]["Ten"].ToString();
KetQua.FileHinhAnh = BaiHoc.Rows[0]["FileHinhAnh"].ToString();
KetQua.FileAmThanh = BaiHoc.Rows[0]["FileAmThanh"].ToString();
KetQua.FileNoiDung = BaiHoc.Rows[0]["FileNoiDung"].ToString();
}
return(KetQua);
}
catch (Exception)
{
return(null);
}
}
public ActionResult ChiTietBH(int id)
{
var model = new BaiHocDAO().ListBHID(id);
return(View(model));
}
public static BaiHocDTO LayBaiHoc(string BaiHoc_XML)
{
BaiHocDTO BaiHoc = BaiHocDAO.LayBaiHoc(BaiHoc_XML);
return(BaiHoc);
}
