public JsonResult save(OrderMaster order) { bool status = false; DateTime dateOrg; var isValidDate = DateTime.TryParseExact(order.OrderDate.ToShortDateString(), "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrg); if (isValidDate) { order.OrderDate = dateOrg; } var isValidModel = TryUpdateModel(order); if (isValidModel) { using (TestMasDetEntities dc = new TestMasDetEntities()) { dc.OrderMasters.Add(order); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult getProducts(int categoryID) { List <Product> products = new List <Product>(); using (TestMasDetEntities dc = new TestMasDetEntities()) { products = dc.Products.Where(a => a.CategoryID.Equals(categoryID)).OrderBy(a => a.ProductName).ToList(); } return(new JsonResult { Data = products, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult getProductCategories() { List <Category> categories = new List <Category>(); using (TestMasDetEntities dc = new TestMasDetEntities()) { categories = dc.Categories.OrderBy(a => a.CategoryName).ToList(); } return(new JsonResult { Data = categories, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }