public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
ViewBag.Categories = db.tblCategories.ToList();
ViewBag.Action = "Create New Product";
return(View(new ProductViewModel()));
}
}
else
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
ViewBag.Action = "Edit Product";
ViewBag.Categories = db.tblCategories.ToList();
tblProduct item = db.tblProducts.Where(i => i.ProductId == id).FirstOrDefault();
ProductViewModel itemvm = new ProductViewModel();
itemvm.ProductId = item.ProductId;
itemvm.CategoryId = Convert.ToInt32(item.CategoryId);
itemvm.ProductName = item.ProductName;
itemvm.UnitPrice = item.UnitPrice;
itemvm.SellingPrice = item.SellingPrice;
itemvm.Description = item.Description;
itemvm.Photo = item.Photo;
itemvm.IsSpecial = item.IsSpecial;
return(View(itemvm));
}
}
}
public static List <tblCategory> GetMenus()
{
using (var context = new BhaiDBEntities())
{
return(context.tblCategories.ToList());
}
}
public ActionResult AddOrEdit(ProductViewModel ivm)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
if (ivm.ProductId == 0)
{
tblProduct itm = new tblProduct();
itm.CategoryId = Convert.ToInt32(ivm.CategoryId);
itm.ProductName = ivm.ProductName;
itm.UnitPrice = ivm.UnitPrice;
itm.SellingPrice = ivm.SellingPrice;
itm.Description = ivm.Description;
itm.IsSpecial = ivm.IsSpecial;
HttpPostedFileBase fup = Request.Files["Photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/UserCss/images/" + fup.FileName));
itm.Photo = fup.FileName;
}
}
db.tblProducts.Add(itm);
db.SaveChanges();
ViewBag.Message = "Created Successfully";
}
else
{
tblProduct itm = db.tblProducts.Where(i => i.ProductId == ivm.ProductId).FirstOrDefault();
itm.CategoryId = Convert.ToInt32(ivm.CategoryId);
itm.ProductName = ivm.ProductName;
itm.UnitPrice = ivm.UnitPrice;
itm.SellingPrice = ivm.SellingPrice;
itm.Description = ivm.Description;
itm.IsSpecial = ivm.IsSpecial;
HttpPostedFileBase fup = Request.Files["Photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/UserCss/images/" + fup.FileName));
itm.Photo = fup.FileName;
}
}
db.SaveChanges();
ViewBag.Message = "Updated Successfully";
}
ViewBag.Categories = db.tblCategories.ToList();
return(View(new ProductViewModel()));
}
}
public ActionResult Delete(int id)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
tblProduct sm = db.tblProducts.Where(x => x.ProductId == id).FirstOrDefault();
db.tblProducts.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ViewOrder_Post(int id)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault();
sm.DeliveredStatus = "Confirmed";
db.SaveChanges();
return(RedirectToAction("ManageOrder", "Order"));
}
}
public JsonResult GetData()
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <ProductViewModel> lstitem = new List <ProductViewModel>();
var lst = db.tblProducts.Include("tblCategory").ToList();
foreach (var item in lst)
{
lstitem.Add(new ProductViewModel()
{
ProductId = item.ProductId, CategoryName = item.tblCategory.CategoryName, ProductName = item.ProductName, UnitPrice = item.UnitPrice, SellingPrice = item.SellingPrice, Photo = item.Photo, Description = item.Description
});
}
return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <OrderViewModel> lstorder = new List <OrderViewModel>();
var empList = db.tblOrders.Select(x => new { OrderId = x.OrderId, Firstname = x.Firstname, Lastname = x.Lastname, Address = x.Address, Phone = x.Phone, Total = x.Total, OrderDate = x.OrderDate, DeliveredStatus = x.DeliveredStatus }).ToList();
foreach (var item in empList)
{
lstorder.Add(new OrderViewModel()
{
OrderId = item.OrderId, Firstname = item.Firstname, Lastname = item.Lastname, Address = item.Address, Phone = item.Phone, Total = item.Total.ToString(), OrderDate = item.OrderDate.ToString(), DeliveredStatus = item.DeliveredStatus
});
}
return(Json(new { data = lstorder }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <CategoryViewModel> lst = new List <CategoryViewModel>();
var catList = db.tblCategories.ToList();
foreach (var item in catList)
{
lst.Add(new CategoryViewModel()
{
CategoryId = item.CategoryId, CategoryName = item.CategoryName
});
}
return(Json(new { data = lst }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ViewOrder(int id)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
List <OrderDetailViewModel> lstod = new List <OrderDetailViewModel>();
var empList = db.tblOrderDetails.Where(x => x.OrderId == id).ToList();
foreach (tblOrderDetail item in empList)
{
lstod.Add(new OrderDetailViewModel()
{
ItemId = Convert.ToInt32(item.ProductId), ItemName = item.tblProduct.ProductName, Quantity = Convert.ToInt32(item.Quantity), UnitPrice = Convert.ToDecimal(item.UnitPrice)
});
}
Session.Add("itemlist", lstod);
Session.Add("orderid", id);
return(View(lstod));
}
}
public ActionResult AddOrEdit(tblCategory sm)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
if (sm.CategoryId == 0)
{
db.tblCategories.Add(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(sm).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
// ViewBag.Menus = db.tblMenus.ToList();
return(View(new tblCategory()));
}
}
else
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
// ViewBag.Menus = db.tblMenus.ToList();
return(View(db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault()));
}
}
}
public ActionResult AddOrEdit(CategoryViewModel sm)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
if (sm.CategoryId == 0)
{
tblCategory tb = new tblCategory();
tb.CategoryName = sm.CategoryName;
db.tblCategories.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tblCategory tbm = db.tblCategories.Where(m => m.CategoryId == sm.CategoryId).FirstOrDefault();
tbm.CategoryName = sm.CategoryName;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
ViewBag.Action = "New Category";
return(View(new CategoryViewModel()));
}
}
else
{
using (BhaiDBEntities db = new BhaiDBEntities())
{
CategoryViewModel sub = new CategoryViewModel();
var menu = db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault();
sub.CategoryId = menu.CategoryId;
sub.CategoryName = menu.CategoryName;
ViewBag.Action = "Edit Category";
return(View(sub));
}
}
}
