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