public ActionResult ListGroup(int id = 0)
 {
     using (var db = new Entities())
     {
         var data = db.asp_Group.ToList();
         if (id == 0 && data.Count > 0)
         {
             id = data[0].id;
         }
         ViewBag.Id = id;
         return View(data);
     }
 }
 public ActionResult Group(int id = 0)
 {
     using (var db = new Entities())
     {
         var model = new CreateGroupModel();
         model.roles = db.asp_Role.Select(x => new RoleData { name = x.name, description = x.description }).ToList();
         var data = db.asp_Group.FirstOrDefault(x => x.id == id);
         if (data != null)
         {
             model.id = data.id;
             model.name = data.name;
             model.description = data.description;
             foreach (var item in model.roles)
             {
                 if (data.asp_Role.Any(x => x.name == item.name))
                 {
                     item.check = true;
                 }
             }
         }
         return PartialView(model);
     }
 }
예제 #3
0
        public static int GetGroupOfUser(string currenUser)
        {
            try
            {
                using (var db = new Entities())
                {
                    //get group
                    var userGroup = db.asp_User.FirstOrDefault(x => x.account == currenUser);
                    var firstOrDefault = userGroup?.asp_Group.FirstOrDefault();
                    if (firstOrDefault != null)
                    {
                        var groupid = firstOrDefault.id;
                        return groupid;
                    }
                }
            }
            catch (Exception)
            {

                return 99;
            }

            return 99;
        }
예제 #4
0
        public ActionResult GetCourseOfCl(string id)
        {
            using (var db = new Entities())
            {
                var data = db.Courses.Where(x => x.CLID == id).ToList();
                var courses = data.Select(course => new Course() { IDCourse = course.IDCourse, Title = course.Title }).ToList();

                return Json(courses, JsonRequestBehavior.AllowGet);
            }
        }
 public ActionResult Account(CreateAccountModel model)
 {
     if (ModelState.IsValid)
     {
         using (var db = new Entities())
         {
             var data = db.asp_User.FirstOrDefault(x => x.account == model.account);
             if (data == null)
             {
                 //check mat khau
                 if (string.IsNullOrEmpty(model.password))
                 {
                     TempData["mess"] = "Bạn chưa nhập mật khẩu";
                     return RedirectToAction("ListAccount", new { id = model.account });
                 }
                 data = new asp_User
                 {
                     account = model.account,
                     userName = model.name,                            
                     password = CoreFunction.GetMd5Hash(model.password),
                     email = model.email
                 };
                 foreach (var item in model.groups)
                 {
                     if (item.check && !data.asp_Group.Any(x => x.id == item.id))
                     {
                         var groupItem = db.asp_Group.FirstOrDefault(x => x.id == item.id);
                         if (groupItem != null)
                         {
                             data.asp_Group.Add(groupItem);
                         }
                     }
                     else if (!item.check && data.asp_Group.Any(x => x.id == item.id))
                     {
                         var groupItem = db.asp_Group.FirstOrDefault(x => x.id == item.id);
                         if (groupItem != null)
                         {
                             data.asp_Group.Remove(groupItem);
                         }
                     }
                 }
                 db.asp_User.Add(data);
                 db.SaveChanges();                        
                 TempData["mess"] = "Đã thêm dữ liệu thành công";
             }
             else if (model.edit)
             {
                 data.userName = model.name;
                 if (!string.IsNullOrEmpty(model.password))
                 {
                     data.password = CoreFunction.GetMd5Hash(model.password);
                 }
                 data.email = model.email;                        
                 foreach (var item in model.groups)
                 {
                     if (item.check && !data.asp_Group.Any(x => x.id == item.id))
                     {
                         var groupItem = db.asp_Group.FirstOrDefault(x => x.id == item.id);
                         if (groupItem != null)
                         {
                             data.asp_Group.Add(groupItem);
                         }
                     }
                     else if (!item.check && data.asp_Group.Any(x => x.id == item.id))
                     {
                         var groupItem = db.asp_Group.FirstOrDefault(x => x.id == item.id);
                         if (groupItem != null)
                         {
                             data.asp_Group.Remove(groupItem);
                         }
                     }
                 }
                 db.SaveChanges();                        
                 TempData["mess"] = "Đã cập nhật dữ liệu thành công";
             }
             else
             {
                 TempData["mess"] = "Tài khoản đã tồn tại";
             }
         }
     }
     return RedirectToAction("ListAccount", new { id = model.account });
 }
 public ActionResult DeleteAccount(string id = "0")
 {
     using (var db = new Entities())
     {
         var data = db.asp_User.FirstOrDefault(x => x.account == id);
         if (data != null)
         {
             db.asp_User.Remove(data);
             db.SaveChanges();                    
             TempData["mess"] = "Bạn đã xóa dữ liệu thành công";
         }
         return RedirectToAction("ListAccount");
     }
 }
 public ActionResult ListAccount(string id)
 {
     using (var db = new Entities())
     {
         var data = db.asp_User.ToList();
         if (string.IsNullOrEmpty(id) && data.Count > 0)
         {
             id = data[0].account;
         }
         ViewBag.Id = id;
         return View(data);
     }
 }
 public ActionResult Account(string id)
 {
     using (var db = new Entities())
     {
         var model = new CreateAccountModel();
         model.groups = db.asp_Group.Select(x => new GroupData { id = x.id, name = x.name, description = x.description }).ToList();
         var data = db.asp_User.FirstOrDefault(x => x.account == id);
         if (data != null)
         {
             model.account = data.account;
             model.name = data.userName;                    
             //model.password
             model.email = data.email;
             model.edit = true;
             foreach (var item in model.groups)
             {
                 if (data.asp_Group.Any(x => x.id == item.id))
                 {
                     item.check = true;
                 }
             }
         }
         return PartialView(model);
     }
 }
        public ActionResult DeleteGroup(int id = 0)
        {
            using (var db = new Entities())
            {
                var data = db.asp_Group.FirstOrDefault(x => x.id == id);
                if (data != null)
                {
                    var check = db.asp_User.FirstOrDefault(x => x.asp_Group.Any(g => g.id == data.id));
                    if (check == null)
                    {
                        db.asp_Group.Remove(data);
                        db.SaveChanges();                        
                        TempData["mess"] = "Bạn đã xóa dữ liệu thành công";
                    }
                    else
                    {
                        TempData["mess"] = "Nhóm quyền này đã có tài khoản sử dụng nên không thể xóa được";
                        return RedirectToAction("ListGroup", new { id = id });
                    }

                }
                return RedirectToAction("ListGroup");
            }
        }
예제 #10
0
        public ActionResult Create(Report report)
        {
            try
            {
                using (var db = new Entities())
                {
                    report.Created = DateTime.Now;

                    var emailOfCm = GetEmailLogin(report.CMID);
                    //call sent email

                    //var pathHtml = Server.MapPath("bodyEmail.html");
                    //var body = System.IO.File.ReadAllText(pathHtml);
                    //body = String.Format(body, "", DateTime.Now.ToString("hh:mm dd-MM-yyyy"), "");
                    //var data = db.Courses.FirstOrDefault(x => x.IDCourse == courseID);
                    db.Reports.Add(report);
                    db.SaveChanges();
                    MailSender mailSender = new MailSender();
                    mailSender.sendMail(emailOfCm, "Check Report", "Report was submit", "gmail");
                    return Json(new { status = true }, JsonRequestBehavior.AllowGet);
                }
            }
            catch
            {
                return Json(new { status = false }, JsonRequestBehavior.AllowGet);
            }
        }
 public ActionResult Group(CreateGroupModel model)
 {
     if (ModelState.IsValid)
     {
         using (var db = new Entities())
         {
             var data = db.asp_Group.FirstOrDefault(x => x.id == model.id);
             if (data == null)
             {
                 data = new asp_Group
                 {
                     name = model.name,
                     description = model.description,
                     status = 0
                 };
                 foreach (var item in model.roles)
                 {
                     if (item.check && !data.asp_Role.Any(x => x.name == item.name))
                     {
                         var roleItem = db.asp_Role.FirstOrDefault(x => x.name == item.name);
                         if (roleItem != null)
                         {
                             data.asp_Role.Add(roleItem);
                         }
                     }
                     else if (!item.check && data.asp_Role.Any(x => x.name == item.name))
                     {
                         var roleItem = db.asp_Role.FirstOrDefault(x => x.name == item.name);
                         if (roleItem != null)
                         {
                             data.asp_Role.Remove(roleItem);
                         }
                     }
                 }
                 db.asp_Group.Add(data);
                 db.SaveChanges();                        
                 TempData["mess"] = "Đã thêm dữ liệu thành công";
             }
             else
             {
                 data.name = model.name;
                 data.description = model.description;
                 foreach (var item in model.roles)
                 {
                     if (item.check && !data.asp_Role.Any(x => x.name == item.name))
                     {
                         var roleItem = db.asp_Role.FirstOrDefault(x => x.name == item.name);
                         if (roleItem != null)
                         {
                             data.asp_Role.Add(roleItem);
                         }
                     }
                     else if (!item.check && data.asp_Role.Any(x => x.name == item.name))
                     {
                         var roleItem = db.asp_Role.FirstOrDefault(x => x.name == item.name);
                         if (roleItem != null)
                         {
                             data.asp_Role.Remove(roleItem);
                         }
                     }
                 }
                 db.SaveChanges();                        
                 TempData["mess"] = "Đã cập nhật dữ liệu thành công";
             }
         }
     }
     return RedirectToAction("ListGroup", new { id = model.id });
 }
예제 #12
0
 // GET: Admin/Report/Create
 public ActionResult Create(int courseID)
 {
     using (var db = new Entities())
     {
         var data = db.Courses.FirstOrDefault(x => x.IDCourse == courseID);
         return View(data);
     }
 }
예제 #13
0
        public ActionResult Comment(int id, string comment)
        {
            try
            {
                using (var db = new Entities())
                {
                    var update = db.Reports.FirstOrDefault(x => x.ID == id);
                    if (update != null)
                    {
                        update.Comment = comment;
                        db.SaveChanges();
                        return Json(new { status = true }, JsonRequestBehavior.AllowGet);
                    }
                }

            }
            catch
            {
                return Json(new { status = false }, JsonRequestBehavior.AllowGet);
            }

            return Json(new { status = false }, JsonRequestBehavior.AllowGet);
        }
예제 #14
0
        public ActionResult Approve(int id, int status)
        {
            try
            {
                using (var db = new Entities())
                {
                    var update = db.Reports.FirstOrDefault(x => x.ID == id);

                    var emailOfCl = GetEmailLogin(update.CLID);
                    var emailOfCM = GetEmailLogin(update.CMID);
                    var emailOfPVC = GetEmailLogin(update.PVCID);

                    if (update != null)
                    {
                        update.Status = status;
                        db.SaveChanges();
                        MailSender mailSender = new MailSender();
                        mailSender.sendMail(emailOfCl, "Check Report", "Report was Approve", "gmail");
                        mailSender.sendMail(emailOfCM, "Check Report", "Report was Approve", "gmail");
                        mailSender.sendMail(emailOfPVC, "Check Report", "Report was Approve", "gmail");
                        return Json(new { status = true }, JsonRequestBehavior.AllowGet);
                    }
                }

            }
            catch (Exception ex)
            {
                return Json(new { status = false }, JsonRequestBehavior.AllowGet);
            }

            return Json(new { status = false }, JsonRequestBehavior.AllowGet);
        }
예제 #15
0
 public static int CountReport(int status, DateTime start, DateTime endDate)
 {
     using (var db = new Entities())
     {
         return db.Reports.Where(x => x.Status == status && x.Created >= start && x.Created < endDate).Count();
     }                
 }
예제 #16
0
        // GET: Admin/Report
        public ActionResult Index(int id = 0)
        {
            string currenUser = User.Identity.Name;

            using (var db = new Entities())
            {
                //get group
                var userGroup = db.asp_User.FirstOrDefault(x => x.account == currenUser);
                if (userGroup != null)
                {
                    var groupid = userGroup.asp_Group.FirstOrDefault().id;
                    ViewBag.groupid = groupid;
                    if (groupid == 5)
                    {
                        var data = db.Reports.Where(x => x.CLID == currenUser).ToList();
                        if (id == 0 && data.Count > 0)
                        {
                            ViewBag.Id = data[0].ID;
                        }
                        else
                        {
                            ViewBag.Id = id;
                        }
                        return View(data);
                    }

                    if (groupid == 4)
                    {
                        var data = db.Reports.Where(x => x.CMID == currenUser && x.Status == 1).ToList();
                        if (id == 0 && data.Count > 0)
                        {
                            ViewBag.Id = data[0].ID;
                        }
                        else
                        {
                            ViewBag.Id = id;
                        }
                        return View(data);
                    }

                    if (groupid == 3)
                    {
                        var data = db.Reports.Where(x => x.DLTID == currenUser && x.Status == 2).ToList();
                        if (id == 0 && data.Count > 0)
                        {
                            ViewBag.Id = data[0].ID;
                        }
                        else
                        {
                            ViewBag.Id = id;
                        }
                        return View(data);
                    }

                    if (groupid == 2)
                    {
                        var data = db.Reports.Where(x => x.PVCID == currenUser && x.Status == 3).ToList();
                        if (id == 0 && data.Count > 0)
                        {
                            ViewBag.Id = data[0].ID;
                        }
                        else
                        {
                            ViewBag.Id = id;
                        }
                        return View(data);
                    }

                    if (groupid == 0)
                    {
                        var data = db.Reports.Where(x => x.Status == 3).ToList();
                        if (id == 0 && data.Count > 0)
                        {
                            ViewBag.Id = data[0].ID;
                        }
                        else
                        {
                            ViewBag.Id = id;
                        }
                        return View(data);
                    }

                }
                return View();
            }
        }
예제 #17
0
        public String GetReportJson(int status)
        {
            using (var db = new Entities())
            {
                var kq = new List<int>();

                //m1
                var b1 = new DateTime(DateTime.Now.Year, 1, 1);
                var e1 = new DateTime(DateTime.Now.Year, 2, 1);
                kq.Add(CountReport(status, b1, e1));

                //m2
                var b2 = new DateTime(DateTime.Now.Year, 2, 1);
                var e2 = new DateTime(DateTime.Now.Year, 3, 1);
                kq.Add(CountReport(status, b2, e2));

                //m3
                var b3 = new DateTime(DateTime.Now.Year, 3, 1);
                var e3 = new DateTime(DateTime.Now.Year, 4, 1);
                kq.Add(CountReport(status, b3, e3));

                var b4 = new DateTime(DateTime.Now.Year, 4, 1);
                var e4 = new DateTime(DateTime.Now.Year, 5, 1);
                kq.Add(CountReport(status, b4, e4));

                var b5 = new DateTime(DateTime.Now.Year, 5, 1);
                var e5 = new DateTime(DateTime.Now.Year, 6, 1);
                kq.Add(CountReport(status, b5, e5));

                var b6 = new DateTime(DateTime.Now.Year, 6, 1);
                var e6 = new DateTime(DateTime.Now.Year, 7, 1);
                kq.Add(CountReport(status, b6, e6));

                var b7 = new DateTime(DateTime.Now.Year, 7, 1);
                var e7 = new DateTime(DateTime.Now.Year, 8, 1);
                kq.Add(CountReport(status, b7, e7));


                var b8 = new DateTime(DateTime.Now.Year, 8, 1);
                var e8 = new DateTime(DateTime.Now.Year, 9, 1);
                kq.Add(CountReport(status, b8, e8));

                var b9 = new DateTime(DateTime.Now.Year, 9, 1);
                var e9 = new DateTime(DateTime.Now.Year, 10, 1);
                kq.Add(CountReport(status, b9, e9));

                var b10 = new DateTime(DateTime.Now.Year, 10, 1);
                var e10 = new DateTime(DateTime.Now.Year, 11, 1);
                kq.Add(CountReport(status, b10, e10));

                var b11 = new DateTime(DateTime.Now.Year, 11, 1);
                var e11 = new DateTime(DateTime.Now.Year, 12, 1);
                kq.Add(CountReport(status, b11, e11));

                var b12 = new DateTime(DateTime.Now.Year, 12, 1);
                var e12 = new DateTime(DateTime.Now.Year, 1, 1).AddYears(1);
                kq.Add(CountReport(status, b12, e12));
                return JsonConvert.SerializeObject(kq);                
            }
        }
예제 #18
0
        public string GetEmailLogin(string username)
        {
            string currenUser = User.Identity.Name;

            using (var db = new Entities())
            {
                //get group
                var userGroup = db.asp_User.FirstOrDefault(x => x.userName == username);
                if (userGroup != null)
                {
                    return userGroup.email;
                }
            }

            return null;
        }
예제 #19
0
 // GET: Admin/Report/Details/5
 public ActionResult Details(int id)
 {
     using (var db = new Entities())
     {
         var data = db.Reports.FirstOrDefault(x => x.ID == id);
         return PartialView(data);
     }
 }