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