Esempio n. 1
0
 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);
 }
Esempio n. 2
0
        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));
        }
Esempio n. 4
0
        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));
        }