/// <summary>
/// Updates all changes in the TodoItems data table to the TodoItems table in the TodoDB database.
/// </summary>
/// <param name="dtTodoItems"></param>
public static int UpdateTodoItems(TodoDB.TodoItemsDataTable dtTodoItems)
{
try
{
TodoDBTableAdapters.TodoItemsTableAdapter daTodoItems = new TodoDBTableAdapters.TodoItemsTableAdapter();
return(daTodoItems.Update(dtTodoItems));
}
catch (Exception err)
{
ErrorHandler.ShowErrorMessage(err, "Error in UpdateTodoItems function of TodoDataSync class.");
return(-1);
}
}
/// <summary>
/// Loads all Todo Items records for the specified user from the TodoItems table in the database.
/// </summary>
/// <param name="iUserID"></param>
/// <param name="dtTodoItems"></param>
public static void LoadTodoItems(int iUserID, TodoData.TodoDB.TodoItemsDataTable dtTodoItems)
{
try
{
TodoDBTableAdapters.TodoItemsTableAdapter daTodoItems = new TodoDBTableAdapters.TodoItemsTableAdapter();
daTodoItems.Adapter.SelectCommand = new SqlCommand("SELECT * FROM dbo.TodoItems WHERE UserID = @UserID");
daTodoItems.Adapter.SelectCommand.Parameters.AddWithValue("@UserID", iUserID);
daTodoItems.Adapter.SelectCommand.Connection = daTodoItems.Connection;
daTodoItems.Adapter.Fill(dtTodoItems);
}
catch (Exception err)
{
ErrorHandler.ShowErrorMessage(err, "Error in LoadTodoItems function of TodoDataSync class.");
}
}
