public static List<Task> DBGetTasks(string userid) { List<Task> tasks = new List<Task>(); MySqlConnection cn = new MySqlConnection(ConfigurationManager.ConnectionStrings["sldbConnectionString"].ConnectionString); MySqlCommand cmd = new MySqlCommand(); string sSql = String.Format("CALL `schultzlegenddb`.`TRACKER_TASKS_GET_BY_USERID`('{0}');", userid); cmd.Connection = cn; cmd.CommandText = sSql; cmd.Connection.Open(); MySqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { Task task = new Task(); task.Name = Convert.ToString(reader["name"]); task.UserId = Convert.ToString(reader["user"]); task.TaskId = (int)reader["task_id"]; task.Parent = (int)reader["parent"]; task.Complete = (sbyte)reader["complete"]; task.Priority = (int)reader["priority"]; tasks.Add(task); } reader.Close(); cmd.Connection.Close(); return tasks; }
public static Task DBGetTaskByName(string name) { Task task = new Task(); MySqlConnection cn = new MySqlConnection(ConfigurationManager.ConnectionStrings["sldbConnectionString"].ConnectionString); MySqlCommand cmd = new MySqlCommand(); string sSql = String.Format("CALL `schultzlegenddb`.`TRACKER_TASK_GET_BY_NAME`('{0}');", name); cmd.Connection = cn; cmd.CommandText = sSql; cmd.Connection.Open(); MySqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (reader.Read()) { task.Name = Convert.ToString(reader["name"]); task.UserId = Convert.ToString(reader["user"]); task.TaskId = (int)reader["task_id"]; task.Parent = (int)reader["parent"]; task.Complete = (sbyte)reader["complete"]; task.Priority = (int)reader["priority"]; } reader.Close(); cmd.Connection.Close(); return task; }