public ObservableCollection <Entity.Student> GetStudentsData()
{
ObservableCollection <Entity.Student> studentsList = new ObservableCollection <Entity.Student>();
using (demoEntities db = new demoEntities())
{
var students = db.GetStudents();
foreach (var student in students)
{
Student stud = new Student()
{
Id = student.Id,
Name = student.Name,
Mobile = student.Mobile,
Address = student.Address,
Stream = student.Stream,
StreamName = student.StreamName
};
studentsList.Add(stud);
}
}
return(studentsList);
}
public ActionResult SubjectEdit(mst_subjectmarks subjectData)
{
try
{
if (ModelState.IsValid)
{
demoEntities db = new demoEntities();
mst_subjectmarks subject = db.mst_subjectmarks.First(c => c.subject_id == subjectData.subject_id);
subject.subject_name = subjectData.subject_name;
subject.marks = subjectData.marks;
db.SaveChanges();
return(RedirectToAction("studentlist"));
}
else
{
return(View(subjectData));
}
}
catch (Exception ex)
{
return(View(subjectData));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (demoEntities entity = new demoEntities())
{
var stud = entity.students.FirstOrDefault(p => p.id == id);
if (stud == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "THe student with id " + id.ToString() + "not found"));
}
else
{
entity.students.Remove(stud);
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <Clientes> ObtenerClientes()
{
using (demoEntities db = new demoEntities()) {
return(db.Clientes.ToList());
}
}
