public JsonResult Detail(Guid id)
{
if (id == Guid.Empty)
{
return(Json(new { Ok = true, Data = new { }, Message = "Input to add new" }, JsonRequestBehavior.AllowGet));
}
using (var db = new DomainDrivenDesign.CoreCms.Ef.CoreCmsDbContext())
{
var data = db.Categories.Where(i => i.Id == id)
.Select(c => new FeCategory()
{
Id = c.Id,
IsSinglePage = c.IsSinglePage,
ShowInFrontEnd = c.ShowInFrontEnd,
CategoryViewName = c.CategoryViewName,
Type = (Enums.CategoryType)c.Type
}).FirstOrDefault();
data.Title = db.ContentLanguages.GetValue(id, LanguageId, "Title", "Category");
data.SeoUrlFriendly = db.ContentLanguages.GetValue(id, LanguageId, "SeoUrlFriendly", "Category");
data.SeoDescription = db.ContentLanguages.GetValue(id, LanguageId, "SeoDescription", "Category");
data.SeoKeywords = db.ContentLanguages.GetValue(id, LanguageId, "SeoKeywords", "Category");
return(Json(new { Ok = true, Data = data, Message = "Input to edit" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index(Guid?id)
{
var model = new ProductListAdminPage();
if (null != id)
{
var xid = id.Value;
using (var db = new DomainDrivenDesign.CoreCms.Ef.CoreCmsDbContext())
{
model.CategoryId = xid;
model.CategoryTitle = db.ContentLanguages.GetValue(xid, LanguageId, "Title", "Category");
}
}
return(View(model));
}
public ActionResult Detail(string urlsegment)
{
if (string.IsNullOrEmpty(urlsegment))
{
return(Content("404 not found news"));
}
var model = new FeNews();
using (var db = new DomainDrivenDesign.CoreCms.Ef.CoreCmsDbContext())
{
var temp = db.UrlFriendlys.FirstOrDefault(
i => i.UrlSegment.Equals(urlsegment, StringComparison.OrdinalIgnoreCase) &&
i.TableName.Equals("News", StringComparison.OrdinalIgnoreCase));
if (temp == null)
{
return(Content("Not found. 404"));
}
var id = temp.Id;
var news = db.News.SingleOrDefault(i => i.Id == id);
model.Id = id;
model.AllowComment = news.AllowComment;
model.Title = db.ContentLanguages.GetValue(id, LanguageId, "Title");
model.ShortDescription = db.ContentLanguages.GetValue(id, LanguageId, "ShortDescription");
model.Description = db.ContentLanguages.GetValue(id, LanguageId, "Description");
model.SeoKeywords = db.ContentLanguages.GetValue(id, LanguageId, "SeoKeywords");
model.UrlImage = db.ContentLanguages.GetValue(id, LanguageId, "UrlImage");
model.SeoDescription = db.ContentLanguages.GetValue(id, LanguageId, "SeoDescription");
}
return(View(model));
}
public JsonResult List(Guid?roleId, string keywords,
int?skip, int?take, string sortField, string orderBy)
{
var xtake = 10;
var xskip = 0;
long total = 0;
if (skip != null)
{
xskip = skip.Value;
}
if (take != null)
{
xtake = take.Value;
}
if (string.IsNullOrEmpty(sortField))
{
sortField = nameof(DomainDrivenDesign.Core.Implements.Models.User.Username);
}
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "desc";
}
Expression <Func <User, bool> > predicate = u => true;
if (!string.IsNullOrEmpty(keywords))
{
predicate = predicate.And(i => i.Username.Contains(keywords) ||
i.Email.Contains(keywords) ||
i.Phone.Contains(keywords));
}
List <User> rows = null;
using (var db = new DomainDrivenDesign.CoreCms.Ef.CoreCmsDbContext())
{
if (roleId.HasValue)
{
var xroleId = roleId.Value;
var queryable = db.Users.Join(db.RelationShips, u => u.Id, rs => rs.FromId, (u, rs) => new { U = u, Rs = rs })
.Where(i => i.Rs.ToId == xroleId).Select(m => m.U)
.Where(predicate);
total = queryable.LongCount();
rows = queryable
.OrderBy(i => i.Username)
.Skip(xskip).Take(xtake).ToList();
}
else
{
var queryable = db.Users.Where(predicate);
total = queryable.LongCount();
rows = queryable
.OrderBy(i => i.Username)
.Skip(xskip).Take(xtake).ToList();
}
}
return(Json(new { total, rows, success = true }, JsonRequestBehavior.AllowGet));
}
