public bool SaveGenre(lwg_Genre p)
{
if (p != null)
{
if (p.GerneId > 0)
{
lwg_Genre c = dbContext.lwg_Genre.SingleOrDefault(ht => ht.GerneId == p.GerneId);
if (c != null)
{
c.Name = p.Name;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Genre.Count() > 0)
{
p.GerneId = dbContext.lwg_Genre.OrderByDescending(pe => pe.GerneId).First().GerneId + 1;
}
else
{
p.GerneId = 1;
}
dbContext.lwg_Genre.Add(p);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
GenerBiz pBiz = new GenerBiz();
lwg_Genre p;
if (string.IsNullOrEmpty(hdfID.Value))
{
p = new lwg_Genre();
lblNote.Text = "Insert error, please try again";
}
else
{
p = pBiz.GetByID(int.Parse(hdfID.Value));
lblNote.Text = "Update error, please try again";
}
if (p != null)
{
p.Name = txtName.Text;
if (pBiz.SaveGenre(p))
{
BindingGenre();
txtName.Text = string.Empty;
pnEditGenre.Visible = false;
pnListGenre.Visible = true;
return;
}
}
lblNote.Visible = true;
}
protected void rptGenre_ItemCommand(object source, RepeaterCommandEventArgs e)
{
GenerBiz pBiz = new GenerBiz();
lwg_Genre p = pBiz.GetByID(int.Parse(e.CommandArgument.ToString()));
if (e.CommandName.Equals("EDIT"))
{
if (p != null)
{
btnAdd.Text = "Update";
txtTitle.Text = "Update Genre";
hdfID.Value = e.CommandArgument.ToString();
pnEditGenre.Visible = true;
pnListGenre.Visible = false;
txtName.Text = p.Name;
}
}
else if (e.CommandName.Equals("DELETE"))
{
if (p != null)
{
if (pBiz.DeleteGenre(p))
{
BindingGenre();
}
}
}
}
public bool DeleteGenre(lwg_Genre p)
{
if (p != null)
{
List <lwg_CatalogGenre> lst = dbContext.lwg_CatalogGenre.Where(cg => cg.GerneId == p.GerneId).ToList();
if (lst != null && lst.Count > 0)
{
dbContext.lwg_CatalogGenre.RemoveRange(lst);
}
dbContext.lwg_Genre.Remove(p);
dbContext.SaveChanges();
return(true);
}
return(false);
}
protected void dlGenre_Bound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
lwg_Genre obj = (lwg_Genre)e.Item.DataItem;
Label lbl = (Label)e.Item.FindControl("lblNumber");
lbl.Text = (e.Item.ItemIndex + 1).ToString();
lbl = (Label)e.Item.FindControl("lblName");
lbl.Text = obj.Name;
CatalogBiz cService = new CatalogBiz();
lbl = (Label)e.Item.FindControl("lblProductNumber");
lbl.Text = cService.GetTotalCatalogOfGenre(obj.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);
}
