public int GetPublisherIDByCatalogID(int catalogID)
{
lwg_CatalogPublisher lg = dbContext.lwg_CatalogPublisher.Where(lwg => lwg.CatalogId == catalogID).FirstOrDefault();
if (lg != null)
{
return(lg.PublisherId);
}
return(0);
}
public bool SaveCatalogPublisher(int catalogID, int publisherID)
{
if (catalogID > 0 && publisherID > 0)
{
List <lwg_CatalogPublisher> lst = dbContext.lwg_CatalogPublisher.Where(lg => lg.CatalogId == catalogID).ToList();
dbContext.lwg_CatalogPublisher.RemoveRange(lst);
lwg_CatalogPublisher cp = new lwg_CatalogPublisher();
cp.CatalogId = catalogID;
cp.PublisherId = publisherID;
dbContext.lwg_CatalogPublisher.Add(cp);
dbContext.SaveChanges();
return(true);
}
return(false);
}
public bool CheckAndInsertPublisher(string publisherName, int catalogID)
{
lwg_Publisher lwg = dbContext.lwg_Publisher.SingleOrDefault(o => o.Name.ToLower().Equals(publisherName.ToLower()));
if (lwg == null)
{
lwg = new lwg_Publisher();
lwg.Name = publisherName;
SavePublisher(lwg);
}
if (!dbContext.lwg_CatalogPublisher.Any(o => o.CatalogId == catalogID && o.PublisherId == lwg.PublisherId))
{
lwg_CatalogPublisher catalogPublisher = new lwg_CatalogPublisher();
catalogPublisher.CatalogId = catalogID;
catalogPublisher.PublisherId = lwg.PublisherId;
dbContext.lwg_CatalogPublisher.Add(catalogPublisher);
dbContext.SaveChanges();
return(true);
}
return(false);
}
