/// -----------------------------------------------------------------------------
/// <summary>
/// GetHtmlTextLog retrieves a collection of HtmlTextLogInfo objects for an Item
/// </summary>
/// <remarks>
/// </remarks>
/// <param name = "ItemID">The Id of the Item</param>
/// -----------------------------------------------------------------------------
public ArrayList GetHtmlTextLog(int ItemID)
{
return(CBO.FillCollection(DataProvider.Instance().GetHtmlTextLog(ItemID), typeof(HtmlTextLogInfo)));
}
public static List <DiemDL> All()
{
return(CBO.FillCollection <DiemDL>(DataProvider.Instance.ExecuteReader("DiemDL_All")));
}
public static List <DiemDL> FindByTenD_MaDD(string _TenDDL, int _MaDD)
{
return(CBO.FillCollection <DiemDL>(DataProvider.Instance.ExecuteReader("DiemDL_FindByTenD_MaDD", _TenDDL, _MaDD)));
}
/// <summary>
/// override for Database Function
/// </summary>
/// <param name="portalId"></param>
/// <param name="moduleId"></param>
/// <param name="typeCode"></param>
/// <param name="sqlSearchFilter"></param>
/// <param name="sqlOrderBy"></param>
/// <param name="returnLimit"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="typeCodeLang"></param>
/// <param name="lang"></param>
/// <returns></returns>
public override List <NBrightInfo> GetList(int portalId, int moduleId, string typeCode, string sqlSearchFilter = "", string sqlOrderBy = "", int returnLimit = 0, int pageNumber = 0, int pageSize = 0, int recordCount = 0, string lang = "")
{
return(CBO.FillCollection <NBrightInfo>(DataProvider.Instance().GetList(portalId, moduleId, typeCode, sqlSearchFilter, sqlOrderBy, returnLimit, pageNumber, pageSize, recordCount, lang)));
}
private static object GetAuthenticationServicesCallBack(CacheItemArgs cacheItemArgs)
{
return(CBO.FillCollection <AuthenticationInfo>(provider.GetAuthenticationServices()));
}
public static List <KhachHang> FindByGende(bool _gender)
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindByGender", _gender)));
}
public static List <KhachHang> FindMothCurrentBirthDay()
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindMothCurrentBirthDay")));
}
public override IList <RoleInfo> GetRolesBasicSearch(int portalID, int pageSize, string filterBy)
{
return(CBO.FillCollection <RoleInfo>(dataProvider.GetRolesBasicSearch(portalID, -1, pageSize, filterBy)));
}
/// -----------------------------------------------------------------------------
/// <summary>
/// GetUserRoles gets a collection of User/Role objects from the Data Store
/// </summary>
/// <remarks>
/// </remarks>
/// <param name="portalId">Id of the portal</param>
/// <param name="userName">The user to fetch roles for</param>
/// <param name="roleName">The role to fetch users for</param>
/// <returns>An ArrayList of UserRoleInfo objects</returns>
/// <history>
/// [cnurse] 03/28/2006 created
/// </history>
/// -----------------------------------------------------------------------------
public override ArrayList GetUserRoles(int portalId, string userName, string roleName)
{
return(CBO.FillCollection(dataProvider.GetUserRolesByUsername(portalId, userName, roleName), typeof(UserRoleInfo)));
}
public static List <BackupInfo> GetDbBackups()
{
return(CBO.FillCollection <BackupInfo>(DataService.GetDbBackups()));
}
public static List <DbFileInfo> GetDbFileInfo()
{
return(CBO.FillCollection <DbFileInfo>(DataService.GetDbFileInfo()));
}
public ArrayList GetBanners(int VendorId)
{
return(CBO.FillCollection(DataProvider.Instance().GetBanners(VendorId), typeof(BannerInfo)));
}
private object GetPortalGroupsCallback(CacheItemArgs cacheItemArgs)
{
return(CBO.FillCollection <PortalGroupInfo>(_dataService.GetPortalGroups()));
}
private static object GetServersCallBack(CacheItemArgs cacheItemArgs)
{
return(CBO.FillCollection <ServerInfo>(dataProvider.GetServers()));
}
public static List <KhachHang> Find(string expression)
{
string s = Expresstion(expression);
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("SearchByCondition", "KhachHang", s)));
}
private static List <ExportWorkflow> GetWorkflows(int portalId, bool includeDeletions)
{
return(CBO.FillCollection <ExportWorkflow>(
DataProvider.Instance().GetAllWorkflows(portalId, includeDeletions)));
}
public static List <KhachHang> All()
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_All")));
}
private static List <ExportWorkflowState> GetWorkflowStates(int workflowId)
{
return(CBO.FillCollection <ExportWorkflowState>(
DataProvider.Instance().GetAllWorkflowStates(workflowId)));
}
public static List <KhachHang> FindByCountry(string _country)
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindByCountry", _country)));
}
private static List <ExportWorkflowStatePermission> GetWorkflowStatePermissions(
int stateId, DateTime toDate, DateTime?fromDate)
{
return(CBO.FillCollection <ExportWorkflowStatePermission>(
DataProvider.Instance().GetAllWorkflowStatePermissions(stateId, toDate, fromDate)));
}
public static List <KhachHang> FindCities()
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindCities")));
}
public static List <ExtensionUrlProviderInfo> GetProviders(int portalId)
{
return(CBO.FillCollection <ExtensionUrlProviderInfo>(DataProvider.Instance().GetExtensionUrlProviders(portalId)));
}
// Journal Comments
public IList <CommentInfo> GetCommentsByJournalIds(List <int> journalIdList)
{
var journalIds = journalIdList.Aggregate("", (current, journalId) => current + journalId + ";");
return(CBO.FillCollection <CommentInfo>(_dataService.Journal_Comment_ListByJournalIds(journalIds)));
}
/// <summary>
/// Loads the module providers
/// </summary>
/// <param name="portalId"></param>
/// <returns></returns>
/// <remarks>Note : similar copy for UI purposes in ConfigurationController.cs</remarks>
public static List <ExtensionUrlProvider> GetModuleProviders(int portalId)
{
var cacheKey = String.Format("ExtensionUrlProviders_{0}", portalId);
var moduleProviders = CBO.GetCachedObject <List <ExtensionUrlProvider> >(new CacheItemArgs(cacheKey,
60,
CacheItemPriority.High,
portalId),
c =>
{
var id = (int)c.Params[0];
IDataReader dr = DataProvider.Instance().GetExtensionUrlProviders(id);
try
{
var providers = new List <ExtensionUrlProvider>();
var providerConfigs = CBO.FillCollection(dr, new List <ExtensionUrlProviderInfo>(), false);
foreach (var providerConfig in providerConfigs)
{
var providerType = Reflection.CreateType(providerConfig.ProviderType);
if (providerType == null)
{
continue;
}
var provider = Reflection.CreateObject(providerType) as ExtensionUrlProvider;
if (provider == null)
{
continue;
}
provider.ProviderConfig = providerConfig;
provider.ProviderConfig.PortalId = id;
providers.Add(provider);
}
if (dr.NextResult())
{
//Setup Settings
while (dr.Read())
{
var extensionUrlProviderId = Null.SetNullInteger(dr["ExtensionUrlProviderID"]);
var key = Null.SetNullString(dr["SettingName"]);
var value = Null.SetNullString(dr["SettingValue"]);
var provider = providers.SingleOrDefault(p => p.ProviderConfig.ExtensionUrlProviderId == extensionUrlProviderId);
if (provider != null)
{
provider.ProviderConfig.Settings[key] = value;
}
}
}
if (dr.NextResult())
{
//Setup Tabs
while (dr.Read())
{
var extensionUrlProviderId = Null.SetNullInteger(dr["ExtensionUrlProviderID"]);
var tabId = Null.SetNullInteger(dr["TabID"]);
var provider = providers.SingleOrDefault(p => p.ProviderConfig.ExtensionUrlProviderId == extensionUrlProviderId);
if (provider != null && !provider.ProviderConfig.TabIds.Contains(tabId))
{
provider.ProviderConfig.TabIds.Add(tabId);
}
}
}
return(providers);
}
finally
{
//Close reader
CBO.CloseDataReader(dr, true);
}
});
return(moduleProviders);
}
public static List <DiemDL> Find(string expression)
{
string s = Expresstion(expression);
return(CBO.FillCollection <DiemDL>(DataProvider.Instance.ExecuteReader("SearchByCondition", "View_DiemDL", s)));
}
public static List <KhachHang> FindByName(string _name)
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindByName", _name)));
}
public static List <DiemDL> FindByName(string _Name)
{
return(CBO.FillCollection <DiemDL>(DataProvider.Instance.ExecuteReader("DiemDL_FindByName", _Name)));
}
public static List <KhachHang> FindByMChuyen(int _MChuyen)
{
return(CBO.FillCollection <KhachHang>(DataProvider.Instance.ExecuteReader("KhachHang_FindByMChuyen", _MChuyen)));
}
public static List <DiemDL> SearchKey(string _Key)
{
return(CBO.FillCollection <DiemDL>(DataProvider.Instance.ExecuteReader("View_DiemDL_Search", _Key)));
}
public override ArrayList GetLogTypeInfo()
{
return(CBO.GetCachedObject <ArrayList>(
new CacheItemArgs(LogTypeCacheKey, 20, CacheItemPriority.Normal),
c => CBO.FillCollection(DataProvider.Instance().GetLogTypeInfo(), typeof(LogTypeInfo))));
}