public ActionResult Chat(int id)
{
var hocvu = new HocVuDao();
var content = hocvu.ViewDetail(id);
return(View(content));
}
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new HocVuDao();
var model = dao.ListHocVu(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult Index(string searchYeuCau, string searchTinhTrang, string searchName,
string searchTenDanhMuc, string searchTenDonVi, string searchTenLop, string searchEmail, string searchTenVaiTro, int page = 1, int pageSize = 10)
{
var dao = new HocVuDao();
var model = dao.ListThongKe(searchYeuCau, searchTinhTrang, searchName, searchTenDanhMuc,
searchTenDonVi, searchTenLop, searchEmail, searchTenVaiTro, page, pageSize);
var dao1 = new DonViDao();
ViewBag.listDonVi = new SelectList(dao1.ListAll(), "TenDonVi", "TenDonVi");
ViewBag.listTinhTrang = new SelectList(dao.ListAll(), "TinhTrang", "TinhTrang");
var lop = new LopDao();
ViewBag.listLop = new SelectList(lop.ListAll(), "TenLop", "TenLop");
var vaitro = new VaiTroDao();
ViewBag.listVaiTro = new SelectList(vaitro.ListAll(), "TenVaiTro", "TenVaiTro");
ViewBag.searchYeuCau = searchYeuCau;
ViewBag.searchTinhTrang = searchTinhTrang;
ViewBag.searchName = searchName;
ViewBag.searchTenDanhMuc = searchTenDanhMuc;
ViewBag.searchTenDonVi = searchTenDonVi;
ViewBag.searchTenLop = searchTenLop;
ViewBag.searchEmail = searchEmail;
ViewBag.searchTenVaiTro = searchTenVaiTro;
var list = dao.ListAll();
List <int> repart = new List <int>();
var userID = list.Select(x => x.UserID).Distinct();
var listUser = from a in userID
join b in db.Users on a.Value equals b.UserID
select b.UserName;
foreach (var item in userID)
{
repart.Add(list.Count(x => x.UserID == item));
}
var rep = repart;
ViewBag.UserID = listUser;
ViewBag.REP = repart.ToList();
var danhmucID = list.Select(x => x.DanhMucID).Distinct();
var listDM = from a in danhmucID
join b in db.DanhMucs on a.ToString() equals b.DanhMucID.ToString()
select b.TenDanhMuc;
List <int> listDanhMuc = new List <int>();
foreach (var item in danhmucID)
{
listDanhMuc.Add(list.Count(x => x.DanhMucID == item));
}
ViewBag.danhmucID = listDM;
ViewBag.listDanhMuc = listDanhMuc.ToList();
return(View(model));
}
public JsonResult ChangeTinhTrang(int id)
{
var result = new HocVuDao().ChangeTinhTrang(id);
return(Json(new
{
status = result
}));
}
public ActionResult Edit(int id)
{
var hocvu = new HocVuDao();
var content = hocvu.ViewDetail(id);
SetViewBag(content.DonViID);
SetViewBagDanhMuc(content.DanhMucID);
SetViewBagUser(content.UserID);
return(View(content));
}
public ActionResult PrintAll(string searchString, string searchUser)
{
var dao = new HocVuDao();
var model = dao.ListHocVu(searchString, searchUser, 1, 10);
var q = new ActionAsPdf("Index", model);
var b = new ViewAsPdf("Index", model);
var a = new PartialViewAsPdf("Index", model);
return(q);
}
public ActionResult PrintAll(string searchYeuCau, string searchTinhTrang, string searchName,
string searchTenDanhMuc, string searchTenDonVi, string searchTenLop, string searchEmail, string searchTenVaiTro)
{
var dao = new HocVuDao();
var model = dao.ListThongKe(searchYeuCau, searchTinhTrang, searchName, searchTenDanhMuc,
searchTenDonVi, searchTenLop, searchEmail, searchTenVaiTro, 1, 10);
var q = new ActionAsPdf("Index", model);
var b = new ViewAsPdf("Index", model);
var a = new PartialViewAsPdf("Index", model);
return(b);
}
public ActionResult Index(string searchString, string searchUser, int page = 1, int pageSize = 100)
{
var dao = new HocVuDao();
var model = dao.ListHocVu(searchString, searchUser, page, pageSize);
ViewBag.SearchString = searchString;
ViewBag.searchUser = searchUser;
var dao1 = new DonViDao();
ViewBag.listDonVi = new SelectList(dao1.ListAll(), "TenDonVi", "TenDonVi");
return(View(model));
}
public ActionResult Index(HocVu hocvu)
{
User a = CheckAuthorize.Instance.XuatUserID();
if (ModelState.IsValid)
{
var dao = new HocVuDao();
int dem;
var child = db.HocVus.Where(x => x.UserID + x.DanhMucID == a.UserID + hocvu.DanhMucID && x.UserID == a.UserID);
var getHVID = from q in db.HocVus
where (q.UserID + q.DanhMucID == a.UserID + hocvu.DanhMucID && q.UserID == a.UserID)
select q.HocVuID;
var moc = from q in db.HocVus
where (q.UserID + q.DanhMucID == a.UserID + hocvu.DanhMucID && q.UserID == a.UserID && q.TinhTrang == true)
select q.HocVuID;
if (child.Count() == 0)
{
dem = 0;
}
else
{
dem = getHVID.Min();
}
if (moc.Count() != 0)
{
int mocMax = moc.Max();
var xyz = db.HocVus.Where(x => x.UserID + x.DanhMucID == a.UserID + hocvu.DanhMucID && x.UserID == a.UserID && x.HocVuID > mocMax);
if (xyz.Count() > 0)
{
dem = getHVID.Where(x => x > mocMax).Min();
}
else
{
dem = 0;
}
}
int id = dao.Insert2(hocvu, a, dem);
if (id > 0)
{
SetAlert("Thêm học vụ thành công", "success");
}
else
{
ModelState.AddModelError("", "Thêm học vụ không thành công");
}
SetViewBag();
}
return(View());
}
public ActionResult Index(string searchString, int page = 1, int pageSize = 100)
{
User a = CheckAuthorize.Instance.XuatUserID();
var dao = new HocVuDao();
var model = dao.ListLichSu(searchString, page, pageSize, a);
ViewBag.SearchString = searchString;
List <HocVuViewModel> list = new List <HocVuViewModel>();
using (DoAnDbContext db = new DoAnDbContext())
{
list = list.OrderBy(x => x.HocVuID).ToList();
}
return(View(model));
}
public ActionResult Chat(HocVu hocvu)
{
User a = CheckAuthorize.Instance.XuatUserID();
if (ModelState.IsValid)
{
var dao = new HocVuDao();
int id = dao.Insert2(hocvu, a, hocvu.HocVuID);
if (id > 0)
{
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Thêm không thành công");
}
}
return(View("Index"));
}
public ActionResult Index(HocVu hocvu)
{
User a = CheckAuthorize.Instance.XuatUserID();
if (ModelState.IsValid)
{
var dao = new HocVuDao();
int id = dao.Insert2(hocvu, a);
if (id > 0)
{
SetAlert("Thêm học vụ thành công", "success");
}
else
{
ModelState.AddModelError("", "Thêm học vụ không thành công");
}
SetViewBag();
SetViewBagDanhMuc();
}
return(View());
}
public ActionResult Create(HocVu hocvu)
{
if (ModelState.IsValid)
{
var dao = new HocVuDao();
int id = dao.Insert(hocvu);
if (id > 0)
{
SetAlert("Thêm học vụ thành công", "success");
return(RedirectToAction("Index", "HocVu"));
}
else
{
ModelState.AddModelError("", "Thêm học vụ không thành công");
}
SetViewBag();
SetViewBagDanhMuc();
SetViewBagUser();
}
return(View("Index"));
}
public ActionResult Edit(HocVu hocvu)
{
if (ModelState.IsValid)
{
var dao = new HocVuDao();
var result = dao.Update(hocvu);
if (result)
{
SetAlert("Sửa học vụ thành công", "success");
return(RedirectToAction("Index", "HocVu"));
}
else
{
ModelState.AddModelError("", "cập nhật không thành công");
}
SetViewBag(hocvu.DonViID);
SetViewBagDanhMuc(hocvu.DanhMucID);
SetViewBagUser(hocvu.UserID);
}
return(View("Index"));
}
