public bool SaveCatalogTitleSearch(lwg_CatalogTitleSearch lwg)
{
if (lwg != null && lwg.CatalogId > 0 && !string.IsNullOrEmpty(lwg.Title))
{
if (dbContext.lwg_CatalogTitleSearch.Any(lc => lc.CatalogId == lwg.CatalogId))
{
lwg_CatalogTitleSearch cis = dbContext.lwg_CatalogTitleSearch.Where(lc => lc.CatalogId == lwg.CatalogId).FirstOrDefault();
cis.Title = lwg.Title;
}
else
{
lwg_CatalogTitleSearch cis = new lwg_CatalogTitleSearch();
if (dbContext.lwg_CatalogTitleSearch.Count() > 0)
{
cis.Id = dbContext.lwg_CatalogTitleSearch.OrderByDescending(lc => lc.Id).First().Id + 1;
}
else
{
cis.Id = 1;
}
cis.CatalogId = lwg.CatalogId;
cis.Title = lwg.Title;
dbContext.lwg_CatalogTitleSearch.Add(cis);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
public string GetTitleSearchByCatalogID(int catalogID)
{
lwg_CatalogTitleSearch lg = dbContext.lwg_CatalogTitleSearch.Where(lw => lw.CatalogId == catalogID).FirstOrDefault();
if (lg != null)
{
return(lg.Title);
}
return(string.Empty);
}
public bool DeleteCatalogTitleSearch(int id)
{
lwg_CatalogTitleSearch cis = dbContext.lwg_CatalogTitleSearch.SingleOrDefault(c => c.Id == id);
if (cis != null)
{
dbContext.lwg_CatalogTitleSearch.Remove(cis);
dbContext.SaveChanges();
return(true);
}
return(false);
}
