示例#1
0
        public int HasInChairType(Guid chairtypeId)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            SqlCommand          query   = builder.HasInChairType(chairtypeId);

            return(DBManager.ExecuteScalar <int>(base.ConnectionHandler, query));
        }
示例#2
0
        public IEnumerable <Chair> GetListChairByIdList(List <Guid> list)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            SqlCommand          query   = builder.GetListChairByIdList(list);

            return(DBManager.GetCollection <Chair>(base.ConnectionHandler, query));
        }
示例#3
0
        public int AllowDelete(Guid hallId)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            SqlCommand          query   = builder.AllowDelete(hallId);

            return(DBManager.ExecuteScalar <int>(base.ConnectionHandler, query));
        }
示例#4
0
        public List <Chair> GetHallChairs(Guid hallId)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            var query = builder.GetHallChairs(hallId);

            return(DBManager.GetCollection <Chair>(base.ConnectionHandler, query));
        }
示例#5
0
        public int InsertChairs(List <Chair> chairs)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            SqlCommand          query   = builder.InsertChairs(chairs);

            return(DBManager.ExecuteNonQuery(base.ConnectionHandler, query));
        }
示例#6
0
        public int UpdateChairs(List <string> chairs)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            var query = builder.UpdateChairs(chairs);

            return(DBManager.ExecuteNonQuery(base.ConnectionHandler, query));
        }
示例#7
0
        public Chair GetByPosition(Guid hallId, int column, int row)
        {
            ChairCommandBuilder builder = new ChairCommandBuilder();
            string query = builder.GetByPosition(hallId, column, row);

            return(DBManager.GetObject <Chair>(base.ConnectionHandler, query));
        }