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);
}
//GetInterestForCampaign
internal async Task <DataSet> GetInterestForCampaign(int SiteID)
{
try
{
DataSet finalDataSet = new DataSet();
SQLGetListAsync sqlh = new SQLGetListAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@SiteID", SiteID)
};
finalDataSet = await sqlh.ExecuteAsDataSetAsync("[dbo].[usp_Wb_massMail_GetInterests]", param);
for (int i = 0; i < finalDataSet.Tables.Count; i++)
{
DataTable dt = finalDataSet.Tables[i];
if (dt.Rows.Count == 0)
{
finalDataSet.Tables.Remove(dt);
}
}
return(finalDataSet);// lstInterest.Select(x => x.CategoryName).Distinct().ToList();
}
catch
{
throw;
}
}
public async Task <IList <ProjectInfo> > GetProjectAsIListAsync()
{
string strSpName = "usp_GetProjectList";
SQLGetListAsync sqlHAsy = new SQLGetListAsync();
return(await sqlHAsy.ExecuteAsListAsync <ProjectInfo>(strSpName));
}
internal async Task <DataSet> GetAdvanceFilters(int SiteID)
{
try
{
DataSet finalDataSet = new DataSet();
IList <InterestAPIInfo> lstAPI = await this.GetInvokerAPI("advance");
SQLGetListAsync sqlh = new SQLGetListAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@SiteID", SiteID)
};
foreach (InterestAPIInfo objAPI in lstAPI)
{
DataSet ds = await sqlh.ExecuteAsDataSetAsync(objAPI.StoreProcName, param);
for (int i = 0; i < ds.Tables.Count; i++)
{
DataTable dt = ds.Tables[i];
if (dt.Rows.Count == 0)
{
ds.Tables.Remove(dt);
}
}
finalDataSet.Merge(ds);
}
return(finalDataSet);// lstInterest.Select(x => x.CategoryName).Distinct().ToList();
}
catch
{
throw;
}
}
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 <PageAction> > GetAllPageAction()
{
try
{
SQLGetListAsync handler = new SQLGetListAsync();
return(await handler.ExecuteAsListAsync <PageAction>("[dbo].[usp_Roles_GetAllPageAction]"));
}
catch
{
throw;
}
}
public async Task <IList <ApplicationNameInfo> > GetApplicationNames()
{
try
{
SQLGetListAsync objSQL = new SQLGetListAsync();
return(await objSQL.ExecuteAsListAsync <ApplicationNameInfo>("[dbo].[usp_Application_GetAll]"));
}
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 <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;
}
}
public async Task <IList <EmailTemplateComponent> > GetAllComponent()
{
try
{
SQLGetListAsync sql = new SQLGetListAsync();
return(await sql.ExecuteAsListAsync <EmailTemplateComponent>("[dbo].[usp_Email_Template_Component_GetAll]"));
}
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 <ControllerType> > GetControllerType()
{
SQLGetListAsync sqlhandler = new SQLGetListAsync();
try
{
return(await sqlhandler.ExecuteAsListAsync <ControllerType>("[usp_PageAction_GetControllerType]"));
}
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 <PageArea> > GetAllArea()
{
SQLGetListAsync sqlhandler = new SQLGetListAsync();
try
{
return(await sqlhandler.ExecuteAsListAsync <PageArea>("[usp_Page_GetAllArea]"));
}
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 <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 <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;
}
}
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;
}
}
internal async Task <DataSet> GetLayoutElement(string pageName, int siteID)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>();
sqlParam.Add(new SQLParam("@PageName", pageName));
sqlParam.Add(new SQLParam("@SiteID", siteID));
SQLGetListAsync sqlHandler = new SQLGetListAsync();
return(await sqlHandler.ExecuteAsDataSetAsync("[dbo].[usp_Dashboard_PageLayoutElementGet]", 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);
}
