public int Insert(Board board)
{
string query = "INSERT INTO [Board] (BoardID,Name,CreatedDate) VALUES(@boardID,@name,@createdDate)";
List<SqlParameter> parameters = GetParameters(board, true);
h.AddParametersToCommand(parameters);
return h.MyExecuteQuery(query);
}
public int Insert(Tasks task)
{
string query = "INSERT INTO Task(StatusID,Description,BoardID) VALUES(@statusID,@description,@boardID)";
List <SqlParameter> parameters = GetParameters(task, true);
h.AddParametersToCommand(parameters);
return(h.MyExecuteQuery(query));
}
public int Insert(TodoTask task)
{
string query = "INSERT INTO TodoTask(TaskID,BoardID,Name,Urgency,Importance,IsFinished,IsDeleted,CreatedDate) VALUES(@taskID,@boardID,@name,@urgency,@importance,@isFinished,@isDeleted,@createdDate)";
List <SqlParameter> parameters = GetParameters(task, true);
h.AddParametersToCommand(parameters);
return(h.MyExecuteQuery(query));
}
public int Insert(Board board)
{
string query = "Insert into Board(Name) Values(@boardName)";
List <SqlParameter> parameters = GetParameters(board);
h.AddParametersToCommand(parameters);
return(h.MyExecuteQuery(query));
}