public List <Todo> GetTodoByDatetime(DateTime date)
{
var _CassandraCon = new CassandraDatabaseConnection();
List <Todo> temp = new List <Todo>();
try
{
var statement = new SimpleStatement("SELECT* FROM todo_id WHERE Date = ?", date);
ISession session = _CassandraCon.Connect();
var rs = session.Execute(statement);
session.Cluster.Shutdown();
foreach (var row in rs)
{
Todo TempTodo = new Todo();
TempTodo.Id = row.GetValue <Guid>("id");
TempTodo.Task = row.GetValue <string>("task");
TempTodo.Title = row.GetValue <string>("title");
TempTodo.Date = row.GetValue <DateTime>("date");
temp.Add(TempTodo);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception("error in cassandra query");
}
return(temp);
}
public Todo GetTodoById(Guid id)
{
var _CassandraCon = new CassandraDatabaseConnection();
ISession session = _CassandraCon.Connect();
Todo TempTodo = new Todo();
try
{
var rs = session.Execute(new SimpleStatement("SELECT* FROM todo_id WHERE Id = ?", id));
foreach (var row in rs)
{
TempTodo.Id = row.GetValue <Guid>("id");
TempTodo.Task = row.GetValue <string>("task");
TempTodo.Title = row.GetValue <string>("title");
TempTodo.Date = row.GetValue <DateTime>("date");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception("error in Cassandra get Todo By Id");
}
session.Cluster.Shutdown();
return(TempTodo);
}
public void Insert(Guid id, string task, string title, DateTime date)
{
try
{
var _CassandraCon = new CassandraDatabaseConnection();
var statement = new SimpleStatement("INSERT INTO todo_id (Id, Task, Title, Date) VALUES (?,?,?,?)", id, task, title, date);
ISession session = _CassandraCon.Connect();
session.Execute(statement);
session.Cluster.Shutdown();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception("Cassandra insert error");
}
}
public void DeleteById(Guid id)
{
var _CassandraCon = new CassandraDatabaseConnection();
ISession session = _CassandraCon.Connect();
try
{
var statement = new SimpleStatement("DELETE FROM todo_id WHERE Id = ?", id);
session.Execute(statement);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception("Casandra delete by ID error");
}
session.Cluster.Shutdown();
}
