public int GetGenreIdByCatalogID(int catalogID)
{
lwg_CatalogGenre lg = dbContext.lwg_CatalogGenre.Where(lwg => lwg.CatalogId == catalogID).FirstOrDefault();
if (lg != null)
{
return(lg.GerneId);
}
return(0);
}
public bool DeleteCatalogGenre(int genreID, int productID)
{
if (genreID > 0 && productID > 0)
{
lwg_CatalogGenre lwg = dbContext.lwg_CatalogGenre.SingleOrDefault(p => p.GerneId == genreID && p.CatalogId == productID);
if (lwg != null)
{
dbContext.lwg_CatalogGenre.Remove(lwg);
dbContext.SaveChanges();
return(true);
}
}
return(false);
}
public bool SaveCatalogGenre(int catalogID, int genreID)
{
if (catalogID > 0 && genreID > 0)
{
//List<lwg_CatalogGenre> lst = dbContext.lwg_CatalogGenres.Where(lg => lg.CatalogId == catalogID).ToList();
//dbContext.lwg_CatalogGenres.DeleteAllOnSubmit(lst);
if (!dbContext.lwg_CatalogGenre.Any(p => p.CatalogId == catalogID && p.GerneId == genreID))
{
lwg_CatalogGenre cg = new lwg_CatalogGenre();
cg.CatalogId = catalogID;
cg.GerneId = genreID;
dbContext.lwg_CatalogGenre.Add(cg);
dbContext.SaveChanges();
return(true);
}
}
return(false);
}
protected void gvGenre_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.DataItem == null)
{
return;
}
lwg_CatalogGenre lg = (lwg_CatalogGenre)e.Row.DataItem;
if (lg != null)
{
Literal ltrProductDisplay = (Literal)e.Row.FindControl("ltrProductDisplay");
ltrProductDisplay.Text = lg.lwg_Catalog.TitleDisplay;
Literal ltrGenreName = (Literal)e.Row.FindControl("ltrGenreName");
ltrGenreName.Text = lg.lwg_Genre.Name;
LinkButton lnkbtnRemove = (LinkButton)e.Row.FindControl("lnkbtnRemove");
lnkbtnRemove.CommandArgument = lg.GerneId.ToString();
}
}
public bool CheckAndInsertGenre(string genreName, int catalogID)
{
lwg_Genre lwg = dbContext.lwg_Genre.SingleOrDefault(o => o.Name.ToLower().Equals(genreName.ToLower()));
if (lwg == null)
{
lwg = new lwg_Genre();
lwg.Name = genreName;
SaveGenre(lwg);
}
if (!dbContext.lwg_CatalogGenre.Any(o => o.CatalogId == catalogID && o.GerneId == lwg.GerneId))
{
lwg_CatalogGenre catalogGenre = new lwg_CatalogGenre();
catalogGenre.CatalogId = catalogID;
catalogGenre.GerneId = lwg.GerneId;
dbContext.lwg_CatalogGenre.Add(catalogGenre);
dbContext.SaveChanges();
return(true);
}
return(false);
}
