public bool CheckAndInsertInstrTitle(string titleName, int catalogID, int titleTypeID) { try { lwg_InstrTitle lwg = context.lwg_InstrTitle.SingleOrDefault(o => o.Name.ToLower().Equals(titleName.ToLower()) && o.TitleTypeId == titleTypeID); if (lwg == null) { lwg = new lwg_InstrTitle(); lwg.TitleTypeId = titleTypeID; lwg.Name = titleName; CatalogTitleTypeBiz cBiz = new CatalogTitleTypeBiz(); cBiz.SaveInstrTitle(lwg); } if (!context.lwg_CatalogTitle.Any(o => o.CatalogId == catalogID && o.InstrTitleId == lwg.Id)) { lwg_CatalogTitle catalogTitle = new lwg_CatalogTitle(); catalogTitle.CatalogId = catalogID; catalogTitle.InstrTitleId = lwg.Id; context.lwg_CatalogTitle.Add(catalogTitle); context.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public int GetInstrTitleIDByCatalogID(int catalogID) { lwg_CatalogTitle lg = dbContext.lwg_CatalogTitle.Where(lwg => lwg.CatalogId == catalogID).FirstOrDefault(); if (lg != null) { return(lg.InstrTitleId); } return(0); }
public bool DeleteCatalogTitle(int instrTitleID, int catalogID) { if (instrTitleID > 0 && catalogID > 0) { lwg_CatalogTitle lwg = dbContext.lwg_CatalogTitle.SingleOrDefault(p => p.InstrTitleId == instrTitleID && p.CatalogId == catalogID); if (lwg != null) { dbContext.lwg_CatalogTitle.Remove(lwg); dbContext.SaveChanges(); return(true); } } return(false); }
public bool SaveCatalogTitle(int catalogID, int instrTitleID) { if (catalogID > 0 && instrTitleID > 0) { //List<lwg_CatalogTitle> lst = dbContext.lwg_CatalogTitles.Where(lg => lg.CatalogId == catalogID).ToList(); //dbContext.lwg_CatalogTitles.DeleteAllOnSubmit(lst); if (!dbContext.lwg_CatalogTitle.Any(p => p.CatalogId == catalogID && p.InstrTitleId == instrTitleID)) { lwg_CatalogTitle ct = new lwg_CatalogTitle(); ct.CatalogId = catalogID; ct.InstrTitleId = instrTitleID; dbContext.lwg_CatalogTitle.Add(ct); dbContext.SaveChanges(); return(true); } } return(false); }