internal async Task <WebbuilderViewInfo> GetPageViewDOM(WebbuilderViewGetInfo webbuilderViewGetInfo)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@Culture", webbuilderViewGetInfo.Culture),
new SQLParam("@PageName", webbuilderViewGetInfo.PageName),
new SQLParam("@SiteID", webbuilderViewGetInfo.SiteID)
};
SQLGetAsync sqlHelper = new SQLGetAsync();
if (webbuilderViewGetInfo.PreviewMode)
{
return(await sqlHelper.ExecuteAsObjectAsync <WebbuilderViewInfo>("[usp_WebBuilder_GetViewDOMByID]", sqlParam));
}
else
{
return(await sqlHelper.ExecuteAsObjectAsync <WebbuilderViewInfo>("[usp_WebBuilder_GetPublishedViewDOMByID]", sqlParam));
}
}
catch
{
throw;
}
}
public async Task <CustomerModel> ListCustomerByEmail(string objCName)
{
SQLGetAsync SQLH = new SQLGetAsync();
List <SQLParam> param = new List <SQLParam>()
{
new SQLParam("@email", objCName)
};
return(await SQLH.ExecuteAsObjectAsync <CustomerModel>("u_sp_CustomerByEmail", param));
}
public async Task <CustomerModel> ListCustomerById(Guid objCustomerid)
{
SQLGetAsync SQLH = new SQLGetAsync();
List <SQLParam> param = new List <SQLParam>()
{
new SQLParam("@customerid", objCustomerid),
};
return(await SQLH.ExecuteAsObjectAsync <CustomerModel>("u_sp_CustomerGetById", param));
}
public async Task <ProjectInfo> GetProjectAsync(ProjectInfo objInfo)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@ProjectID", objInfo.ProjectID));
string strSpName = "usp_GetProject";
SQLGetAsync sqlHAsy = new SQLGetAsync();
return(await sqlHAsy.ExecuteAsObjectAsync <ProjectInfo>(strSpName, Param));
}
public async Task <MediaSettingInfo> GetByID(long MediaSettingID)
{
try
{
List <SQLParam> param = new List <SQLParam>();
param.Add(new SQLParam("@MediaSettingID", MediaSettingID));
SQLGetAsync sqlHandler = new SQLGetAsync();
return(await sqlHandler.ExecuteAsObjectAsync <MediaSettingInfo>("[dbo].[usp_MediaSetting_GetByID]", param));
}
catch
{
throw;
}
}
public async Task <string> GetAdminSettings()
{
List <SQLParam> sQLParam = new List <SQLParam>();
SQLGetAsync sqlhandler = new SQLGetAsync();
try
{
return(await sqlhandler.ExecuteAsScalarAsync <string>("[usp_AdminSetting_GetSettings]", sQLParam));
}
catch
{
throw;
}
}
internal async Task <string> GetFormByPostId(int postId)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostId", postId));
try
{
SQLGetAsync handler = new SQLGetAsync();
return(await handler.ExecuteAsScalarAsync <string>("[usp_WebBuilder_DynamicPostType_GetFormByPostId]", sQLParam));
}
catch
{
throw;
}
}
public async Task <ApplicationNameInfo> GetApplicationByID(int applicationID)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@ApplicationID", applicationID));
try
{
SQLGetAsync objSQL = new SQLGetAsync();
return(await objSQL.ExecuteAsObjectAsync <ApplicationNameInfo>("[dbo].[usp_Application_GetByID]", sQLParam));
}
catch
{
throw;
}
}
internal async Task <PageDetail> GetPageDetails(Guid pageID)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@PageID", pageID)
};
SQLGetAsync sqlHandler = new SQLGetAsync();
return(await sqlHandler.ExecuteAsObjectAsync <PageDetail>("usp_Webbuilder_Page_Getdetails", sqlParam));
}
catch
{
throw;
}
}
public async Task <NL_UserInfo> GetByEmail(string EmailAddress)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@Email", EmailAddress)
};
SQLGetAsync sqlh = new SQLGetAsync();
return(await sqlh.ExecuteAsObjectAsync <NL_UserInfo>("[usp_Wb_Mail_NL_Subscriber_GetByEmail]", Param));
}
catch
{
throw;
}
}
public async Task <ImportUserInfo> GetImportUserByID(int subscriberID)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@SubscriberID", subscriberID)
};
SQLGetAsync sqlh = new SQLGetAsync();
return(await sqlh.ExecuteAsObjectAsync <ImportUserInfo>("usp_Wb_Mail_NL_Subscriber_GetImported", Param));
}
catch
{
throw;
}
}
internal async Task <ApplicationDetail> GetApplicationName(int siteID)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@SiteID", siteID)
};
SQLGetAsync sqlHandler = new SQLGetAsync();
return(await sqlHandler.ExecuteAsObjectAsync <ApplicationDetail>("[usp_webbuilder_application_GetApplicationName]", sqlParam));
}
catch
{
throw;
}
}
public async Task <MassMailReportInfo> GetReportByID(int MailID)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@MailID", MailID)
};
SQLGetAsync objHandler = new SQLGetAsync();
return(await objHandler.ExecuteAsObjectAsync <MassMailReportInfo>("[dbo].[usp_Wb_MassMail_GetReportByID]", Param));
}
catch
{
throw;
}
}
internal async Task <bool> CheckHasDetailTemplates(int postId)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostId", postId));
SQLGetAsync handler = new SQLGetAsync();
try
{
return(await handler.ExecuteAsScalarAsync <bool>("[usp_WebBuilder_DynamicPostType_CheckHasDetailTemplate]", sQLParam));
}
catch
{
throw;
}
}
public async Task <EmailTemplate> GetByIdentifier(string Identifier)
{
try
{
SQLGetAsync sql = new SQLGetAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@TemplateID", Identifier)
};
return(await sql.ExecuteAsObjectAsync <EmailTemplate>("[dbo].[usp_Email_Template_GetByIdentifier]", param));
}
catch
{
throw;
}
}
internal async Task <PostData> GetPostDataById(int postDataId)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostDataId", postDataId));
SQLGetAsync handler = new SQLGetAsync();
try
{
return(await handler.ExecuteAsObjectAsync <PostData>("[usp_WebBuilder_DynamicPostData_GetPostDataById]", sQLParam));
}
catch
{
throw;
}
}
public async Task <EmailTemplate> GetTemplateByID(int TemplateID, int SiteID)
{
try
{
SQLGetAsync sql = new SQLGetAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@TemplateID", TemplateID),
new SQLParam("@SiteID", SiteID),
};
return(await sql.ExecuteAsObjectAsync <EmailTemplate>("[dbo].[usp_Email_Template_GetByID]", param));
}
catch
{
throw;
}
}
internal async Task <CampaignSetting> GetCampaignSetting()
{
try
{
SQLGetAsync objHandler = new SQLGetAsync();
string sp_name = "[dbo].[usp_Campaign_GetCampaignSetting]";
return(await objHandler.ExecuteAsObjectAsync <CampaignSetting>(sp_name));
}
catch (Exception ex)
{
return(new CampaignSetting()
{
IsSubscribed = false
});
//ProcesssExection(ex);
}
}
public async Task <DashboardSideMenu> GetByID(Guid LinkID, int SiteID)
{
try
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@LinkID", LinkID),
new SQLParam("@SiteID", SiteID)
};
SQLGetAsync handler = new SQLGetAsync();
return(await handler.ExecuteAsObjectAsync <DashboardSideMenu>("[dbo].[usp_DashboardLink_GetByID]", param));
}
catch
{
throw;
}
}
public async Task <RoleViewModel> GetRoleByID(string roleID)
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@RoleID", roleID)
};
try
{
SQLGetAsync sqlhandler = new SQLGetAsync();
return(await sqlhandler.ExecuteAsObjectAsync <RoleViewModel>("[dbo].[usp_Roles_GetByID]", param));
}
catch
{
throw;
}
}
internal async Task <Template> GetTemplateById(int templateId, int siteId)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@TemplateId", templateId));
sQLParam.Add(new SQLParam("@SiteId", siteId));
SQLGetAsync handler = new SQLGetAsync();
try
{
return(await handler.ExecuteAsObjectAsync <Template>("[usp_WebBuilder_DynamicTemplate_GetTemplateById]", sQLParam));
}
catch
{
throw;
}
}
internal async Task <Post> GetPostByPostKey(string postKey, int siteId)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostKey", postKey));
sQLParam.Add(new SQLParam("@SiteId", siteId));
SQLGetAsync handler = new SQLGetAsync();
try
{
return(await handler.ExecuteAsObjectAsync <Post>("[usp_WebBuilder_DynamicPostType_GetPostByPostKey]", sQLParam));
}
catch
{
throw;
}
}
internal async Task <AssetCollection> GetAssetCollection(string pageName, string roleName)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@PageName", pageName),
new SQLParam("@RoleName", roleName)
};
SQLGetAsync sqlHandler = new SQLGetAsync();
return(await sqlHandler.ExecuteAsObjectAsync <AssetCollection>("[usp_Webbuilder_AssestCollection_Get]", sqlParam));
}
catch
{
throw;
}
}
//public async Task<UserProfileEditModel> GetUserById(string userID)
//{
// List<SQLParam> pairs = new List<SQLParam>();
// pairs.Add(new SQLParam("@UserId", userID));
// SQLGetAsync sql = new SQLGetAsync();
// return await sql.ExecuteAsObjectAsync<UserProfileEditModel>("usp_Dashboard_Users_GetUserByID", pairs);
//}
//public async Task<int> AddUpdateUser(UserProfileEditModel user)
//{
// List<SQLParam> pairs = new List<SQLParam>();
// pairs.Add(new SQLParam("@UserId", user.UserId));
// pairs.Add(new SQLParam("@FirstName", user.FirstName));
// pairs.Add(new SQLParam("@LastName", user.LastName));
// pairs.Add(new SQLParam("@PhoneNumber", user.PhoneNumber));
// pairs.Add(new SQLParam("@Email", user.Email));
// pairs.Add(new SQLParam("@ImagePath", user.ImagePath));
// pairs.Add(new SQLParam("@Country", user.Country));
// pairs.Add(new SQLParam("@About", user.About));
// SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
// return await sql.ExecuteNonQueryAsGivenTypeAsync<int>("usp_Dashboard_Users_UpdateUser", pairs, "@result");
//}
public async Task <UserProfile> GetUserProfileByUserID(string UserID)
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@UserID", UserID)
};
try
{
SQLGetAsync handler = new SQLGetAsync();
return(await handler.ExecuteAsObjectAsync <UserProfile>("[dbo].[usp_UserProfile_GetByID]", param));
}
catch
{
throw;
}
}
internal async Task <SEOMetaValues> GetSEOMetaValuesByPageName(string pageName, int siteID)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PageName", pageName));
sQLParam.Add(new SQLParam("@SiteID", siteID));
SQLGetAsync sagesql = new SQLGetAsync();
try
{
return(await sagesql.ExecuteAsObjectAsync <SEOMetaValues>("[usp_SEO_GetSEOMetaValuesByPageName]", sQLParam));
}
catch
{
throw;
}
}
internal async Task <PageArea> GetPageAreaByID(string areaID)
{
SQLGetAsync sqlhandler = new SQLGetAsync();
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@AreaID", areaID)
};
try
{
return(await sqlhandler.ExecuteAsObjectAsync <PageArea>("[usp_PageAction_GetPageAreaByID]", sQLParam));
}
catch
{
throw;
}
}
public async Task <KeyValue> GetSettingValueByKey(string settingKey)
{
KeyValue value = new KeyValue();
try
{
List <SQLParam> sqlParam = new List <SQLParam>();
sqlParam.Add(new SQLParam("@SettingKey", settingKey));
SQLHandler sagesql = new SQLHandler();
SQLGetAsync sqlHandler = new SQLGetAsync();
value = await sqlHandler.ExecuteAsObjectAsync <KeyValue>("[usp_webbuilder_settings_getbykey]", sqlParam);
}
catch
{
throw;
}
return(value);
}
internal async Task <CbuilderView> GetEditDOMByID(WebBuilderInfo objWebBuilder)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@Culture", objWebBuilder.Culture),
new SQLParam("@PageName", objWebBuilder.PageName),
new SQLParam("@SiteID", objWebBuilder.SiteID)
};
SQLGetAsync sqlHandler = new SQLGetAsync();
return(await sqlHandler.ExecuteAsObjectAsync <CbuilderView>("[usp_WebBuilder_GetEditDOMByID]", sqlParam));
}
catch
{
throw;
}
}
public async Task <string> GetRoleRedirectURL(string roleNames, int siteID)
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@RoleIDs", roleNames),
new SQLParam("@SiteID", siteID)
};
try
{
SQLGetAsync sqlhandler = new SQLGetAsync();
return(await sqlhandler.ExecuteAsScalarAsync <string>("[dbo].[usp_Admin_RoleUrlMap_GetByRole]", param));
}
catch
{
throw;
}
}
public async Task <string> GetAdminSettings(string keysJSON)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@keysJSON", keysJSON));
SQLGetAsync sqlhandler = new SQLGetAsync();
try
{
var obj = await sqlhandler.ExecuteAsObjectAsync <Settings>("[dbo].[usp_AdminSetting_GetSettings]", sQLParam);
return(obj.Value);
}
catch
{
throw;
}
}
