public void CreateTask(Task task) { createCommand(); if (task.ID == -1) { task.ID = GetTaskCount(); } try { string sql = "INSERT INTO [Task] ([id], [listID], [name], [description], [due], [completed]) VALUES(@id, @listID, @name, @description, @due, @completed)"; _cmd.CommandText = sql; _cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = task.ID; _cmd.Parameters.Add("@listID", System.Data.SqlDbType.Int).Value = task.ListID; _cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar).Value = task.Name; _cmd.Parameters.Add("@description", System.Data.SqlDbType.VarChar).Value = task.Description; _cmd.Parameters.Add("@due", System.Data.SqlDbType.DateTime).Value = task.DueDate; _cmd.Parameters.Add("@completed", System.Data.SqlDbType.DateTime); if (task.IsCompleted()) { _cmd.Parameters["@completed"].Value = task.Completed; } else { _cmd.Parameters["@completed"].Value = DBNull.Value; } _conn.Open(); _cmd.ExecuteNonQuery(); _conn.Close(); } catch (SqlException ex) { Console.WriteLine(ex.Message); } }
public void UpdateTask(Task task) { createCommand(); string sql = "UPDATE Task SET [name] = @name, [description] = @description, [due] = @due, [completed] = @completed, [listID] = @listID WHERE [id] = @id"; _cmd.CommandText = sql; _cmd.Parameters.Add("@name", System.Data.SqlDbType.VarChar).Value = task.Name; _cmd.Parameters.Add("@description", System.Data.SqlDbType.VarChar).Value = task.Description; _cmd.Parameters.Add("@due", System.Data.SqlDbType.DateTime).Value = task.DueDate; _cmd.Parameters.Add("@completed", System.Data.SqlDbType.DateTime); _cmd.Parameters.Add("@listID", System.Data.SqlDbType.Int).Value = task.ListID; _cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = task.ID; if (task.IsCompleted()) { _cmd.Parameters["@completed"].Value = task.Completed; } else { _cmd.Parameters["@completed"].Value = DBNull.Value; } _conn.Open(); _cmd.ExecuteNonQuery(); _conn.Close(); }