public ActionResult GetDataResultJson() { if (User.Identity.Name.Trim() != "") { var context = new Models.Sys.ModelSystem(); var list = (from c in context.sysCountries where c.IsDeleted == false orderby c.Order select new { Avata = c.Avata, Code = c.Code, Description = c.Description, ID = c.ID, IsDeleted = c.IsDeleted, Name = c.Name, Order = c.Order, ZipCode = c.ZipCode }).ToList(); return(Json(new { data = list }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { data = "null" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetListDataResult() { var context = new Models.Sys.ModelSystem(); var list = (from c in context.sysCountries where c.IsDeleted == false orderby c.Order select c).ToList(); ViewData["ListCountry"] = list; return(View(ViewData["ListCountry"])); }
// Create public ActionResult Create(HttpPostedFileBase file, string Code, string Name, string ZipCode, string Order, string Description) { if (ModelState.IsValid) //checking model is valid or not { if (Name != null && Name.Trim() != "") { var context = new Models.Sys.ModelSystem(); var obj = new Models.Sys.sysCountry(); if (file != null && file.ContentLength > 0) { obj.Avata = Beanber.Utility.DTWebSettings.IOHelper.FileUploadAndResizeFromStream("Uploads/Avata", 300, file.InputStream); } else { obj.Avata = "Images/noimage.jpg"; } obj.Code = Code; obj.Description = Description; obj.IsDeleted = false; obj.Name = Name; if (Order.Trim() != "") { obj.Order = Convert.ToInt32(Order); } else { obj.Order = 1; } obj.ZipCode = ZipCode; context.sysCountries.Add(obj); if (context.SaveChanges() > 0) { // Insert succsessful. ViewBag.Message = "Create new successful!"; } ModelState.Clear(); //clearing model } else { ViewBag.Message = "Name is not null. Please try again!"; } } else { ViewBag.Message = "Create new fail!"; ModelState.AddModelError("", "Error in saving data"); } return(View()); }
// Delete public ActionResult Delete(Int32 id) { if (User.Identity.Name.Trim() != "") { var context = new Models.Sys.ModelSystem(); var obj = context.sysCountries.Find(id); obj.IsDeleted = true; if (context.SaveChanges() > 0) { // Deleted successful return(RedirectToAction("", "Country")); } else { return(View()); } } else { return(View()); } }