// Insert new To Do Data in Database
public bool insertToDoData(ToDoListData data)
{
//NonQuery
using (var connObj = new SqlConnection(getConnectionString())) {
using (var cmdObj = new SqlCommand()) {
cmdObj.CommandText = sp_InsertTodoList;
cmdObj.CommandType = CommandType.StoredProcedure;
var parameters = new []{
new SqlParameter("@Text",data.Text),
new SqlParameter("@Title",data.Title)
};
foreach(var param in parameters)
cmdObj.Parameters.Add(param);
cmdObj.Connection = connObj;
try{
connObj.Open();
cmdObj.ExecuteNonQuery();
return true;
}
catch(Exception ex){
throw ex;
}
}
}
}
private List <TodoListEntry> GetData()
{
if (Session["TodoData"] == null)
{
Session["TodoData"] = ToDoListData.TestEntries().ToList();
}
return((List <TodoListEntry>)Session["TodoData"]);
}
public int SaveCategory(string catName)
{
return(ToDoListData.Create(catName));
}
public List <Category> GetCategories(int startDateIndex)
{
List <Category> category = ToDoListData.GetCategory();
return(category);
}
//Update Data
public bool updateToDoData(int id,ToDoListData data)
{
return true;
}
