public ActionResult Save(OrderMaster order) { bool status = false; DateTime dateOrg; var isValidDate = DateTime.TryParseExact(order.OrderDate.ToString(), "mm-dd-yyyy", null, DateTimeStyles.None, out dateOrg); if (isValidDate) { order.OrderDate = dateOrg; } var isValidModel = TryUpdateModel(order); if (isValidModel) { using (MasterDetailsEntities db = new MasterDetailsEntities()) { db.OrderMasters.Add(order); db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult GetProducts(int CategoryId) { // list of categories List <Product> products = new List <Product>(); // using entity model to fetch categories from database using (MasterDetailsEntities db = new MasterDetailsEntities()) { products = db.Products.Where(w => w.CategoryId.Equals(CategoryId)).OrderBy(o => o.ProductName).ToList(); } // return json return(new JsonResult { Data = products, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetProductCategories() { // list of categories List <Category> categories = new List <Category>(); // using entity model to fetch categories from database using (MasterDetailsEntities db = new MasterDetailsEntities()) { categories = db.Categories.OrderBy(o => o.CategoryName).ToList(); } // return json return(new JsonResult { Data = categories, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }