public void RemoveStudent(int Id)
{
using (var cassandraDA = new CassandraDA(_config))
{
var session = cassandraDA.GetSession();
IMapper mapper = new Mapper(session);
mapper.Execute("Delete From tblStudent Where Id = ?", Id);
}
}
public void ChangeDetails(Student student)
{
using (var cassandraDA = new CassandraDA(_config))
{
var session = cassandraDA.GetSession();
IMapper mapper = new Mapper(session);
mapper.Execute(" Update tblStudent SET Name = ?, Email = ?, Phone = ? where Id = ?;", student.Name, student.Email, student.Phone, student.Id);
}
}
public Student GetStudentById(int Id)
{
using (var cassandraDA = new CassandraDA(_config))
{
var session = cassandraDA.GetSession();
IMapper mapper = new Mapper(session);
var student = mapper.SingleOrDefault <Student>("Select * From tblStudent Where Id = ?;", Id);
return(student);
}
}
public void NewStudent(Student student)
{
using (var cassandraDA = new CassandraDA(_config))
{
var session = cassandraDA.GetSession();
IMapper mapper = new Mapper(session);
mapper.Execute("Insert into tblstudent(Id, Name, Email, Phone) Values(?,?,?,?)", student.Id, student.Name, student.Email, student.Phone);
}
}
public IEnumerable <Student> GetStudents()
{
using (var cassandraDA = new CassandraDA(_config))
{
var session = cassandraDA.GetSession();
IMapper mapper = new Mapper(session);
var students = mapper.Fetch <Student>("Select * From tblStudent;");
return(students);
}
}