public ActionResult ItemPerPage(int ID = 0, int TempId = 0)
{
ITEM item = db.ITEMs.Find(ID);
item_lang itemLang = new item_lang();
PageTemplate pageTemp = db.PageTemp.Find(TempId);
int langId = Convert.ToInt32(Session["LanguageId"]);
if (TempId == 0)
{
pageTemp = new PageTemplate();
pageTemp.PageName = "ItemPerPage2";
}
if (item == null)
{
return(View("PageNotFound"));
}
else
{
itemLang = db.item_lang.SingleOrDefault(x => x.item_ID == ID && x.Lang_ID == langId);
if (itemLang == null)
{
itemLang = db.item_lang.SingleOrDefault(x => x.item_ID == ID && x.Lang_ID == 1);
}
}
int itemID = itemLang.ID;
int catID = (int)item.Cat_ID;
itemLang.ItemCustomFieldList = db.Item_CustomField.Where(x => x.item_Id == itemID).ToList();
itemLang.FieldList = db.Field.Where(x => x.ItemLangId == itemID).ToList();
ViewBag.customField = db.Custom_Cat.Where(x => x.Cat_ID == catID).ToList();
return(View(pageTemp.PageName, itemLang));
}
public ActionResult Create(item_lang item, string hiddenname)
{
if (ModelState.IsValid)
{
item_lang it = db.item_lang.Find(item.ID);
ITEM item_per = db.ITEMs.Find(it.item_ID);
if (item.ImageFile != null)
{
FileInfo fi = new FileInfo(item.ImageFile.FileName);
if (fi.Extension != ".jpeg" && fi.Extension != ".jpg" && fi.Extension != ".png" && fi.Extension != ".JPEG" && fi.Extension != ".JPG" && fi.Extension != ".PNG")
{
TempData["Errormsg"] = "Image File Extension is Not valid";
}
else
{
string fileName = Path.GetFileNameWithoutExtension(item.ImageFile.FileName);
string extension = Path.GetExtension(item.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
item.Image = "~/Content/images/Item/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Content/images/Item/"), fileName);
item.ImageFile.SaveAs(fileName);
}
}
else
{
item.Image = it.Image;
}
db.item_lang.Add(item);
db.SaveChanges();
int itemId = Convert.ToInt32(TempData["Data"]);
int CatID = (int)item_per.Cat_ID;
return(RedirectToAction("Index", new { id = itemId, catId = CatID }));
}
return(View(item));
}
//
// GET: /item_lang/Delete/5
public ActionResult Delete(int id = 0, int CatId = 0, int itemlang = 0)
{
item_lang item_lang = db.item_lang.Find(id);
ViewBag.itemlang = itemlang;
if (item_lang == null)
{
return(HttpNotFound());
}
return(View(item_lang));
}
//
// GET: /ITEM/Details/5
public ActionResult Details(int id = 0, int CatId = 0)
{
item_lang item = db.item_lang.Find(id);
ViewBag.CatID = CatId;
if (item == null)
{
return(HttpNotFound());
}
return(View(item));
}
public ActionResult DeleteConfirmed(int id)
{
item_lang item_lan = db.item_lang.Find(id);
ITEM item = db.ITEMs.Find(item_lan.item_ID);
int CatID = (int)item.Cat_ID;
db.ITEMs.Remove(item);
db.SaveChanges();
return(RedirectToAction("Index", new { id = CatID }));
}
public ActionResult DeleteConfirmed(int id)
{
item_lang item_lang = db.item_lang.Find(id);
ITEM item_per = db.ITEMs.Find(item_lang.item_ID);
db.item_lang.Remove(item_lang);
db.SaveChanges();
int itemlang = Convert.ToInt32(TempData["Data"]);
int CatID = (int)item_per.Cat_ID;
return(RedirectToAction("Index", new { id = itemlang, catId = CatID }));
}
//
// GET: /ITEM/Edit/5
public ActionResult Edit(int id = 0, int CatId = 0)
{
item_lang item = db.item_lang.Find(id);
item.FieldList = db.Field.Where(x => x.ItemLangId == item.ID).ToList();
ViewBag.CustField = db.Custom_Cat.Where(x => x.Cat_ID == CatId).ToList();
ViewBag.ItemCustField = db.Item_CustomField.Where(x => x.item_Id == id);
ViewBag.CatID = CatId;
if (item == null)
{
return(HttpNotFound());
}
return(View(item));
}
//
// GET: /item_lang/
public ActionResult Index(int id = 0, int CatId = 0)
{
item_lang it = db.item_lang.Find(id);
int itemId = (int)it.item_ID;
List <Language> lang = db.Language.Where(x => x.Default == false).ToList();
List <item_lang> item = new List <item_lang>();
foreach (Language obj in lang)
{
List <item_lang> itemLang = db.item_lang.Where(x => x.item.Cat_ID == CatId && x.Lang_ID.Value.Equals(obj.ID) && x.item_ID == itemId).ToList();
item.AddRange(itemLang);
}
ViewBag.CatId = CatId;
ViewBag.ItemId = id;
return(View(item));
}
//
// GET: /ITEM/Delete/5
public ActionResult Delete(int id = 0, int CatId = 0)
{
item_lang item = db.item_lang.Find(id);
ViewBag.CatID = CatId;
ViewBag.flag = false;
ITEM item_per = db.ITEMs.Find(item.item_ID);
MenuItem MItem = db.MenuItems.SingleOrDefault(x => x.ItemId == item_per.ID);
if (MItem != null)
{
ViewBag.error = "This Item has reference from MenuItem, So You can not delete it";
ViewBag.flag = true;
}
if (item == null)
{
return(HttpNotFound());
}
return(View(item));
}
//
// GET: /item_lang/Create
public ActionResult Create(int id = 0, int CatId = 0)
{
item_lang item = db.item_lang.Find(id);
ViewBag.item_ID = item.item_ID;
ViewBag.CatID = CatId;
ViewBag.itemlang = id;
List <Language> lang = db.Language.Where(x => x.Default == false).ToList();
List <Language> language = new List <Language>();
foreach (Language obj in lang)
{
item_lang itemLang = db.item_lang.Where(x => x.Lang_ID.Value.Equals(obj.ID) && x.item_ID == item.item_ID).SingleOrDefault();
if (itemLang == null)
{
language.Add(obj);
}
}
ViewBag.Lang_ID = new SelectList(language, "ID", "Name");
return(View(item));
}
public ActionResult Edit(item_lang item, string hiddenname)
{
item_lang it = db.item_lang.Find(item.ID);
item.Lang_ID = it.Lang_ID;
if (ModelState.IsValid)
{
if (item.ImageFile != null && item.ImageFile.FileName != null && item.ImageFile.FileName != "")
{
FileInfo fi = new FileInfo(item.ImageFile.FileName);
if (fi.Extension != ".jpeg" && fi.Extension != ".jpg" && fi.Extension != ".png" && fi.Extension != ".JPEG" && fi.Extension != ".JPG" && fi.Extension != ".PNG")
{
TempData["Errormsg"] = "Image File Extension is Not valid";
}
else
{
string fileName = Path.GetFileNameWithoutExtension(item.ImageFile.FileName);
string extension = Path.GetExtension(item.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
item.Image = "~/Content/images/Item/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Content/images/Item/"), fileName);
item.ImageFile.SaveAs(fileName);
}
}
else
{
item.Image = it.Image;
}
//db.Entry(item).State = EntityState.Modified;
db.Entry(it).CurrentValues.SetValues(item);
db.SaveChanges();
int itemId = Convert.ToInt32(TempData["message"]);
int CatID = Convert.ToInt32(TempData["Data"]);
return(RedirectToAction("Index", new { id = itemId, catId = CatID }));
}
return(View(item));
}
