//public JsonResult GetCategory()
//{
// List<ProductCategory> details = new List<ProductCategory>();
// SqlConnection con = new SqlConnection("Data Source=(Localdb)\\MSSQLLocalDB;Initial Catalog=Application;integrated Security=True");
// DataSet ds = new DataSet();
// SqlDataAdapter da = new SqlDataAdapter("select * from ProductCategory", con);
// da.Fill(ds);
// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// ProductCategory category = new ProductCategory();
// category.CategoryName = ds.Tables[0].Rows[i]["CategoryName"].ToString();
// details.Add(category);
// }
// return Json(details, JsonRequestBehavior.AllowGet);
//}
public ActionResult ShowData()
{
//var constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
//DataContext dc = new DataContext(constr);
ApplicationCategoryEntities db = new ApplicationCategoryEntities();
List <ProductCategory> lst = db.ProductCategories.ToList();
return(Json(lst, JsonRequestBehavior.AllowGet));
}
public JsonResult Create(ProductCategory category)
{
using (ApplicationCategoryEntities entitiesCategory = new ApplicationCategoryEntities())
{
entitiesCategory.ProductCategories.Add(category);
entitiesCategory.SaveChanges();
}
return(Json(category));
}
public ActionResult DeleteCategory(int categoryId)
{
using (ApplicationCategoryEntities entities = new ApplicationCategoryEntities())
{
ProductCategory categoryList = (from c in entities.ProductCategories
where c.CategoryId == categoryId
select c).FirstOrDefault();
entities.ProductCategories.Remove(categoryList);
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateCategory(ProductCategory category)
{
using (ApplicationCategoryEntities entities = new ApplicationCategoryEntities())
{
ProductCategory updatedList = (from c in entities.ProductCategories
where c.CategoryId == category.CategoryId
select c).FirstOrDefault();
updatedList.CategoryName = category.CategoryName;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult Index()
{
ApplicationCategoryEntities entitiesCategory = new ApplicationCategoryEntities();
return(View(entitiesCategory.ProductCategories));
}
