public ActionResult Save(Item objItem, HttpPostedFileBase file)
{
ViewBag.IsSaved = false;
db = new krennovaEntities();
if (ModelState.IsValid)
{
try
{
var fileName = "";
if (file.ContentLength > 0)
{
fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Images"), fileName);
string[] file_name = fileName.Split('.');
file.SaveAs(path);
}
objItm.ItemName = objItem.ItemName;
objItm.Price = objItem.Price;
objItm.Category = objItem.Category;
objItm.Image = "Content/Images/" + fileName;
objItm.Description = objItem.Description;
db.Items.Add(objItm);
db.SaveChanges();
ModelState.Clear();
ViewBag.IsSaved = true;
}
catch (Exception)
{
}
}
//objItm.itemList = db.Items.ToList();
ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", objItm.Category);
return(View("AddItem"));
}
public ActionResult Update(Item objItem, int id, HttpPostedFileBase file)
{
try
{
db = new krennovaEntities();
Item objItm = db.Items.Find(id);
var fileName = "";
if (file != null)
{
if (file.ContentLength > 0)
{
fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Images"), fileName);
string[] file_name = fileName.Split('.');
file.SaveAs(path);
objItm.Image = "Content/Images/" + fileName;
}
}
else
{
objItm.Image = objItm.Image;
}
objItm.ItemName = objItem.ItemName;
objItm.Price = objItem.Price;
objItm.Category = objItem.Category;
objItm.Description = objItem.Description;
db.Entry(objItm);
db.SaveChanges();
}
catch
{
}
objItm.itemList = db.Items.ToList();
return(View("Index", objItm.itemList));
}
public ActionResult Index()
{
db = new krennovaEntities();
objItm.itemList = db.Items.ToList();
return(View(objItm.itemList));
}
public ActionResult ViewItem(int Id)
{
db = new krennovaEntities();
Item objItm = db.Items.Find(Id);
return(View(objItm));
}
public ActionResult Items(int?page)
{
int pageSize = 6;
int pageNumber = (page ?? 1);
db = new krennovaEntities();
objItm.itemList = db.Items.OrderBy(i => i.Id).ToPagedList(pageNumber, pageSize);
return(View(objItm.itemList));
}
public ActionResult EditItem(Item objItem, int id)
{
db = new krennovaEntities();
Item itm = db.Items.Find(id);
ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", itm.Category);
return(View(itm));
}
public ActionResult Carpet(int?page)
{
int pageSize = 6;
int pageNumber = (page ?? 1);
db = new krennovaEntities();
//objItm.itemList = db.Items.Where(i => i.Category == 1).ToList();
// objeventGallery.NewsList = newsList.OrderByDescending(i => i.Date).ToPagedList(pageNumber, pageSize);
objItm.itemList = db.Items.Where(i => i.Category == 1).OrderBy(i => i.Id).ToPagedList(pageNumber, pageSize);
return(View(objItm.itemList));
}
public ActionResult Delete(int id)
{
db = new krennovaEntities();
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(id)))
{
Item objItm = db.Items.Find(id);
db.Items.Remove(objItm);
db.SaveChanges();
}
}
catch
{
}
objItm.itemList = db.Items.ToList();
return(View("Index", objItm.itemList));
}
public ActionResult ViewItem(int Id)
{
if (!string.IsNullOrEmpty(Id.ToString()))
{
List <ItemCategoryWrap> model = new List <ItemCategoryWrap>();
try
{
db = new krennovaEntities();
//Item itm = db.Items.Find(Id);
var data = (from i in db.Items
join c in db.Categories on i.Category equals c.Id
where i.Id == Id
select new { i.Id, c.CatName, i.ItemName, i.Price, i.Image, i.Description });
//retrieve each item and assign to model
foreach (var item in data)
{
model.Add(new ItemCategoryWrap()
{
ItemId = item.Id,
ItemName = item.ItemName,
Category = item.CatName,
Image = item.Image,
Price = item.Price,
Description = item.Description
});
}
}
catch
{
}
return(View(model));
}
else
{
return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString()));
}
}
public ActionResult AddItem()
{
db = new krennovaEntities();
ViewBag.Category = new SelectList(db.Categories, "Id", "CatName", objItm.Category);
return(View());
}
