public ActionResult AngularJsButtonLoader() { WebApiPracticeEntities context = new WebApiPracticeEntities(); var result = context.EmployeeDetails.Where(x => x.Name == "test").Select(x => x.ID).ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Display() { WebApiPracticeEntities context = new WebApiPracticeEntities(); var response = context.EmployeeDetails.Where(x => x.IsDeleted == null).ToList(); return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Typeahead() { WebApiPracticeEntities context = new WebApiPracticeEntities(); var model = context.EmployeeDetails.ToList(); return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(string str) { var id = Convert.ToInt16(str); WebApiPracticeEntities context = new WebApiPracticeEntities(); var response = context.EmployeeDetails.Where(x => x.ID == id).FirstOrDefault(); return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(string str) { var id = Convert.ToInt16(str); WebApiPracticeEntities context = new WebApiPracticeEntities(); var response = context.EmployeeDetails.Where(x => x.ID == id).FirstOrDefault(); if (response != null) { response.IsDeleted = true; } context.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Save(string stri) { var res = JsonConvert.DeserializeObject <StudentRecord>(stri); WebApiPracticeEntities context = new WebApiPracticeEntities(); EmployeeDetail angularTable = new EmployeeDetail(); angularTable.Name = res.Name; angularTable.Age = res.RollNumber; angularTable.City = res.Trade; context.EmployeeDetails.Add(angularTable); context.SaveChanges(); return(Content("Successfully Saved")); }
public ActionResult Update(string str, string data) { var id = Convert.ToInt16(str); var m = JsonConvert.DeserializeObject <StudentRecord>(data); WebApiPracticeEntities context = new WebApiPracticeEntities(); EmployeeDetail angulartable = new EmployeeDetail(); var res = context.EmployeeDetails.Where(x => x.ID == id).FirstOrDefault(); res.Name = m.Name; res.Age = m.RollNumber; res.Age = m.Trade; context.SaveChanges(); return(View()); }
public JsonResult SaveFiles(string description) { string Message, fileName, actualFileName; Message = fileName = actualFileName = string.Empty; bool flag = false; if (Request.Files != null) { var file = Request.Files[0]; actualFileName = file.FileName; fileName = Guid.NewGuid() + Path.GetExtension(file.FileName); int size = file.ContentLength; try { //uploadedFiles is the name of the folder file.SaveAs(Path.Combine(Server.MapPath("~/UploadedFiles"), fileName)); EmployeeDetail employee = new EmployeeDetail { Name = actualFileName, City = fileName, Age = description, Email = Convert.ToString(size) }; using (WebApiPracticeEntities dc = new WebApiPracticeEntities()) { dc.EmployeeDetails.Add(employee); dc.SaveChanges(); Message = "File uploaded successfully"; flag = true; } } catch (Exception) { Message = "File upload failed! Please try again"; } } return(new JsonResult { Data = new { Message = Message, Status = flag } }); }