public async Task <IList <ProjectInfo> > GetProjectAsIListAsync() { string strSpName = "usp_GetProjectList"; SQLGetListAsync sqlHAsy = new SQLGetListAsync(); return(await sqlHAsy.ExecuteAsListAsync <ProjectInfo>(strSpName)); }
public async Task <IList <AssetViewSettings> > GetAssetSettingsByArea(int applicationID, int areaID, string assetType, string excessMode) { List <SQLParam> sQLParam = new List <SQLParam>(); sQLParam.Add(new SQLParam("@ApplicationID", applicationID)); sQLParam.Add(new SQLParam("@AreaID", areaID)); sQLParam.Add(new SQLParam("@AssetType", assetType)); sQLParam.Add(new SQLParam("@ExcessMode", excessMode)); IList <AssetViewSettings> lstAssets = new List <AssetViewSettings>(); try { SQLGetListAsync objSQL = new SQLGetListAsync(); lstAssets = await objSQL.ExecuteAsListAsync <AssetViewSettings>("[dbo].[usp_Asset_Settings_GetByArea]", sQLParam); } catch (Exception) { throw; } return(lstAssets); }
public async Task <IList <ComponentInfo> > GetGenericComponent(int componentId, int siteId) { List <SQLParam> param = new List <SQLParam>(); param.Add(new SQLParam("@ComponentId", componentId)); param.Add(new SQLParam("@SiteId", siteId)); SQLGetListAsync sqlList = new SQLGetListAsync(); return(await sqlList.ExecuteAsListAsync <ComponentInfo>("usp_Webbuilder_GenericData_GetAllComponent", param)); }
public async Task <IList <MassMailTimeZoneInfo> > GetAllTimeZone() { try { SQLGetListAsync hdlrObj = new SQLGetListAsync(); return(await hdlrObj.ExecuteAsListAsync <MassMailTimeZoneInfo>("[dbo].[usp_Wb_TimeZone_GetAll]")); } catch { throw; } }
public async Task <IList <MethodInvokerInfo> > GetAllAppMethods() { try { SQLGetListAsync hdlrObj = new SQLGetListAsync(); return(await hdlrObj.ExecuteAsListAsync <MethodInvokerInfo>("[dbo].[usp_Wb_MassMail_TokenReplaceInvoker]")); } catch { throw; } }
public async Task <IList <RoleViewModel> > GetAllRoleView() { try { SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <RoleViewModel>("[dbo].[usp_Roles_GetAllView]")); } catch { throw; } }
public async Task <IList <GroupInfo> > GetGroupList() { try { SQLGetListAsync SQL = new SQLGetListAsync(); return(await SQL.ExecuteAsListAsync <GroupInfo>("usp_Wb_GetAllGroups")); } catch { throw; } }
public async Task <IList <LanguageMiniInfo> > GetLanguageForViewComponent() { try { SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <LanguageMiniInfo>("[dbo].[usp_Localization_GetLanguageForViewComponent]")); } catch { throw; } }
public async Task <IList <ApplicationNameInfo> > GetApplicationNames() { try { SQLGetListAsync objSQL = new SQLGetListAsync(); return(await objSQL.ExecuteAsListAsync <ApplicationNameInfo>("[dbo].[usp_Application_GetAll]")); } catch { throw; } }
public async Task <IList <ProjectInfo> > GetProjectList() { //List<KeyValuePair<string, object>> Param = new List<KeyValuePair<string, object>>(); //Param.Add(new KeyValuePair<string, object>("@ProjectID", objInfo.ProjectID)); //Param.Add(new KeyValuePair<string, object>("@ProjectName", objInfo.ProjectName)); //Param.Add(new KeyValuePair<string, object>("@ProjectCode", objInfo.ProjectCode)); string strSpName = "usp_GetProjectList"; SQLGetListAsync sqlHAsy = new SQLGetListAsync(); //List<ProjectInfo> objList = await sqlHAsy.ExecuteAsListAsync<ProjectInfo>(strSpName, Param); return(await sqlHAsy.ExecuteAsListAsync <ProjectInfo>(strSpName)); }
public async Task <IList <KeyValue> > GetFilePath() { try { SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <KeyValue>("[dbo].[usp_Localization_GetFiles]")); } catch { throw; } }
internal async Task <IList <MassMailSettingInfo> > GetAllSettings() { try { SQLGetListAsync objHandler = new SQLGetListAsync(); return(await objHandler.ExecuteAsListAsync <MassMailSettingInfo>("[dbo].[usp_Wb__MassMailSettings_GetAll]")); } catch { throw; } }
public async Task <IList <EmailTemplateComponent> > GetAllComponent() { try { SQLGetListAsync sql = new SQLGetListAsync(); return(await sql.ExecuteAsListAsync <EmailTemplateComponent>("[dbo].[usp_Email_Template_Component_GetAll]")); } catch { throw; } }
public async Task <IList <PageAction> > GetAllPageAction() { try { SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <PageAction>("[dbo].[usp_Roles_GetAllPageAction]")); } catch { throw; } }
internal async Task <IList <ControllerType> > GetControllerType() { SQLGetListAsync sqlhandler = new SQLGetListAsync(); try { return(await sqlhandler.ExecuteAsListAsync <ControllerType>("[usp_PageAction_GetControllerType]")); } catch { throw; } }
internal async Task <IList <ActionGroup> > GetActionGroup() { SQLGetListAsync sqlhandler = new SQLGetListAsync(); try { return(await sqlhandler.ExecuteAsListAsync <ActionGroup>("[usp_PageAction_GetActionGroup]")); } catch { throw; } }
public async Task <IList <IdentityAction> > GetAllIdentityActions() { SQLGetListAsync sqlhandler = new SQLGetListAsync(); try { return(await sqlhandler.ExecuteAsListAsync <IdentityAction>("[usp_PageAction_GetAllIdentityActions]")); } catch { throw; } }
internal async Task <IList <Template> > GetTemplate() { SQLGetListAsync handler = new SQLGetListAsync(); try { return(await handler.ExecuteAsListAsync <Template>("[usp_WebBuilder_DynamicTemplate_GetTemplate")); } catch { throw; } }
internal async Task <IList <IdentityScope> > GetIdentityScopes(string selectedIDs) { try { List <SQLParam> sQLParam = new List <SQLParam> { new SQLParam("@SelectedIDs", selectedIDs) }; SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <IdentityScope>("[usp_Permission_GetIdentityScopes]", sQLParam)); } catch { throw; } }
internal async Task <IList <Post> > GetPostAndId() { SQLGetListAsync handler = new SQLGetListAsync(); try { return(await handler.ExecuteAsListAsync <Post>("[usp_WebBuilder_DynamicPostType_GetPostAndId]")); } catch { throw; } }
internal async Task <IList <SEOMetaType> > GetSeoTags() { SQLGetListAsync sagesql = new SQLGetListAsync(); try { return(await sagesql.ExecuteAsListAsync <SEOMetaType>("[usp_SEO_GetMetaTags]")); } catch { throw; } }
internal Task <IList <WebTypes> > GetWebTypes() { SQLGetListAsync sagesql = new SQLGetListAsync(); try { return(sagesql.ExecuteAsListAsync <WebTypes>("[usp_SEOTypesValue_Get]")); } catch { throw; } }
internal async Task <IList <PageArea> > GetAllArea() { SQLGetListAsync sqlhandler = new SQLGetListAsync(); try { return(await sqlhandler.ExecuteAsListAsync <PageArea>("[usp_Page_GetAllArea]")); } catch { throw; } }
private async Task <IList <ElementPermission> > GetElementPermission(string actionXML, string roleNames) { try { List <SQLParam> sQLParam = new List <SQLParam> { new SQLParam("@ActionXML", actionXML), new SQLParam("@RoleNames", roleNames), }; SQLGetListAsync handler = new SQLGetListAsync(); return(await handler.ExecuteAsListAsync <ElementPermission>("[dbo].[usp_Permission_GetRequired]", sQLParam)); } catch { throw; } }
internal async Task <IList <ViewModule> > GetAvailableModule() { try { // List<SQLParam> sqlParam = new List<SQLParam>(); SQLGetListAsync sqlHandler = new SQLGetListAsync(); return(await sqlHandler.ExecuteAsListAsync <ViewModule>("[dbo].[usp_Dashboard_ViewModule_GetAll]")); } catch { throw; } }
internal async Task <IList <Block> > GetBoardListByUsage(Block block) { try { List <SQLParam> sqlParam = new List <SQLParam>(); sqlParam.Add(new SQLParam("@RenderName", block.RenderName)); SQLGetListAsync sqlHandler = new SQLGetListAsync(); return(await sqlHandler.ExecuteAsListAsync <Block>("[usp_Webbuilder_Block_GetByRenderName]", sqlParam)); } catch { throw; } }
public async Task <IList <UserAreaModel> > GetUserAreas() { IList <UserAreaModel> userAreas; try { SQLGetListAsync objSQL = new SQLGetListAsync(); userAreas = await objSQL.ExecuteAsListAsync <UserAreaModel>("[dbo].[usp_Asset_UserArea_Get]"); } catch (Exception) { throw; } return(userAreas); }
private async Task <IList <InterestAPIInfo> > GetInvokerAPI(string invokerType) { try { SQLGetListAsync sqlh = new SQLGetListAsync(); List <SQLParam> param = new List <SQLParam> { new SQLParam("@InvokerType", invokerType) }; return(await sqlh.ExecuteAsListAsync <InterestAPIInfo>("usp_Wb_Mail_SpInvoker_GetAll", param)); } catch { throw; } }
/// <summary> /// Connects to database and returns NL_Info list containing subscriber list. /// </summary> /// <param name="index">index</param> /// <returns>NL_Info list</returns> public async Task <IList <NL_UserInfo> > GetSubscriberList(int index) { try { List <SQLParam> Param = new List <SQLParam> { new SQLParam("@Offset", index) }; SQLGetListAsync sqlh = new SQLGetListAsync(); return(await sqlh.ExecuteAsListAsync <NL_UserInfo>("usp_NL_GetSubscriberList", Param)); } catch { throw; } }
public async Task <IList <PageApplicationArea> > GetAreas(int SiteID) { try { SQLGetListAsync handler = new SQLGetListAsync(); List <SQLParam> param = new List <SQLParam> { new SQLParam("@SiteID", SiteID) }; return(await handler.ExecuteAsListAsync <PageApplicationArea>("[dbo].[usp_PageApplicationArea_GetAll]", param)); } catch { throw; } }