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 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 }); }
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 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"); } }
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); }
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); }
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); } }