public void HideAllFinish()
{
using (var ctx = new Q7DBEntities())
{
string query = @"UPDATE TodoList SET ShowStatus = '0' WHERE status = 1";
var result = ctx.Database.ExecuteSqlCommand(query);
}
}
public void HideTodoByID(int id)
{
using (var ctx = new Q7DBEntities())
{
string sqlquery = "UPDATE TodoList SET ShowStatus = '0' Where ID = @id";
var result = ctx.Database.ExecuteSqlCommand(sqlquery, new SqlParameter("@id", id));
}
}
public void UpdateStatus(int id, bool status)
{
using (var ctx = new Q7DBEntities())
{
string sqlquery = "UPDATE TodoList SET Status = @status Where ID = @id";
var paramId = (new SqlParameter("@id", id));
var paramStatus = (new SqlParameter("@status", status));
var result = ctx.Database.ExecuteSqlCommand(sqlquery, paramId, paramStatus);
}
}
public List <TodoList> GetTodoListWithShow()
{
List <TodoList> result = new List <TodoList>();
using (var ctx = new Q7DBEntities())
{
result = ctx.TodoLists.Where(x => x.ShowStatus)
.ToList();
}
return(result);
}
public void AddNewTopic(string topic)
{
using (var ctx = new Q7DBEntities())
{
string sqlquery = @"INSERT INTO TodoList
(UserName, TodoTopic, Status, CreateDate, FinishTime, ShowStatus)
VALUES('', @topic, 0, GETDATE(), null, 1); ";
var paramTopic = (new SqlParameter("@topic", topic));
var result = ctx.Database.ExecuteSqlCommand(sqlquery, paramTopic);
}
}
public List <TodoList> GetTodoLists()
{
List <TodoList> result = new List <TodoList>();
using (var ctx = new Q7DBEntities())
{
result = ctx.TodoLists
.SqlQuery("Select * from todoList")
.ToList();
}
return(result);
}
