public ActionResult Create(Shop entity)
{
if (ModelState.IsValid)
{
try
{
Shop shop = entity;
var model = new CodeShop();
model.Add(entity);
return(RedirectToAction("Index"));
}
catch (DbUpdateException ex)
{
ViewData["Error"] = ex.Message;
return(View(entity));
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
return(View(entity));
}
}
else
{
GetSelectedList();
return(View(entity));
}
}
public void GetSelectedList()
{
var model = new CodeShop();
List <Shop> shops = model.ListAll();
List <Shop> filterList = shops.GroupBy(x => x.UserID).Select(x => x.First()).ToList();
IEnumerable <SelectListItem> userTypeList = new SelectList(filterList, "UserID", "UserID");
ViewData["UserIDList"] = userTypeList;
}
public JsonResult Delete(long id)
{
try
{
var model = new CodeShop();
model.Delete(id);
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Success = false, Msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
// GET: Admin/Shop
public ActionResult Index(int page = 1, int pagesize = 5)
{
try
{
var model = new CodeShop();
var result = model.GetAllShop();
return(View(result));
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
return(View());
}
}
public ActionResult Edit(Shop entity)
{
try
{
var model = new CodeShop();
model.Update(entity);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
return(View(entity));
}
}
public JsonResult DataTableGet([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
var context = new ShopBanHangDbContext();
var model = new CodeShop();
IQueryable <ShopModel> query = model.GetAllShop().AsQueryable();
var totalCount = query.Count();
// Apply filters
if (!string.IsNullOrEmpty(requestModel.Search.Value))
{
var value = requestModel.Search.Value.Trim();
query = query.Where(p => p.Name.Contains(value));
}
var filteredCount = query.Count();
// Sort
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
orderByString = orderByString == String.Empty ? "ID asc" : orderByString;
//squery = query.OrderBy(orderByString);
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
var data = query.Select(p => new
{
Id = p.ID,
Name = p.Name,
Description = p.Description,
Address = p.Address,
UserID = p.UserID,
Email = p.Email,
Action = "<br /><p class=\"btn-action\"><a href=\"#\" class=\"detail\"><i class=\"ui-tooltip fa fa-pencil-square-o detail\" style=\"font-size: 22px;\" data-original-title=\"Detail\"></i></a> <a href=\"#\" class=\"remove\" ><i class=\"ui-tooltip fa fa-trash-o remove\" style=\"font-size: 20px;\" data-original-title=\"Delete\" tooltip=\"Delete\"></i></a></p>",
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet));
}
