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");
}
}
