public JsonResult SaveDataInDatabase(StudentViewModel model) { var result = false; try { if (model.StudentId > 0) { tbStudent Stu = db.tbStudents.SingleOrDefault(x => x.IsDeleted == false && x.StudentId == model.StudentId); Stu.StudentName = model.StudentName; Stu.Email = model.Email; Stu.DepartmentId = model.DepartmentId; db.SaveChanges(); result = true; } else { tbStudent Stu = new tbStudent(); Stu.StudentName = model.StudentName; Stu.Email = model.Email; Stu.DepartmentId = model.DepartmentId; Stu.IsDeleted = false; db.tbStudents.Add(Stu); db.SaveChanges(); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetStudentById(int StudentId) { tbStudent model = db.tbStudents.Where(x => x.StudentId == StudentId).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteStudentRecord(int StudentId) { bool result = false; tbStudent Stu = db.tbStudents.SingleOrDefault(x => x.IsDeleted == false && x.StudentId == StudentId); if (Stu != null) { Stu.IsDeleted = true; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
private void ViewStudent_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { id = int.Parse(GetSelectedCellValue()); result = db.tbStudents.SingleOrDefault(x => x.ID == id); txtID.Text = result.ID.ToString(); txtName.Text = result.studentName; txtAddress.Text = result.Address; txtNotes.Text = result.Notes; txtEmail.Text = result.Email; txtPhone.Text = result.Phone; img.Source = new BitmapImage(new Uri(result.Image)); } catch { } }