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);
}
