public ActionResult ChitietbaitapSubmit(List <TraLoi> tralois, HttpPostedFileBase file, int idbt)
{
var hv = new HocVienDAO().FindByTDN(User.Identity.Name);
DateTime now = DateTime.Now;
DateTime tsubmit = DateTime.Parse(Session[idbt.ToString()].ToString());
double phut = tsubmit.Subtract(now).TotalMinutes;
if (file != null && file.ContentLength > 0)
{
var dao = new fileTraLoiDAO();
string _FileName = Path.GetFileName(file.FileName);
string path = "Content/Data/traloi/hv" + hv.id + "/bt" + idbt + "/";
string _path = Path.Combine(Server.MapPath("~/" + path), _FileName);
Directory.CreateDirectory(Path.Combine(Server.MapPath("~/" + path)));
file.SaveAs(_path);
int fileSize = file.ContentLength;
int Size = fileSize / 1000000;
var filetl = new fileTraLoi();
filetl.ten = _FileName;
filetl.FileSize = Size;
filetl.link = "~/" + _FileName;
filetl.idBT = idbt;
filetl.thoiGian = DateTime.Now;
filetl.idHV = hv.id;
filetl.trangThai = 1; //0:dong 1:mo
filetl.tgLamBai = Convert.ToInt32(phut);
dao.Insert(filetl);
}
//else
//{
// var dao = new fileTraLoiDAO();
// var filetl = new fileTraLoi();
// filetl.idBT = idbt;
// filetl.thoiGian = DateTime.Now;
// filetl.idHV = hv.id;
// filetl.trangThai = 1; //0:dong 1:mo
// dao.Insert(filetl);
//}
var daotl = new TraLoiDAO();
foreach (var item in tralois)
{
var tl = new TraLoi();
tl.idCauHoi = item.idCauHoi;
tl.DapAn = item.DapAn;
tl.idHV = hv.id;
tl.thoiGian = DateTime.Now;
tl.tgLamBai = Convert.ToInt32(phut);
daotl.Insert(tl);
}
TempData["testmsg"] = "Nộp bài thành công.";
Session.Clear();
return(RedirectToAction("Chitietbaitap", "Learning", new { idbt = idbt }));
//return RedirectToAction("Index", "Learning");
}
public ActionResult PostReply(TraLoi tl)
{
TraLoi info = (TraLoi)Session["NguoiDung"];
tl.NguoiDung = info.NguoiDung;
tl.NgayDang = DateTime.Now;
db.TraLois.Add(tl);
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
public bool Update(TraLoi entity)
{
try
{
var tl = db.TraLois.Find(entity.ID);
db.SaveChanges();
return(true);
}catch (Exception ex)
{
return(false);
}
}
public ActionResult ThemTraLoi(TraLoi tl)
{
KhachHang info = (KhachHang)Session["kh"];
if (info == null)
{
return(Redirect(Request.UrlReferrer.ToString()));
}
tl.MaNguoiDung = info.MaKhachHang;
tl.NgayDang = DateTime.Now;
db.TraLois.Add(tl);
db.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
public IActionResult ReplyComment(string userId, string maBl, string maSp, IFormCollection fc)
{
if (!string.IsNullOrEmpty(fc["ReplyComment"].ToString()))
{
TraLoi tl = new TraLoi()
{
MaBinhLuan = maBl,
NoiDung = fc["ReplyComment"],
MaKh = userId,
NgayDang = DateTime.Now
};
context.TraLoi.Add(tl);
context.SaveChanges();
return(RedirectToAction("SanPham", "SanPham", new { Id = maSp }));
}
else
{
return(RedirectToAction("SanPham", "SanPham", new { Id = maSp }));
}
}
public ActionResult Chitietbaitap(int idbt)
{
var dao = new BaiTapDAO();
var model = dao.GetByID(idbt);
ViewBag.CountSubmit = dao.CountSubmit(idbt);
var hv = new HocVienDAO().FindByTDN(User.Identity.Name);
ViewBag.hv = hv;
List <TraLoi> tralois = new List <TraLoi>();
foreach (var i in model.CauHois)
{
var tl = new TraLoi();
tl.CauHoi = i;
tl.idCauHoi = i.ID;
tl.HocVien = hv;
tl.idHV = hv.id;
tralois.Add(tl);
}
ViewBag.tralois = tralois;
string d = null;
DateTime timenop;
int timeLam = 0;
if (hv.fileTraLois.Where(x => x.idBT == idbt).Count() > 0 || hv.TraLois.Where(x => x.CauHoi.idBT == idbt).Count() > 0)
{
d = new TraLoiDAO().Diem(idbt, hv.id);
try
{
timenop = hv.fileTraLois.Where(x => x.idBT == idbt).FirstOrDefault().thoiGian;
ViewBag.timenop = timenop;
timeLam = Convert.ToInt32(hv.fileTraLois.Where(x => x.idBT == idbt).FirstOrDefault().tgLamBai);
ViewBag.timeLam = timeLam;
}
catch
{
timenop = hv.TraLois.Where(x => x.CauHoi.idBT == idbt).FirstOrDefault().thoiGian;
ViewBag.timenop = timenop;
timeLam = Convert.ToInt32(hv.TraLois.Where(x => x.CauHoi.idBT == idbt).FirstOrDefault().tgLamBai);
ViewBag.timeLam = timeLam;
}
}
ViewBag.diem = d;
ViewBag.timeLam = timeLam;
if (string.IsNullOrEmpty(Session[idbt.ToString()] as string))
{
try
{
DateTime dt = DateTime.Now.AddMinutes(double.Parse(model.thoiGianLamBai.ToString()));
Session[idbt.ToString()] = dt.ToString();
}
catch
{
Session[idbt.ToString()] = "";
}
}
string ttt = Session[idbt.ToString()].ToString();
return(View("Chitietbaitap", model));
}
public int Insert(TraLoi entity)
{
db.TraLois.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public ActionResult ChoKiemTRa(Admin admin)
{
int?dotthi = db.CauHois.Where(x => x.ID == 1).FirstOrDefault().DotThi + 1;
db.TraLois.RemoveRange(db.TraLois.ToList());
db.CauHois.RemoveRange(db.CauHois.ToList());
db.SaveChanges();
FileInfo filecauhoi = new FileInfo("D:/DATN/Project_BDS/PBDS/PBDS/Cauhoi_Excel/test.xlsx");
var listcauhoi = new List <CauHoi>();
var listtraloi = new List <TraLoi>();
if ((filecauhoi != null) && !string.IsNullOrEmpty(filecauhoi.FullName))
{
using (var package = new ExcelPackage(filecauhoi))
{
ExcelPackage.LicenseContext = LicenseContext.Commercial;
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowquestion = 2; rowquestion < noOfRow; rowquestion += 2)
{
var cauhoi = new CauHoi();
var traloia = new TraLoi();
var traloib = new TraLoi();
var traloic = new TraLoi();
var traloid = new TraLoi();
cauhoi.ID = listcauhoi.Count() + 1;
cauhoi.NoiDung = workSheet.Cells[rowquestion, 2].Value.ToString();
listcauhoi.Add(cauhoi);
traloia.ID = listtraloi.Count() + 1;
traloia.IDCauHoi = int.Parse(workSheet.Cells[rowquestion, 1].Value.ToString());
traloia.DungSai = int.Parse(workSheet.Cells[rowquestion + 1, 3].Value.ToString());
traloia.DapAn = workSheet.Cells[rowquestion, 3].Value.ToString();
listtraloi.Add(traloia);
traloib.ID = listtraloi.Count() + 1;
traloib.IDCauHoi = int.Parse(workSheet.Cells[rowquestion, 1].Value.ToString());
traloib.DungSai = int.Parse(workSheet.Cells[rowquestion + 1, 4].Value.ToString());
traloib.DapAn = workSheet.Cells[rowquestion, 4].Value.ToString();
listtraloi.Add(traloib);
traloic.ID = listtraloi.Count() + 1;
traloic.IDCauHoi = int.Parse(workSheet.Cells[rowquestion, 1].Value.ToString());
traloic.DungSai = int.Parse(workSheet.Cells[rowquestion + 1, 5].Value.ToString());
traloic.DapAn = workSheet.Cells[rowquestion, 5].Value.ToString();
listtraloi.Add(traloic);
traloid.ID = listtraloi.Count() + 1;
traloid.IDCauHoi = int.Parse(workSheet.Cells[rowquestion, 1].Value.ToString());
traloid.DungSai = int.Parse(workSheet.Cells[rowquestion + 1, 6].Value.ToString());
traloid.DapAn = workSheet.Cells[rowquestion, 6].Value.ToString();
listtraloi.Add(traloid);
}
}
}
int idtraloi = 1, idcauhoi = 1;
foreach (var cauhoi in listcauhoi.OrderBy(a => Guid.NewGuid()))
{
CauHoi ch = new CauHoi
{
ID = idcauhoi++,
NoiDung = cauhoi.NoiDung,
DotThi = dotthi,
};
db.Entry(ch).State = EntityState.Added;
foreach (var traloi in listtraloi)
{
if (cauhoi.ID == traloi.IDCauHoi)
{
TraLoi tl = new TraLoi()
{
ID = idtraloi++,
IDCauHoi = ch.ID,
DapAn = traloi.DapAn,
DungSai = traloi.DungSai,
};
db.Entry(tl).State = EntityState.Added;
}
}
if (idcauhoi > 20)
{
break;
}
}
var listnhanvien = db.NhanViens.ToList();
var listsales = db.Sales.ToList();
foreach (var nv in listnhanvien)
{
nv.ChoKiemTra = 1;
db.Entry(nv).State = EntityState.Modified;
db.SaveChanges();
}
foreach (var sa in listsales)
{
sa.ChoKiemTra = 1;
db.Entry(sa).State = EntityState.Modified;
db.SaveChanges();
}
return(Redirect("Uploads"));
}
