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 { }
}
