public bool Delete(int todoId)
{
bool result = false;
using (var context = new TrainingTodoEntities())
{
string sql = "UPDATE TodoList SET Deleted = 1 Where TodoId = @TodoId";
var p_todoId = (new SqlParameter("@TodoId", todoId));
var sqlExecutedResult = context.Database.ExecuteSqlCommand(sql, p_todoId);
if (sqlExecutedResult > 0)
{
result = true;
}
}
return(result);
}
public bool UpdateCompleted(int todoId, bool doneOrNot)
{
bool result = false;
using (var context = new TrainingTodoEntities())
{
string sql = "UPDATE TodoList SET Completed = @Completed Where TodoId = @TodoId";
var p_todoId = (new SqlParameter("@TodoId", todoId));
var p_completed = (new SqlParameter("@Completed", doneOrNot));
var sqlExecutedResult = context.Database.ExecuteSqlCommand(sql, p_todoId, p_completed);
if (sqlExecutedResult > 0)
{
result = true;
}
}
return(result);
}
public TodoListRepository()
{
db = new TrainingTodoEntities();
}
