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