public ActionResult Create(string id) { if ((Request.Cookies["Username"] == null)) { return RedirectToAction("LoginIndex", "Login"); } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } if (ClsCheckRole.CheckQuyen(8, 1, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } ViewBag.MutilMenu = new SelectList(carlist, "Value", "Text"); var menuModels = db.TblGroupImage.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList(); var lstMenus = new List<SelectListItem>(); lstMenus.Clear(); foreach (var menu in menuModels) { lstMenus.Add(new SelectListItem { Text = menu.Name, Value = menu.Id.ToString() }); } if (id != null && id != "") ViewBag.drMenu = new SelectList(lstMenus, "Value", "Text", id); else ViewBag.drMenu = lstMenus; var pro = db.TblImage.OrderByDescending(p => p.Ord).Take(1).ToList(); if (id != null && id != "") { int idcates = int.Parse(id); pro = db.TblImage.Where(p => p.IdCate == idcates).OrderByDescending(p => p.Ord).Take(1).ToList(); } if (pro.Count > 0) ViewBag.Ord = pro[0].Ord + 1; else ViewBag.Ord = "1"; var Manufacture = db.TblManufactures.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList(); var lstmanu = new List<SelectListItem>(); foreach (var item in Manufacture) { lstmanu.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); } ViewBag.mutilManu = new SelectList(lstmanu, "Value", "Text"); return View(); } else { return Redirect("/Users/Erro"); } }
public ActionResult Edit(int?id) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(5, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { Session["id"] = id.ToString(); Int32 ids = Int32.Parse(id.ToString()); tblNew tblnews = db.tblNews.Find(ids); if (tblnews == null) { return(HttpNotFound()); } var menuModel = db.tblGroupNews.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturns = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListNews(item.id, carlist, strReturns); strReturns = "---"; } int idGroups = 0; if (tblnews.idCate != null) { idGroups = int.Parse(tblnews.idCate.ToString()); } ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idGroups); var menuModelProduct = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlistProduct.Clear(); string strReturn = "---"; foreach (var item in menuModelProduct) { carlistProduct.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlistProduct, strReturn); strReturn = "---"; } var ListNews = db.tblConnectNews.Where(p => p.idNew == id).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < ListNews.Count; i++) { mang.Add(int.Parse(ListNews[i].idCate.ToString())); } ViewBag.MutilMenu = new MultiSelectList(carlistProduct, "Value", "Text", mang); return(View(tblnews)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id = 0) { if ((Request.Cookies["Username"] == null)) { return RedirectToAction("LoginIndex", "Login"); } if (ClsCheckRole.CheckQuyen(8, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { TblImage TblImage = db.TblImage.Find(id); var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } var ListManu = db.TblConnectImages.Where(p => p.IdImg == id).ToList(); List<int> mang = new List<int>(); for (int i = 0; i < ListManu.Count; i++) { mang.Add(int.Parse(ListManu[i].IdCate.ToString())); } ViewBag.MutilMenu = new MultiSelectList(carlist, "Value", "Text", mang); var Manufacture = db.TblManufactures.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList(); var listIdManu = db.TblConnectManuToImages.Where(p => p.IdImage == id).Select(p => p.IdManu).ToList(); var lstmanu = new List<SelectListItem>(); foreach (var item in Manufacture) { lstmanu.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); } ViewBag.mutilManu = new MultiSelectList(lstmanu, "Value", "Text", listIdManu); int idCate = int.Parse(TblImage.IdCate.ToString()); var menuModels = db.TblGroupImage.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList(); var lstMenus = new List<SelectListItem>(); lstMenus.Clear(); foreach (var menu in menuModels) { lstMenus.Add(new SelectListItem { Text = menu.Name, Value = menu.Id.ToString() }); } ViewBag.drMenu = new SelectList(lstMenus, "Value", "Text", idCate); if (TblImage == null) { return HttpNotFound(); } return View(TblImage); } else { return Redirect("/Users/Erro"); } }
public ActionResult Create(string id) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } carlist.Clear(); if (ClsCheckRole.CheckQuyen(4, 1, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } ViewBag.drMenu = new SelectList(carlist, "Value", "Text", id); var pro = db.tblGroupProducts.OrderByDescending(p => p.Ord).Take(1).ToList(); if (id == "") { pro = db.tblGroupProducts.Where(p => p.ParentID == null).OrderByDescending(p => p.Ord).Take(1).ToList(); } else { int ids = int.Parse(id); pro = db.tblGroupProducts.Where(p => p.ParentID == ids).OrderByDescending(p => p.Ord).ToList(); } if (pro.Count > 0) { ViewBag.Ord = pro[0].Ord + 1; } else { ViewBag.Ord = "1"; } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } return(View()); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id) { carlist.Clear(); if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { tblGroupProduct tblgroupproduct = db.tblGroupProducts.First(p => p.id == id); if (tblgroupproduct == null) { return(HttpNotFound()); } ViewBag.id = id; var menuName = db.tblGroupProducts.ToList(); var pro = db.tblGroupProducts.OrderByDescending(p => p.Ord).Take(1).ToList(); var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); string strReturn = "---"; carlist.Clear(); foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } int idParent = 0; string kiemtra = tblgroupproduct.ParentID.ToString(); if (kiemtra != null && kiemtra != "") { idParent = int.Parse(tblgroupproduct.ParentID.ToString()); ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idParent); } else { ViewBag.drMenu = carlist; } return(View(tblgroupproduct)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id = 0) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(6, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { tblCriteria tblcriteria = db.tblCriterias.Find(id); //int idCate = int.Parse(tblcriteria.idCate.ToString()); var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null && m.Active == true).OrderBy(m => m.Ord).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } var listcri = db.tblGroupCriterias.Where(p => p.idCri == id).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < listcri.Count; i++) { mang.Add(int.Parse(listcri[i].idCate.ToString())); } ViewBag.MutilMenu = new MultiSelectList(carlist, "Value", "Text", mang); if (tblcriteria == null) { return(HttpNotFound()); } return(View(tblcriteria)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id = 0) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(8, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { TblManufactures tblmanu = db.TblManufactures.Find(id); //int idCate = int.Parse(TblCriteria.IdCate.ToString()); var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } var ListManu = db.TblConnectManuProduct.Where(p => p.IdManu == id).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < ListManu.Count; i++) { mang.Add(int.Parse(ListManu[i].IdCate.ToString())); } ViewBag.MutilMenu = new MultiSelectList(carlist, "Value", "Text", mang); if (tblmanu == null) { return(HttpNotFound()); } return(View(tblmanu)); } else { return(Redirect("/Users/Erro")); } }
// GET: Web public ActionResult Index(string idCate, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(7, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var ListCriteria = db.TblCriteria.OrderBy(m => m.Ord).ToList(); var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } if (idCate != "") { ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idCate); ViewBag.IdCate = idCate; ViewBag.IdMenu = idCate; } else { ViewBag.drMenu = carlist; } if (collection["btnDelete"] != null) { foreach (string key in Request.Form.Keys) { var checkbox = ""; if (key.StartsWith("chk_")) { checkbox = Request.Form["" + key]; if (checkbox != "false") { if (ClsCheckRole.CheckQuyen(7, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { int id = Convert.ToInt32(key.Remove(0, 4)); var TblWeb = db.TblWeb.Find(id); db.TblWeb.Remove(TblWeb); db.SaveChanges(); var ListWeb = db.TblConnectWebs.Where(p => p.IdWeb == id).ToList(); for (int i = 0; i < ListWeb.Count; i++) { db.TblConnectWebs.Remove(ListWeb[i]); db.SaveChanges(); } } else { return(Redirect("/Users/Erro")); } } } } //dsd } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } return(View()); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id = 0) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(8, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { tblImage tblimages = db.tblImages.Find(id); var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } var ListManu = db.tblConnectImages.Where(p => p.idImg == id && p.type == 0).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < ListManu.Count; i++) { mang.Add(int.Parse(ListManu[i].idCate.ToString())); } ViewBag.MutilMenu = new MultiSelectList(carlist, "Value", "Text", mang); var listCapacity = db.tblCapacities.OrderBy(m => m.id).ToList(); List <SelectListItem> carlistcap = new List <SelectListItem>(); foreach (var item in listCapacity) { carlistcap.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); } var ListManucap = db.tblConnectImages.Where(p => p.idImg == id && p.type == 1).ToList(); List <int> mang1 = new List <int>(); for (int i = 0; i < ListManucap.Count; i++) { mang1.Add(int.Parse(ListManucap[i].idCate.ToString())); } ViewBag.drMenuCap = new SelectList(carlistcap, "Value", "Text", mang1); int idCate = int.Parse(tblimages.idCate.ToString()); var menuModels = db.tblGroupImages.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList(); var lstMenus = new List <SelectListItem>(); lstMenus.Clear(); foreach (var menu in menuModels) { lstMenus.Add(new SelectListItem { Text = menu.Name, Value = menu.id.ToString() }); } ViewBag.drMenu = new SelectList(lstMenus, "Value", "Text", idCate); if (tblimages == null) { return(HttpNotFound()); } return(View(tblimages)); } else { return(Redirect("/Users/Erro")); } }
// GET: InfoCriteria public ActionResult Index(string id, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(6, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var ListCriteria = db.tblInfoCriterias.OrderBy(m => m.Ord).ToList(); var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlists.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlists.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlists, strReturn); strReturn = "---"; } if (id != "") { ViewBag.drMenu = carlists; ViewBag.idCate = id; ViewBag.idMenu = id; } else { ViewBag.drMenu = carlists; } if (collection["btnDelete"] != null) { foreach (string key in Request.Form.Keys) { var checkbox = ""; if (key.StartsWith("chk_")) { checkbox = Request.Form["" + key]; if (checkbox != "false") { if (ClsCheckRole.CheckQuyen(6, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { int ids = Convert.ToInt32(key.Remove(0, 4)); tblInfoCriteria tblcriteria = db.tblInfoCriterias.Find(ids); db.tblInfoCriterias.Remove(tblcriteria); db.SaveChanges(); } else { return(Redirect("/Users/Erro")); } } } } //dsd } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } return(View()); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int id) { carlist.Clear(); if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { TblGroupProduct TblGroupProduct = db.TblGroupProduct.First(p => p.Id == id); if (TblGroupProduct == null) { return(HttpNotFound()); } ViewBag.Id = id; var menuName = db.TblGroupProduct.ToList(); var pro = db.TblGroupProduct.OrderByDescending(p => p.Ord).Take(1).ToList(); var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); string strReturn = "---"; carlist.Clear(); foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } int idParent = 0; string kiemtra = TblGroupProduct.ParentId.ToString(); if (kiemtra != null && kiemtra != "") { idParent = int.Parse(TblGroupProduct.ParentId.ToString()); ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idParent); } else { ViewBag.drMenu = carlist; } var MenuGroup = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlistGroup.Clear(); var listIdGroup = db.TblConnectGroupProduct.Where(p => p.Idg == id).Select(p => p.Idg).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < listIdGroup.Count; i++) { mang.Add(listIdGroup[i].Value); } string strReturnGrup = "---"; foreach (var item in MenuGroup) { carlistGroup.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlistGroup, strReturnGrup); strReturnGrup = "---"; } ViewBag.MutilMenuGroup = new MultiSelectList(carlistGroup, "Value", "Text", mang); return(View(TblGroupProduct)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Edit(int?id) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { Session["id"] = id.ToString(); Int32 ids = Int32.Parse(id.ToString()); tblProduct tblproduct = db.tblProducts.Find(ids); if (tblproduct == null) { return(HttpNotFound()); } var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } int idGroups = 0; if (tblproduct.idCate != null) { idGroups = int.Parse(tblproduct.idCate.ToString()); } ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idGroups); int idCates = int.Parse(tblproduct.idCate.ToString()); var Listconnectcre = db.tblGroupCriterias.Where(p => p.idCate == idCates).ToList(); List <int> Mang = new List <int>(); for (int i = 0; i < Listconnectcre.Count; i++) { Mang.Add(int.Parse(Listconnectcre[i].idCri.ToString())); } var listCre = db.tblCriterias.Where(p => Mang.Contains(p.id)).ToList(); string chuoi = ""; for (int i = 0; i < listCre.Count; i++) { chuoi += "<tr>"; chuoi += "<td class=\"key\">" + listCre[i].Name + ""; chuoi += "</td>"; chuoi += "<td>"; int idcre = int.Parse(listCre[i].id.ToString()); var listInfo = db.tblInfoCriterias.Where(p => p.idCri == idcre && p.Active == true).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listInfo.Count; j++) { int idchk = int.Parse(listInfo[j].id.ToString()); var listCheck = db.tblConnectCriterias.Where(p => p.idCre == idchk && p.idpd == ids).ToList(); chuoi += " <div class=\"boxcheck\">"; if (listCheck.Count > 0) { chuoi += "<input type=\"checkbox\" name=\"chkCre_" + listInfo[j].id + "\" checked=\"checked\" id=\"chkCre_" + listInfo[j].id + "\" />" + listInfo[j].Name + ""; } else { chuoi += "<input type=\"checkbox\" name=\"chkCre_" + listInfo[j].id + "\" id=\"chkCre_" + listInfo[j].id + "\" />" + listInfo[j].Name + ""; } chuoi += "</div>"; } chuoi += "</td>"; chuoi += "</tr>"; } ViewBag.chuoi = chuoi; return(View(tblproduct)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Create(string id) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } if (ClsCheckRole.CheckQuyen(4, 1, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } if (id != "") { int ids = int.Parse(id); var pro = db.tblProducts.Where(p => p.idCate == ids).OrderByDescending(p => p.Ord).Take(1).ToList(); ViewBag.drMenu = new SelectList(carlist, "Value", "Text", id); int idcate = int.Parse(id.ToString()); pro = db.tblProducts.Where(p => p.idCate == idcate).OrderByDescending(p => p.Ord).Take(1).ToList(); if (pro.Count > 0) { ViewBag.Ord = pro[0].Ord + 1; } else { ViewBag.Ord = "1"; } int idCates = int.Parse(id); var Listconnectcre = db.tblGroupCriterias.Where(p => p.idCate == idCates).ToList(); List <int> Mang = new List <int>(); for (int i = 0; i < Listconnectcre.Count; i++) { Mang.Add(int.Parse(Listconnectcre[i].idCri.ToString())); } var listCre = db.tblCriterias.Where(p => Mang.Contains(p.id)).ToList(); string chuoi = ""; for (int i = 0; i < listCre.Count; i++) { chuoi += "<tr>"; chuoi += "<td class=\"key\">" + listCre[i].Name + ""; chuoi += "</td>"; chuoi += "<td>"; int idcre = int.Parse(listCre[i].id.ToString()); var listInfo = db.tblInfoCriterias.Where(p => p.idCri == idcre && p.Active == true).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listInfo.Count; j++) { chuoi += " <div class=\"boxcheck\">"; chuoi += "<label><input type=\"checkbox\" name=\"chkCre_" + listInfo[j].id + "\" id=\"chkCre_" + listInfo[j].id + "\" />" + listInfo[j].Name + "</label>"; chuoi += "</div>"; } chuoi += "</td>"; chuoi += "</tr>"; } ViewBag.chuoi = chuoi; } else { ViewBag.drMenu = carlist; var pro = db.tblProducts.OrderByDescending(p => p.Ord).Take(1).ToList(); if (pro.Count > 0) { ViewBag.Ord = pro[0].Ord + 1; } } return(View()); } else { return(Redirect("/Users/Erro")); } }
// GET: Productad public ActionResult Index(int?page, string text, string idCate, string pageSizes, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { #region [Load Menu] var pro = db.tblGroupProducts.OrderByDescending(p => p.Ord).Take(1).ToList(); var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } if (idCate != "") { ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idCate); ViewBag.idCate = idCate; ViewBag.idMenu = idCate; } else { ViewBag.drMenu = carlist; } #endregion if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } if (collection["btnDelete"] != null) { foreach (string key in Request.Form.Keys) { var checkbox = ""; if (key.StartsWith("chk_")) { checkbox = Request.Form["" + key]; if (checkbox != "false") { if (ClsCheckRole.CheckQuyen(4, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { int id = Convert.ToInt32(key.Remove(0, 4)); tblProduct tblproduct = db.tblProducts.Find(id); int ord = int.Parse(tblproduct.Ord.ToString()); int idCates = int.Parse(tblproduct.idCate.ToString()); var kiemtra = db.tblProducts.Where(p => p.Ord > ord && p.idCate == idCates).ToList(); if (kiemtra.Count > 0) { var listproduct = db.tblProducts.Where(p => p.Ord > ord && p.idCate == idCates).ToList(); for (int i = 0; i < listproduct.Count; i++) { int idp = int.Parse(listproduct[i].id.ToString()); var ProductUpdate = db.tblProducts.Find(idp); ProductUpdate.Ord = ProductUpdate.Ord - 1; db.SaveChanges(); } } db.tblProducts.Remove(tblproduct); db.SaveChanges(); clsSitemap.DeteleSitemap(id.ToString(), "Product"); } else { return(Redirect("/Users/Erro")); } } } } //dsd } return(View()); } else { return(Redirect("/Users/Erro")); } }
public PartialViewResult PartialProductData(int?page, string text, string idCate, string pageSizes) { var listProduct = db.tblProducts.OrderByDescending(p => p.DateCreate).ToList(); int pageSize = 20; var pageNumber = (page ?? 1); var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; if (Request.IsAjaxRequest()) { int idCatelogy; if (pageSizes != null) { ViewBag.pageSizes = pageSizes; pageSize = int.Parse(pageSizes.ToString()); ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + pageSize + "</span> / <span style='color: #333;'>" + listProduct.Count.ToString() + "</span>"; return(PartialView("PartialProductData", listProduct.ToPagedList(pageNumber, pageSize))); } if (text != null && text != "") { listProduct = db.tblProducts.Where(p => p.Name.ToUpper().Contains(text.ToUpper())).OrderByDescending(p => p.DateCreate).ToList(); ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + listProduct.Count + "</span> "; return(PartialView("PartialProductData", listProduct.ToPagedList(pageNumber, pageSize))); } if (idCate != null && idCate != "") { ViewBag.idcate = idCate; idCatelogy = int.Parse(idCate); listProduct = db.tblProducts.Where(p => p.idCate == idCatelogy).OrderByDescending(p => p.DateCreate).ToList(); ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + listProduct.Count + "</span> "; ViewBag.idMenu = idCate; return(PartialView("PartialProductData", listProduct.ToPagedList(pageNumber, pageSize))); } else { listProduct = db.tblProducts.OrderByDescending(p => p.Ord).ToList(); } } if (pageSizes != null) { ViewBag.pageSizes = pageSizes; pageSize = int.Parse(pageSizes.ToString()); } ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + pageSize + "</span> / <span style='color: #333;'>" + listProduct.Count.ToString() + "</span>"; var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } if (text != null && text != "") { listProduct = db.tblProducts.Where(p => p.Name.ToUpper().Contains(text.ToUpper())).OrderByDescending(p => p.DateCreate).ToList(); ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + listProduct.Count + "</span> "; ViewBag.Text = text; return(PartialView("PartialProductData", listProduct.ToPagedList(pageNumber, pageSize))); } if (idCate != null && idCate != "") { int idcates = int.Parse(idCate); listProduct = db.tblProducts.Where(p => p.idCate == idcates && p.Active == true).OrderByDescending(p => p.DateCreate).ToList(); ViewBag.idMenu = idCate; ViewBag.idcate = idCate; ViewBag.ddlMenu = carlist; return(PartialView(listProduct.ToPagedList(pageNumber, pageSize))); } else { ViewBag.ddlMenu = carlist; listProduct = db.tblProducts.Where(p => p.Active == true).OrderByDescending(p => p.DateCreate).ToList(); return(PartialView(listProduct.ToPagedList(pageNumber, pageSize))); } return(PartialView(listProduct.ToPagedList(pageNumber, pageSize))); }
public PartialViewResult TopPartial() { tblConfig config = db.tblConfigs.FirstOrDefault(); var Menu = db.tblGroupProducts.Where(p => p.ParentID == null && p.Active == true).OrderBy(p => p.Ord).ToList(); StringBuilder Chuoi = new StringBuilder(); for (int i = 0; i < Menu.Count; i++) { Chuoi.Append("<li class=\"li1\">"); Chuoi.Append(" <a href=\"/ListProduct/" + Menu[i].Tag + "-" + Menu[i].id + ".aspx\" title=\"" + Menu[i].Name + "\">" + Menu[i].Name + "</a>"); int idCate = Menu[i].id; var Menu1 = db.tblGroupProducts.Where(p => p.ParentID == idCate && p.Active == true).OrderBy(p => p.Ord).ToList(); if (Menu1.Count > 0) { Chuoi.Append("<ul class=\"ul2\">"); for (int j = 0; j < Menu1.Count; j++) { Chuoi.Append("<li class=\"li2\">"); Chuoi.Append("<a href=\"/ListProduct/" + Menu1[j].Tag + "-" + Menu1[j].id + ".aspx\" title=\"" + Menu1[j].Name + "\">" + Menu1[j].Name + "</a>"); int idCate1 = Menu1[j].id; var Menu2 = db.tblGroupProducts.Where(p => p.ParentID == idCate1 && p.Active == true).OrderBy(p => p.Ord).ToList(); if (Menu2.Count > 0) { Chuoi.Append("<ul class=\"ul3\">"); for (int k = 0; k < Menu2.Count; k++) { Chuoi.Append("<li class=\"li3\">"); Chuoi.Append("<a href=\"/ListProduct/" + Menu2[k].Tag + "-" + Menu2[k].id + ".aspx\" title=\"" + Menu2[k].Name + "\">› " + Menu2[k].Name + "</a>"); Chuoi.Append(" </li>"); } Chuoi.Append("</ul>"); } Chuoi.Append("</li>"); } Chuoi.Append("</ul>"); } Chuoi.Append(" </li>"); } ViewBag.Menu = Chuoi; if (Request.Browser.IsMobileDevice) { var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.id.ToString() }); StringClass.DropDownListFor(item.id, carlist, strReturn); strReturn = "---"; } ViewBag.one = carlist; } return(PartialView(config)); }