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); }