public ActionResult AddNewCategory(string NewGrocery, String AppId)
{
string uid = Request.Cookies["userId"].Value.ToString();
if (!ModelState.IsValid)
{
return(Json(new { success = false, responseText = "data not saved perfectly" }, JsonRequestBehavior.AllowGet));
}
var groc = db.GroceriesCategory.Where(n => (n.AppUserId == "all" || n.AppUserId == uid) && n.GroceriesName.ToLower() == NewGrocery.ToLower()).SingleOrDefault();
if (groc == null)
{
GroceriesCategories g = new GroceriesCategories()
{
GroceriesName = NewGrocery,
AppUserId = AppId
};
db.GroceriesCategory.Add(g);
db.SaveChanges();
var dbgroc = db.GroceriesCategory.Where(n => (n.AppUserId == "all" || n.AppUserId == uid) && n.GroceriesName.ToLower() == NewGrocery.ToLower()).SingleOrDefault();
return(Json(new { category = dbgroc, success = true, responseText = NewGrocery + " item is added to list" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, responseText = NewGrocery + " name is already Exist In Income List" }, JsonRequestBehavior.AllowGet));
}
}
// GET: GroceriesCategories/Edit/5
public ActionResult Edit(int?id)
{
var acc = User.Identity.GetUserId();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GroceriesCategories groceriesCategories = db.GroceriesCategory.Where(p => p.AppUserId == acc && p.GroceriesCategoriesId == id).FirstOrDefault();
if (groceriesCategories == null)
{
return(HttpNotFound());
}
ViewBag.groceryCat = groceriesCategories.GroceriesName;
var checkGroceryCategory = db.GroceriesLists.Where(c => c.GroceriesCategoriesId == groceriesCategories.GroceriesCategoriesId && c.appUserId == acc).FirstOrDefault();
if (checkGroceryCategory != null)
{
var groceryListRecord = db.GroceriesLists.Where(c => c.GroceriesCategoriesId == groceriesCategories.GroceriesCategoriesId && c.appUserId == acc).ToList();
return(PartialView("PartialEditCheck", groceryListRecord));
}
else
{
return(PartialView("PartialEdit", groceriesCategories));
}
}
public ActionResult DeleteConfirmed(int id)
{
var acc = User.Identity.GetUserId();
//GroceriesCategories groceriesCategories = db.GroceriesCategory.Find(id);
GroceriesCategories gc = db.GroceriesCategory.Where(p => p.AppUserId == acc && p.GroceriesCategoriesId == id).FirstOrDefault();
db.GroceriesCategory.Remove(gc);
db.SaveChanges();
return(Json(new { success = true }));
// return RedirectToAction("Index");
}
// GET: GroceriesCategories/Details/5
public ActionResult Details(int?id)
{
var uid = User.Identity.GetUserId();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GroceriesCategories gc = db.GroceriesCategory.Where(p => p.AppUserId == uid && p.GroceriesCategoriesId == id).FirstOrDefault();
//GroceriesCategories groceriesCategories = db.GroceriesCategory.Find(id);
if (gc == null)
{
return(HttpNotFound());
}
return(View(gc));
}
public ActionResult Edit([Bind(Include = "GroceriesCategoriesId,GroceriesName,Remarks,AppUserId")] GroceriesCategories EditGroceriesListForm)
{
var acc = User.Identity.GetUserId();
if (ModelState.IsValid)
{
var d = db.GroceriesCategory.Where(c => c.GroceriesCategoriesId != EditGroceriesListForm.GroceriesCategoriesId && c.GroceriesName == EditGroceriesListForm.GroceriesName && c.AppUserId == acc).SingleOrDefault();
if (d != null)
{
return(Json(new { success = "AlredyExist" }));
}
db.Entry(EditGroceriesListForm).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = "naveen" }));
//return RedirectToAction("Index");
}
return(Json(new { success = "fails" }));
//return View(groceriesCategories);
}
