public ActionResult Action(tblSupport objSubmit)
{
if (objSubmit.ID == 0)
{
objSubmit.DateCreated = DateTime.Now;
objSubmit.DateUpdated = DateTime.Now;
objSubmit.IsDeleted = false;
objSubmit.IsShow = true;
supportRepository.Add(objSubmit);
}
else
{
var obj = supportRepository.GetById <tblSupport>(objSubmit.ID);
UpdateModel(obj);
objSubmit.DateUpdated = DateTime.Now;
supportRepository.Update(obj);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
public bool InsertAndUpdate(tblSupport support)
{
using (var db = new ModelDbContext())
{
db.tblSupports.Add(support);
return(db.SaveChanges() > 0);
}
}
public ActionResult DeleteConfirmed(int id)
{
tblSupport tblSupport = db.tblSupports.Find(id);
db.tblSupports.Remove(tblSupport);
tblSupport.SupportActive = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool InsertAndUpdate(tblSupport support)
{
try
{
return(new ASupport().InsertAndUpdate(support));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit([Bind(Include = "SupportID,SupportNumber,SupportEmail,SupportAddress,SupportPerson,ReportingDateTime,SupportActive")] tblSupport tblSupport)
{
if (ModelState.IsValid)
{
db.Entry(tblSupport).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblSupport));
}
public ActionResult Create([Bind(Include = "Id,FullName,Email,Phone,Country,City,GradeLevel,Major,TimeExpected,Question")] tblSupport tblSupport)
{
if (ModelState.IsValid)
{
tblSupport.CreateDate = DateTime.Now;
tblSupport.Status = (short)NewsProject.Commons.Status.New;
//db.tblSupports.Add(tblSupport);
//db.SaveChanges();
ExecuteNews.Support.InsertAndUpdate(tblSupport);
return(RedirectToAction("HomeNews", "Home"));
}
return(RedirectToAction("HomeNews", "Home"));
}
public ActionResult Create([Bind(Include = "SupportID,SupportNumber,SupportEmail,SupportAddress,SupportPerson,ReportingDateTime,SupportActive")] tblSupport tblSupport)
{
if (ModelState.IsValid)
{
tblSupport.SupportActive = true;
tblSupport.ReportingDateTime = DateTime.Now;
db.tblSupports.Add(tblSupport);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblSupport));
}
// GET: Supports/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSupport tblSupport = db.tblSupports.Find(id);
if (tblSupport == null)
{
return(HttpNotFound());
}
return(View(tblSupport));
}
public bool DeleteById(int id)
{
using (var db = new ModelDbContext())
{
if (!db.tblSupports.Any(p => p.Id == id))
{
return(false);
}
var item = new tblSupport()
{
Id = id
};
db.tblSupports.Attach(item);
db.tblSupports.Remove(item);
return(db.SaveChanges() > 0);
}
}
public ActionResult DeleteSupport(int id)
{
if (ClsCheckRole.CheckQuyen(15, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblSupport tblsupport = db.tblSupports.Find(id);
var result = string.Empty;
db.tblSupports.Remove(tblsupport);
db.SaveChanges();
result = "Bạn đã xóa thành công.";
return(Json(new { result = result }));
}
else
{
var result = string.Empty;
result = "Bạn không có quyền thay đổi tính năng này";
return(Json(new { result = result }));
}
}
public ActionResult Edit(int id = 0)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(15, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblSupport tblsupport = db.tblSupports.Find(id);
if (tblsupport == null)
{
return(HttpNotFound());
}
return(View(tblsupport));
}
else
{
return(Redirect("/Users/Erro"));
}
}
public ActionResult Create(tblSupport tblsupport, FormCollection collection)
{
db.tblSupports.Add(tblsupport);
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Add tblsupport", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/support/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm danh mục mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/support/Create"));
}
return(Redirect("Index"));
}
public bool UpdateStatus(int id, short status)
{
using (var db = new ModelDbContext())
{
var item = new tblSupport()
{
Id = id
};
if (db.tblSupports.Any(p => p.Id == id))
{
db.tblSupports.Attach(item);
item.Status = status;
}
else
{
return(false);
}
return(db.SaveChanges() > 0);
}
}
public ActionResult Delete(int id = 0)
{
if (IsLogin())
{
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblSupport tblSupport = ExecuteNews.Support.GetById(id);
if (tblSupport == null)
{
return(HttpNotFound());
}
return(View(tblSupport));
}
else
{
return(RedirectToAction("Login", "User"));
}
}
public ActionResult Edit(tblSupport tblsupport, int id, FormCollection collection)
{
if (ModelState.IsValid)
{
db.Entry(tblsupport).State = EntityState.Modified;
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit tblsupport", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/supportad/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/supportad/Create"));
}
}
return(View(tblsupport));
}
public ActionResult Index(int?page, string id, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(15, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
var listSupport = db.tblSupports.ToList();
const int pageSize = 20;
var pageNumber = (page ?? 1);
// Thiết lập phân trang
var ship = new PagedListRenderOptions
{
DisplayLinkToFirstPage = PagedListDisplayMode.Always,
DisplayLinkToLastPage = PagedListDisplayMode.Always,
DisplayLinkToPreviousPage = PagedListDisplayMode.Always,
DisplayLinkToNextPage = PagedListDisplayMode.Always,
DisplayLinkToIndividualPages = true,
DisplayPageCountAndCurrentLocation = false,
MaximumPageNumbersToDisplay = 5,
DisplayEllipsesWhenNotShowingAllPageNumbers = true,
EllipsesFormat = "…",
LinkToFirstPageFormat = "Trang đầu",
LinkToPreviousPageFormat = "«",
LinkToIndividualPageFormat = "{0}",
LinkToNextPageFormat = "»",
LinkToLastPageFormat = "Trang cuối",
PageCountAndCurrentLocationFormat = "Page {0} of {1}.",
ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.",
FunctionToDisplayEachPageNumber = null,
ClassToApplyToFirstListItemInPager = null,
ClassToApplyToLastListItemInPager = null,
ContainerDivClasses = new[] { "pagination-container" },
UlElementClasses = new[] { "pagination" },
LiElementClasses = Enumerable.Empty <string>()
};
ViewBag.ship = ship;
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
if (collection["btnDelete"] != null)
{
foreach (string key in Request.Form.Keys)
{
var checkbox = "";
if (key.StartsWith("chk_"))
{
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
if (ClsCheckRole.CheckQuyen(3, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
int ids = Convert.ToInt32(key.Remove(0, 4));
tblSupport tblsupport = db.tblSupports.Find(ids);
db.tblSupports.Remove(tblsupport);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Redirect("/Users/Erro"));
}
}
}
}
}
return(View(listSupport.ToPagedList(pageNumber, pageSize)));
}
else
{
return(Redirect("/Users/Erro"));
}
}
