Exemple #1
0
        internal override GroupsControlWorks Read(int id)
        {
            if (id <= 0)
            {
                throw new ArgumentException("Идентификатор меньше или равен нулю", "id");
            }

            Filter filter = new GroupsControlWorksFilter
            {
                Id = id
            };

            return(ReadAll(filter).FirstOrDefault());
        }
Exemple #2
0
        internal override IReadOnlyCollection <GroupsControlWorks> ReadAll(Filter filter)
        {
            if (filter == null)
            {
                filter = new GroupsControlWorksFilter();
            }
            else if (filter.GetType() != typeof(GroupsControlWorksFilter))
            {
                throw new ArgumentException("Передаваемый фильтр не соответствует ожидаемому", "filter");
            }

            List <GroupsControlWorks> output = new List <GroupsControlWorks>();
            var drc = GetRowsUsingQuery(TableValuedFunctions.Users.GroupsControlWorks_Read, filter.ToSqlParameters());

            foreach (DataRow item in drc)
            {
                output.Add(new GroupsControlWorks(
                               (int)item["GroupControlWorkId"],
                               (int)item["GroupId"],
                               (int)item["ControlWorkId"]
                               ));
            }
            return(output);
        }