public IActionResult updateblog(int id) { //////////////////////////////////////////////////////////////////////////////////list var qlist = db.tbl_category.Where(a => a.FatherIdCat == -2 || a.FatherIdCat == -3).ToList(); var listtb = new List <Tb_Category> (); if (qlist != null) { foreach (var item in qlist) { var qselect = db.tbl_category.Where(a => a.FatherIdCat == item.Id).ToList(); if (qselect.Count() != 0) { foreach (var item1 in qselect) { var b = new Tb_Category() { Id = item1.Id, NameCat = item1.NameCat + " " + "-->" + " " + item.NameCat, FatherIdCat = item1.FatherIdCat }; listtb.Add(b); } } else { listtb.Add(item); } } ViewBag.list = new SelectList(listtb, "Id", "NameCat"); } else { ViewBag.list = null; } //////////////////////////////////////////////////////////////////////////////////list if (err != null) { ViewBag.er = err; err = null; } if (id != null) { Vm_Blog qblog = new Vm_Blog(); var list = db.Tbl_Blog.Where(a => a.Id == id).SingleOrDefault(); qblog.Id = list.Id; qblog.TitleBLo = list.TitleBLo; qblog.Language = list.Language; qblog.IdCtegoryBlo = list.IdCtegoryBlo; qblog.SummaryBlo = list.SummaryBlo; qblog.ImageMainBlo = list.ImageMainBlo; qblog.FullTextBlo = list.FullTextBlo; qblog.KeywordsBlo = list.KeywordsBlo; return(View(qblog)); } return(View()); }
private void fill(int id) { category = db.Tb_Category.Where(z => z.Id == id).FirstOrDefault(); txtcatname.Text = category.Cat_name; // drpunit.SelectedValue = category.Unit; //chkstatus.Checked = category.Status; btnsubmit.Text = "Update"; ViewState["id"] = category.Id; }
protected void btnconfirm_Click(object sender, EventArgs e) { try { int id = Convert.ToInt32(hdndel.Value); category = db.Tb_Category.Where(z => z.Id == id).FirstOrDefault(); db.Tb_Category.Remove(category); db.SaveChanges(); Response.Redirect("~/Admin/ShowCategory.aspx?msg=" + "Dlt"); } catch (Exception ex) { } }
public IActionResult Index() { //////////////////////////////////////////////////////////////////////////////////list var qlist = db.tbl_category.Where(a => a.FatherIdCat == -2 || a.FatherIdCat == -3).ToList(); var listtb = new List <Tb_Category> (); if (qlist != null) { foreach (var item in qlist) { var qselect = db.tbl_category.Where(a => a.FatherIdCat == item.Id).ToList(); if (qselect.Count() != 0) { foreach (var item1 in qselect) { var b = new Tb_Category() { Id = item1.Id, NameCat = item1.NameCat + " " + "-->" + " " + item.NameCat, FatherIdCat = item1.FatherIdCat }; listtb.Add(b); } } else { listtb.Add(item); } } ViewBag.list = new SelectList(listtb, "Id", "NameCat"); } else { ViewBag.list = null; } //////////////////////////////////////////////////////////////////////////////////list if (err != null) { ViewBag.er = err; err = null; } return(View()); }
public IActionResult add(Vm_Category cat) { var qcat = db.tbl_category.Where(a => a.NameCat == cat.NameCat && a.FatherIdCat == cat.FatherIdCat).SingleOrDefault(); if (qcat != null) { err = "این نام قبلا ثبت شده است"; } else { var tbcat = new Tb_Category() { Language = cat.Language, NameCat = cat.NameCat, FatherIdCat = cat.FatherIdCat }; db.tbl_category.Add(tbcat); db.SaveChanges(); suc = "اطلاعات با موفقیت ثبت شد"; } return(RedirectToAction("index")); }
protected void btnsubmit_Click(object sender, EventArgs e) { if (btnsubmit.Text == "Submit") { category.Cat_name = txtcatname.Text; //category.Unit = drpunit.SelectedValue; //category.Status = chkstatus.Checked; db.Tb_Category.Add(category); db.SaveChanges(); clear(); Response.Redirect("~/Admin/ShowCategory.aspx?msg=" + "Svd"); } else { category = db.Tb_Category.Find(Convert.ToInt32(ViewState["id"])); category.Cat_name = txtcatname.Text; // category.Unit = drpunit.SelectedValue; //category.Status = chkstatus.Checked; db.SaveChanges(); clear(); Response.Redirect("~/Admin/ShowCategory.aspx?msg=" + "upd"); } }
public IActionResult update(int id) { //////////////////////////////////////////////////////////////////////////////////list var qlist = db.tbl_category.Where(a => a.FatherIdCat == -1).ToList(); var listtb = new List <Tb_Category> (); if (qlist != null) { foreach (var item in qlist) { var qselect = db.tbl_category.Where(a => a.FatherIdCat == item.Id).ToList(); if (qselect.Count() != 0) { foreach (var item1 in qselect) { var b = new Tb_Category() { Id = item1.Id, NameCat = item1.NameCat + " " + "-->" + " " + item.NameCat, FatherIdCat = item1.FatherIdCat }; listtb.Add(b); } } else { listtb.Add(item); } } ViewBag.list = new SelectList(listtb, "Id", "NameCat"); } else { ViewBag.list = null; } //////////////////////////////////////////////////////////////////////////////////list var qproduct = db.Tbl_Product.Where(a => a.Id == id).SingleOrDefault(); var qgallery = db.tb_GalleryProducts.Where(a => a.IdProduct == id).ToList(); List <string> h = new List <string>(); foreach (var item in qgallery) { h.Add(item.ImagePath); } Vm_Product qp = new Vm_Product() { Id = qproduct.Id, TitleProductPro = qproduct.TitleProductPro, ImageMainPro = qproduct.ImageMainPro, CategoryIdPro = qproduct.CategoryIdPro, PricePro = qproduct.PricePro, OfferPro = qproduct.OfferPro, SizePro = qproduct.SizePro, ColorPro = qproduct.ColorPro, BrandPro = qproduct.BrandPro, MaterialPro = qproduct.MaterialPro, TotalPro = qproduct.TotalPro, DescreptionPro = qproduct.DescreptionPro, Language = qproduct.Language, }; ViewBag.img = h; return(View(qp)); }