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