// 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; }