public IEnumerable <shAboutu> DanhSachAbout_ByParentId(string ParentId)
{
shAboutService _about = new shAboutService();
IEnumerable <shAboutu> dsAbout = _about.FindList().Where(x => x.ParentId == ParentId && x.Status == true);
return(dsAbout);
}
public shAboutu Insert_About(string AboutGuid, int?AboutId, string AboutTitle, string AboutName, string AboutContent, int?Year, string Sign, string ImageUrl, string ParentId, int?SortOrder, bool?Status, DateTime?CreateDate)
{
shAboutService _about = new shAboutService();
shAboutu about = new shAboutu();
try
{
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
if (!string.IsNullOrWhiteSpace(AboutGuid) || !string.IsNullOrEmpty(AboutGuid))
{
about = _about.FindByKey(AboutGuid);
}
else
{
about.AboutGuid = Common.GuidUnique.getInstance().GenerateUnique();
}
about.AboutTitle = AboutTitle;
about.AboutName = AboutName;
about.AboutContent = AboutContent;
about.Year = Year;
about.Sign = Sign;
about.ImageUrl = ImageUrl;
about.ParentId = ParentId;
about.SortOrder = SortOrder;
about.Status = Status;
about.CreateDate = CreateDate;
about.MetaTitle = "/gioi-thieu/" + StringHelper.ToUnsignString(AboutTitle).ToLower();
if (about.AboutId > 0)
{
_about.Update(about);
}
else
{
_about.Insert(about);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
return(null);
}
return(about);
}
public IEnumerable <shAboutu> DanhSachAbout()
{
shAboutService _about = new shAboutService();
return(_about.FindList().OrderBy(x => x.AboutId)
.Where(x => string.IsNullOrEmpty(x.ParentId) ||
string.IsNullOrWhiteSpace(x.ParentId) &&
x.Status == true));
}
