internal List <NotificationDataView> GetNotificationDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <NotificationDataView> listView = (from n in dbContext.Notifications join pf in dbContext.Persons on n.idSendFrom equals pf.idPerson join pt in dbContext.Persons on n.idSendTo equals pt.idPerson into personGroup from subPerson in personGroup.DefaultIfEmpty() join kv in dbContext.KeyValues on n.idStatus equals kv.idKeyValue join kt in dbContext.KeyTypes on kv.idKeyType equals kt.idKeyType select new NotificationDataView { idNotification = n.idNotification, idSendFrom = n.idSendFrom, idSendTo = n.idSendTo, About = n.About, SendDate = n.SendDate, LastUpdate = n.LastUpdate, FirstNameFrom = pf.FirstName, LastNameFrom = pf.LastName, FirstNameTo = subPerson.FirstName, LastNameTo = subPerson.LastName, Comment = n.Comment, idStatus = n.idStatus, StatusName = kv.Name, idPerson = subPerson.idPerson, isReading = n.isReading, ParentID = n.ParentID, idGroup = n.idGroup } ).ApplySearchCriterias(searchCriteria).OrderByDescending(o => o.SendDate).ToList(); listView = BaseClassBL <NotificationDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <EmployeDataView> GetEmployeDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <EmployeDataView> listView = (from p in dbContext.Persons join e in dbContext.Employees on p.idPerson equals e.idPerson orderby p.FirstName, p.LastName ascending select new EmployeDataView { idEmploye = e.idEmploye, idPerson = p.idPerson, IdentityNumber = p.IdentityNumber, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, Address = p.Address, EMail = p.EMail, MobilePhone = p.MobilePhone, Phone = p.Phone, Title = p.Title, EGN = p.EGN, IDN = p.IDN } ).ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <EmployeDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <PermittedActionDataView> GetAllPermittedActionsByRoleNotAdded(string entityID, string sortExpression, string sortDirection) { int idRole = Int32.Parse(entityID); List <int> listPermittedActionID = (from p in this.dbContext.RolePermittedActionLinks where p.idRole == idRole && p.idPermittedAction.HasValue select p.idPermittedAction.Value).ToList(); List <PermittedActionDataView> list = (from p in this.dbContext.PermittedActions join m in this.dbContext.Modules on p.idModule equals m.idModule into grModule from subModule in grModule.DefaultIfEmpty() where !listPermittedActionID.Contains(p.idPermittedAction) select new PermittedActionDataView() { idPermittedAction = p.idPermittedAction, FrendlyName = p.FrendlyName, Description = p.Description, ModuleName = subModule.ModuleName, idModule = subModule.idModule }).ToList(); list = BaseClassBL <PermittedActionDataView> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
public List <PermittedAction> GetAll(string sortExpression, string sortDirection) { List <PermittedAction> list = GetAllEntities <PermittedAction>(); list = BaseClassBL <PermittedAction> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
internal List <Setting> GetAllSettings(string sortExpression, string sortDirection, List <AbstractSearch> searchCriterias) { List <Setting> list = dbContext.Settings.ApplySearchCriterias <Setting>(searchCriterias).ToList(); list = BaseClassBL <Setting> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
public List <Role> GetAll(string sortExpression, string sortDirection) { List <Role> list = dbContext.Roles.Select(s => s).OrderBy(s => s.Name).ToList(); list = BaseClassBL <Role> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
public List <Location> GetAllLocations() { List <Location> list = GetAllEntities <Location>(); list = BaseClassBL <Location> .Sort(list, "Name", Constants.SORTING_ASC).ToList(); return(list); }
internal List <AllowIPDataView> GetAllAllowIP(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <AllowIPDataView> listView = (from u in dbContext.AllowIPs select new AllowIPDataView { idAllowIP = u.idAllowIP, IP = u.IP, Commnet = u.Commnet, Allow = u.Allow }).ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <AllowIPDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <KeyValue> GetAllKeyValueByKeyTypeID(string _entityID, string sortExpression, string sortDirection) { int entityID; if (Int32.TryParse(_entityID, out entityID)) { List <KeyValue> listKeyValues = dbContext.KeyValues.Where(e => e.idKeyType == entityID).ToList(); listKeyValues = BaseClassBL <KeyValue> .Sort(listKeyValues, sortExpression, sortDirection).ToList(); return(listKeyValues); } else { return(null); } }
internal List <Role> GetAllRoleByUserNotAdded(string entityID, string sortExpression, string sortDirection, List <AbstractSearch> searchCriterias) { int idUser = Int32.Parse(entityID); List <int> listRolesID = (from p in this.dbContext.UserRoleLinks where p.idUser == idUser select p.idRole.Value).ToList(); List <Role> list = (from p in this.dbContext.Roles where !listRolesID.Contains(p.idRole) select p).ApplySearchCriterias(searchCriterias).ToList(); list = BaseClassBL <Role> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
public List <KeyValue> GetAllKeyValueByKeyTypeIntCode(string keyTypeIntCode, string columnToOrderBy) { List <KeyValue> list = new List <KeyValue>(); KeyType keyType = DictionaryKeyType.Where(d => d.Value.KeyTypeIntCode == keyTypeIntCode).FirstOrDefault().Value; var data = DictionaryKeyValue.Where(k => k.Value.idKeyType == keyType.idKeyType).OrderBy(o => o.Value.Name).Select(s => s.Value).ToList(); data = BaseClassBL <KeyValue> .Sort(data, columnToOrderBy, Constants.SORTING_ASC).ToList(); foreach (var item in data) { list.Add(item); } return(list); }
private List <KeyValue> LoadList() { if (DataSourceType == "KeyValue") { list = this.ownerPage.GetAllKeyValueByKeyTypeIntCode(KeyTypeIntCode).OrderBy(e => e.Name).ToList(); if (this.AddingDefaultValue) { SMCDropDownList.AddDefaultValue(list, this.UseShortDefaultValue); } if (OrderBy != null) { list = BaseClassBL <KeyValue> .Sort(list, this.OrderBy, this.OrderDirection != null?this.OrderDirection : "asc").ToList(); } } return(list); }
internal List <ModuleDataView> GetAllModules(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <ModuleDataView> listView = (from u in dbContext.Modules select new ModuleDataView { idModule = u.idModule, ModuleName = u.ModuleName, ModuleSysName = u.ModuleSysName, Comment = u.Comment, NeedCheck = u.NeedCheck }).ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <ModuleDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <Role> GetAllRolesByUser(string userID, string sortExpression, string sortDirection) { List <Role> entityList = new List <Role>(); int tmpUserID; if (Int32.TryParse(userID, out tmpUserID)) { entityList = (from r in this.dbContext.Roles join l in this.dbContext.UserRoleLinks on r.idRole equals l.idRole where l.idUser == tmpUserID select r).ToList(); } entityList = BaseClassBL <Role> .Sort(entityList, sortExpression, sortDirection).ToList(); return(entityList); }
public List <PersonDataView> GetPersonDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <PersonDataView> listView = (from u in dbContext.Persons join Nationality in dbContext.KeyValues on u.idCitizenship equals Nationality.idKeyValue into grNationality from subNationality in grNationality.DefaultIfEmpty() select new PersonDataView { idPerson = u.idPerson, FirstName = u.FirstName, SecondName = u.SecondName, LastName = u.LastName, IdentityNumber = u.IdentityNumber, NationalityStr = (subNationality == null ? string.Empty : subNationality.Name) }).ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <PersonDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <PermittedActionDataView> GetAllPermittedActionsByRole(string entityID, string sortExpression, string sortDirection) { int idRole = Int32.Parse(entityID); List <PermittedActionDataView> list = (from p in this.dbContext.PermittedActions join rp in this.dbContext.RolePermittedActionLinks on p.idPermittedAction equals rp.idPermittedAction where rp.idRole == idRole orderby p.GroupSecuritySetting, p.SecuritySetting select new PermittedActionDataView() { idPermittedAction = p.idPermittedAction, RolePermittedActionID = rp.idRolePermittedAction, FrendlyName = p.FrendlyName, Description = p.Description } ).OrderBy(s => s.FrendlyName).ToList(); list = BaseClassBL <PermittedActionDataView> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
public List <PermittedActionDataView> GetAllPermittedActionDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <PermittedActionDataView> list = new List <PermittedActionDataView>(); list = (from p in this.dbContext.PermittedActions join m in this.dbContext.Modules on p.idModule equals m.idModule into grModule from module in grModule.DefaultIfEmpty() select new PermittedActionDataView { idPermittedAction = p.idPermittedAction, idModule = p.idModule, ModuleName = (module != null) ? module.ModuleName : string.Empty, GroupSecuritySetting = p.GroupSecuritySetting, SecuritySetting = p.SecuritySetting, FrendlyName = p.FrendlyName, Description = p.Description }).ApplySearchCriterias(searchCriteria).ToList(); list = BaseClassBL <PermittedActionDataView> .Sort(list, sortExpression, sortDirection).ToList(); return(list); }
internal List <GroupDataView> GetGroupDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <GroupDataView> listView = (from g in dbContext.Groups //GroupPersonLinks join gpl in this.dbContext.GroupPersonLinks on g.idGroup equals gpl.idGroup into gj from subpet in gj.DefaultIfEmpty() //Person join p in dbContext.Persons on(subpet != null ? subpet.idPerson : Constants.INVALID_ID) equals p.idPerson into groupPerson from grPerson in groupPerson.DefaultIfEmpty() select new GroupDataView { idGroup = g.idGroup, GroupName = g.GroupName, SharedAccess = g.SharedAccess, idPerson = grPerson.idPerson } ).ApplySearchCriterias(searchCriteria).Distinct().ToList(); listView = BaseClassBL <GroupDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <UserDataView> GetAllUsers(string sortExpression, string sortDirection) { List <UserDataView> listView = (from u in dbContext.Users join p in dbContext.Persons on u.idPerson equals p.idPerson join kv in dbContext.KeyValues on u.idStatus equals kv.idKeyValue select new UserDataView { IdUser = u.idUser, UserName = u.UserName, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, EGN = p.EGN, IdentityNumber = p.IdentityNumber, idStatus = u.idStatus, Status = kv.Name, Description = u.Description }).ToList <UserDataView>(); listView = BaseClassBL <UserDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <OfferDataView> GetAllOfferDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <OfferDataView> listView = (from o in dbContext.Offers join p in dbContext.ProfileSettings on o.idProfileSetting equals p.idProfileSetting join u in dbContext.Users on o.idCreateUser equals u.idUser join person in dbContext.Persons on u.idPerson equals person.idPerson select new OfferDataView { idOffer = o.idOffer, idProfileSetting = o.idProfileSetting, InquiryNumber = o.InquiryNumber, Customer = o.Customer, OfferDate = o.OfferDate, TransportationCost = o.TransportationCost, LME = o.LME, PREMIUM = o.PREMIUM, AdministrationExpenses = o.AdministrationExpenses, SalesExpenses = o.SalesExpenses, FinancialFixedExpenses = o.FinancialFixedExpenses, FinancialVariableExpenses = o.FinancialVariableExpenses, ProfileStr = p.ProfileName, FirstName = person.FirstName, SecondName = person.SecondName, LastName = person.LastName, TotalSalesPrice = o.TotalSalesPrice, ActualTotalSalesPriceToCustomer = o.ActualTotalSalesPriceToCustomer, TargetPrice_EUR_TON = o.TargetPrice_EUR_TON, Tonnage = o.Tonnage, } ).ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <OfferDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
internal List <KeyTypeDataView> GetKeyTypeDataView(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <KeyTypeDataView> listView = (from kt in dbContext.KeyTypes join kv in dbContext.KeyValues on kt.idKeyType equals kv.idKeyType into groupKV from subKeyValue in groupKV.DefaultIfEmpty() select new KeyTypeDataView { idKeyType = kt.idKeyType, Name = kt.Name, Description = kt.Description, KeyTypeIntCode = kt.KeyTypeIntCode, IsSystem = kt.IsSystem, LAST_UPD = kt.LAST_UPD, KeyValueNameStr = subKeyValue.Name, KeyValueIntCodeStr = subKeyValue.KeyValueIntCode, KeyValueDescriptionStr = subKeyValue.Description } ).Distinct().ApplySearchCriterias(searchCriteria).ToList(); listView = BaseClassBL <KeyTypeDataView> .Sort(listView, sortExpression, sortDirection).ToList(); return(listView); }
public override void FormLoad() { try { CheckUserActionPermission(ETEMEnums.SecuritySettings.ShowOnlineUsersList, true); List <UserProps> onlineUsers = (from u in GetOnlineUsers() select new UserProps { UserName = u.UserName, PersonNamePlusTitle = u.PersonNamePlusTitle, SessionID = u.SessionID, LoginDateTime = u.LoginDateTime, LastRequestDateTime = u.LastRequestDateTime, IPAddress = u.IPAddress, IsKilled = u.IsKilled, LastPageName = u.LastPageName, LastModuleName = u.LastModuleName }).ToList(); onlineUsers = BaseClassBL <UserProps> .Sort(onlineUsers, this.GridViewSortExpression, this.GridViewSortDirection).ToList(); this.gvOnlineUsers.DataSource = onlineUsers; if (NewPageIndex.HasValue) { this.gvOnlineUsers.PageIndex = NewPageIndex.Value; } this.gvOnlineUsers.DataBind(); } catch (Exception ex) { BaseHelper.Log("Грешка в FormLoad " + formResource.PagePath); BaseHelper.Log(ex.Message); BaseHelper.Log(ex.StackTrace); } }
internal List <UserDataView> GetAllUsers(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection) { List <UserDataView> listView = (from u in dbContext.Users join p in dbContext.Persons on u.idPerson equals p.idPerson join kvPosition in dbContext.KeyValues on p.idPosition equals kvPosition.idKeyValue into grPosition from position in grPosition.DefaultIfEmpty() join kv in dbContext.KeyValues on u.idStatus equals kv.idKeyValue join e in dbContext.Employees on p.idPerson equals e.idPerson into grEmployees from employee in grEmployees.DefaultIfEmpty() select new UserDataView { IdUser = u.idUser, UserName = u.UserName, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, EGN = p.EGN, IdentityNumber = p.IdentityNumber, idStatus = u.idStatus, Status = kv.Name, Description = u.Description, IsEmployee = (employee != null) ? true : false, PositionName = (position != null) ? position.Name : string.Empty }).ApplySearchCriterias(searchCriteria).ToList <UserDataView>(); listView = BaseClassBL <UserDataView> .Sort(listView, sortExpression, sortDirection).ToList(); List <UserRoleLink> listUserRoleLink = this.dbContext.UserRoleLinks.ToList(); List <Role> listRole = this.dbContext.Roles.ToList(); StringBuilder sb = new StringBuilder(); foreach (UserDataView item in listView) { item.UserRoleLinkList = listUserRoleLink.Where(u => u.idUser == item.IdUser).ToList(); sb.Clear(); foreach (UserRoleLink link in item.UserRoleLinkList) { sb.Append(listRole.FirstOrDefault(r => r.idRole == link.idRole).Name).Append(", "); } if (sb.Length > 0) { item.Roles = sb.Remove(sb.Length - 2, 2).ToString(); } else { item.Roles = sb.ToString(); } } return(listView); }
private List <KeyValue> LoadList() { if (!externalDataSourceType) { //return new List<KeyValue>(); } if (DataSourceType == "KeyValue") { list = this.ownerPage.GetAllKeyValueByKeyTypeIntCode(KeyTypeIntCode).OrderBy(e => e.Name).ToList(); if (this.AddingDefaultValue) { AddDefaultValue(list, this.UseShortDefaultValue); } if (OrderBy != null) { list = BaseClassBL <KeyValue> .Sort(list, this.OrderBy, this.OrderDirection != null?this.OrderDirection : "asc").ToList(); } } else if (DataSourceType == "Role") { list = (from e in this.AdminClientRef.GetAllRoles("Name", this.GridViewSortDirection) select new KeyValue { idKeyValue = e.idRole, Name = e.Name }).ToList <KeyValue>(); AddDefaultValue(list); } //else if (DataSourceType == "UNI") //{ // CallContext resultContext = new CallContext(); // resultContext.CurrentYear = this.CurrentYear; // resultContext.CurrentPeriod = this.CurrentPeriod; // UNI currentUni = this.AdminClientRef.GetCurrentUNI(resultContext); // KeyValue kvUni = new KeyValue // { // idKeyType = currentUni.idUNI, // Name=currentUni.UniName // }; // list = new List<KeyValue>(); // list.Add(kvUni); // AddDefaultValue(list); //} else if (DataSourceType == "VendorDiePriceList") { DateTime?dateActiveTo = null; if (!string.IsNullOrWhiteSpace(this.AdditionalParam)) { dateActiveTo = Convert.ToDateTime(this.AdditionalParam, BaseHelper.GetDateTimeFormatInfo()); } var data = this.CostCalculationRef.GetAllDiePriceList(new List <AbstractSearch>(), dateActiveTo, string.Empty, string.Empty); list = (from d in data select new KeyValue { idKeyValue = d.idDiePriceList, Name = d.VendorName + " / from " + d.DateFromString + (d.DateTo.HasValue ? " - to " + d.DateToString : string.Empty) }).ToList(); AddDefaultValue(list); } else if (DataSourceType == "Country") { var data = this.AdminClientRef.GetAllCountries(); //премахваме от списъка с държави текста "без гражданство" AdditionalParam="Number <> 0" if (!string.IsNullOrEmpty(this.AdditionalParam) && this.AdditionalParam == "WithoutEmptyCountry") { list = (from c in data where c.CodeISO3166 == ETEMEnums.CountryCodeEnum.BG.ToString() select new KeyValue { idKeyValue = c.idCountry, Name = c.Name } ).Union(from c in data where c.CodeISO3166 != ETEMEnums.CountryCodeEnum.NONE.ToString() && c.CodeISO3166 != ETEMEnums.CountryCodeEnum.BG.ToString() select new KeyValue { idKeyValue = c.idCountry, Name = c.Name } ).ToList <KeyValue>(); } else { list = (from c in data where c.CodeISO3166 == ETEMEnums.CountryCodeEnum.NONE.ToString() select new KeyValue { idKeyValue = c.idCountry, Name = c.Name }).Union(from c in data where c.CodeISO3166 == ETEMEnums.CountryCodeEnum.BG.ToString() select new KeyValue { idKeyValue = c.idCountry, Name = c.Name } ).Union(from c in data where c.CodeISO3166 != ETEMEnums.CountryCodeEnum.NONE.ToString() && c.CodeISO3166 != ETEMEnums.CountryCodeEnum.BG.ToString() select new KeyValue { idKeyValue = c.idCountry, Name = c.Name } ).ToList <KeyValue>(); } AddDefaultValue(list); } else if (DataSourceType == "District") { if (string.IsNullOrEmpty(this.AdditionalParam)) { list = (from d in this.AdminClientRef.GetAllDistricts() select new KeyValue { idKeyValue = d.idDistrict, Name = d.Name }).ToList <KeyValue>(); } else { list = (from d in this.AdminClientRef.GetDistrictsByCountryId(this.AdditionalParam) select new KeyValue { idKeyValue = d.idDistrict, Name = d.Name }).ToList <KeyValue>(); } AddDefaultValue(list); } else if (DataSourceType == "Municipality") { if (string.IsNullOrEmpty(this.AdditionalParam)) { list = (from m in this.AdminClientRef.GetAllMunicipalities() select new KeyValue { idKeyValue = m.idMunicipality, Name = m.Name }).ToList <KeyValue>(); } else { string idFilter = Constants.INVALID_ID_STRING; if (this.AdditionalParam.Contains("Country")) { if (this.AdditionalParam.Contains("=")) { idFilter = this.AdditionalParam.Split('=')[1]; } else { idFilter = this.AdditionalParam; } list = (from m in this.AdminClientRef.GetMunicipalitiesByCountryId(idFilter) select new KeyValue { idKeyValue = m.idMunicipality, Name = m.Name }).ToList <KeyValue>(); } else if (this.AdditionalParam.Contains("District")) { if (this.AdditionalParam.Contains("=")) { idFilter = this.AdditionalParam.Split('=')[1]; } else { idFilter = this.AdditionalParam; } list = (from m in this.AdminClientRef.GetMunicipalitiesByDistrictId(idFilter) select new KeyValue { idKeyValue = m.idMunicipality, Name = m.Name }).ToList <KeyValue>(); } else { list = new List <KeyValue>(); } } AddDefaultValue(list); } else if (DataSourceType == "EKATTE") { if (string.IsNullOrEmpty(this.AdditionalParam)) { list = (from e in this.AdminClientRef.GetAllEKATTEs() select new KeyValue { idKeyValue = e.idEKATTE, Name = e.Name }).ToList <KeyValue>(); } else { list = (from e in this.AdminClientRef.GetEKATTEsByMunicipalityId(this.AdditionalParam) select new KeyValue { idKeyValue = e.idEKATTE, Name = e.Name }).ToList <KeyValue>(); } AddDefaultValue(list); } else if (DataSourceType == "Location") { if (string.IsNullOrEmpty(this.AdditionalParam)) { list = (from l in this.AdminClientRef.GetAllLocations() select new KeyValue { idKeyValue = l.idLocation, Name = l.Name }).ToList <KeyValue>(); } else { list = (from l in this.AdminClientRef.GetLocationsByMunicipalityId(this.AdditionalParam) select new KeyValue { idKeyValue = l.idLocation, Name = l.Name }).ToList <KeyValue>(); } AddDefaultValue(list); } else if (DataSourceType == "LocationView") { if (string.IsNullOrEmpty(this.AdditionalParam)) { list = (from lv in this.AdminClientRef.GetAllLocationViews() select new KeyValue { idKeyValue = lv.idLocation, Name = lv.LocationTypeName }).ToList <KeyValue>(); } else { list = (from lv in this.AdminClientRef.GetLocationViewsByMunicipalityId(this.AdditionalParam) select new KeyValue { idKeyValue = lv.idLocation, Name = lv.LocationTypeName }).ToList <KeyValue>(); } AddDefaultValue(list); } else if (DataSourceType == "WeekOfMonth") { list = new List <KeyValue>(); int reportYear = Int32.Parse(CustomFieldUseEverything.Split('|')[0]); int reportMonth = Int32.Parse(CustomFieldUseEverything.Split('|')[1]); int weeksCount = BaseHelper.Weeks(reportYear, reportMonth); for (int i = 0; i < weeksCount; i++) { int week = i + 1; if (string.IsNullOrEmpty(this.WeekNotEQ) || !this.WeekNotEQ.Contains(i.ToString())) { list.Add(new KeyValue() { Name = "Седмица " + week, idKeyValue = i } ); } } } else if (DataSourceType == "Group") { ICollection <AbstractSearch> searchCriteria = new List <AbstractSearch>(); if (!string.IsNullOrEmpty(AdditionalParam)) { searchCriteria.Add( new BooleanSearch { Comparator = BooleanComparators.Equal, Property = "SharedAccess", SearchTerm = Convert.ToBoolean("true") }); } list = (from d in this.AdminClientRef.GetGroupDataView(searchCriteria, "", "") select new KeyValue { idKeyValue = d.idGroup, Name = d.GroupName }).DistinctBy(o => o.idKeyValue).ToList <KeyValue>(); AddDefaultValue(list); } else if (DataSourceType == "Modules") { list = (from e in this.AdminClientRef.GetAllModule(new List <AbstractSearch>(), "ModuleName", this.GridViewSortDirection) select new KeyValue { idKeyValue = e.idModule, Name = e.ModuleName }).ToList <KeyValue>(); AddDefaultValue(list); } else if (DataSourceType == "PRESS") { list = this.ownerPage.GetAllKeyValueByKeyTypeIntCode(KeyTypeIntCode).Where(s => s.DefaultValue1 == "Press").OrderBy(e => e.Name).ToList(); if (this.AddingDefaultValue) { AddDefaultValue(list, this.UseShortDefaultValue); } if (OrderBy != null) { list = BaseClassBL <KeyValue> .Sort(list, this.OrderBy, this.OrderDirection != null?this.OrderDirection : "asc").ToList(); } } else if (DataSourceType == "ProfileSetting") { var data = this.ownerPage.CostCalculationRef.GetProfilesList(new List <AbstractSearch>(), "", ""); list = (from ps in data select new KeyValue { idKeyValue = ps.idProfileSetting, Name = ps.ProfileName }).ToList <KeyValue>(); AddDefaultValue(list); } else { list = new List <KeyValue>(); } return(list); }