public ActionResult DbSearchresult(Goods_Subcategory goods_subcategory) { //Queue q = new Queue(); if (goods_subcategory.goods_subcategory_name != null && goods_subcategory.goods_category_id != 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_subcategory_name.StartsWith(goods_subcategory.goods_subcategory_name) && gs.goods_category_id == goods_subcategory.goods_category_id select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id }; return View("Index", result.ToList()); } else if (goods_subcategory.goods_subcategory_name == null && goods_subcategory.goods_category_id != 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_category_id == goods_subcategory.goods_category_id select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id }; return View("Index", result.ToList()); } else if (goods_subcategory.goods_subcategory_name != null && goods_subcategory.goods_category_id == 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_subcategory_name.StartsWith(goods_subcategory.goods_subcategory_name) select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id }; return View("Index", result.ToList()); } return RedirectToAction("Index"); }
public ActionResult Create(Goods_Subcategory goods_subcategory) { if (ModelState.IsValid) { var is_exist = (from gs in db.Goods_Subcategory where gs.goods_subcategory_name == goods_subcategory.goods_subcategory_name select gs).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Subcategory Already Exist"; } else { goods_subcategory.status_id = 1; goods_subcategory.created_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); goods_subcategory.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Goods_Subcategory.Add(goods_subcategory); db.SaveChanges(); TempData["errorMessage"] = "Subcategory Added Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); }
public ActionResult Edit(Goods_Subcategory goods_subcategory) { var subcategory_id = Convert.ToInt32(TempData["subcategory_id"]); Goods_Subcategory goods_subcategory_new = db.Goods_Subcategory.Find(subcategory_id); if (ModelState.IsValid) { var is_exist = (from gs in db.Goods_Subcategory where gs.goods_subcategory_name == goods_subcategory.goods_subcategory_name && gs.goods_subcategory_id != subcategory_id select gs).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Subcategory Already Exist"; } else { goods_subcategory_new.goods_category_id = goods_subcategory.goods_category_id; goods_subcategory_new.goods_subcategory_name = goods_subcategory.goods_subcategory_name; goods_subcategory_new.status_id = goods_subcategory.status_id; goods_subcategory_new.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Entry(goods_subcategory_new).State = EntityState.Modified; db.SaveChanges(); TempData["errorMessage"] = "Edited Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); }
public ActionResult DbSearchresult(Goods_Subcategory goods_subcategory) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(2)) { //Queue q = new Queue(); if (goods_subcategory.goods_subcategory_name != null && goods_subcategory.goods_category_id != 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_subcategory_name.StartsWith(goods_subcategory.goods_subcategory_name) && gs.goods_category_id == goods_subcategory.goods_category_id select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id, goods_subcategory_code = gs.goods_subcategory_code }; return View("Index", result.ToList()); } else if (goods_subcategory.goods_subcategory_name == null && goods_subcategory.goods_category_id != 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_category_id == goods_subcategory.goods_category_id select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id, goods_subcategory_code = gs.goods_subcategory_code }; return View("Index", result.ToList()); } else if (goods_subcategory.goods_subcategory_name != null && goods_subcategory.goods_category_id == 0) { var result = from gs in db.Goods_Subcategory join gc in db.Goods_Category on gs.goods_category_id equals gc.goods_category_id where gs.goods_subcategory_name.StartsWith(goods_subcategory.goods_subcategory_name) select new Goods_Sub_CategoryModel { goods_subcategory_id = gs.goods_subcategory_id, goods_subcategory_name = gs.goods_subcategory_name, goods_category = gc.goods_category_name, status_id = gs.status_id, goods_subcategory_code = gs.goods_subcategory_code }; return View("Index", result.ToList()); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }