public async Task <int> AddNewPost(Post postObj, int siteId, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostKey", postObj.GeneratePostKey()));
sQLParam.Add(new SQLParam("@SiteId", siteId));
sQLParam.Add(new SQLParam("@Name", postObj.Name));
sQLParam.Add(new SQLParam("@Form", postObj.Form));
sQLParam.Add(new SQLParam("@HasDetail", postObj.HasDetail));
sQLParam.Add(new SQLParam("@IsActive", postObj.IsActive));
sQLParam.Add(new SQLParam("@AddedBy", userName));
sQLParam.Add(new SQLParam("@ComponentDataList", postObj.ComponentDataList));
sQLParam.Add(new SQLParam("@ComponentDataDetail", postObj.ComponentDataDetail));
sQLParam.Add(new SQLParam("@ComponentDataListView", postObj.ComponentDataListView));
sQLParam.Add(new SQLParam("@ComponentDataDetailView", postObj.ComponentDataDetailView));
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
try
{
return(await handler.ExecuteNonQueryAsync("[usp_WebBuilder_DynamicPostType_AddNewPost]", sQLParam, "@output"));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <bool> CheckFrontPagePermission(string PageName, string ActionName, string RoleNames)
{
try
{
if (RoleNames.Contains("Super Admin"))
{
return(true);
}
else
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@RoleNames", RoleNames),
new SQLParam("@PageName", PageName),
new SQLParam("@ActionName", ActionName),
};
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
int rs = await handler.ExecuteNonQueryAsync("[usp_Permission_CheckFrontPermission]", sQLParam, "@Permission");
return(rs == 1);
}
}
catch
{
throw;
}
}
public async Task <OperationStatus> ManageService(ServiceActionBind serviceActionBind, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@PageActionID", serviceActionBind.PageAction.PageActionID),
new SQLParam("@SelectedService", serviceActionBind.PageAction.SelectedService),
new SQLParam("@UserName", userName)
};
try
{
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
int result = await handler.ExecuteNonQueryAsync("[usp_PageAction_ManageService]", sQLParam, "@Status");
if (result == 1)
{
return(new OperationStatus {
Message = "Identy scope added successfully.", StatusCode = StatusCode.Created, Result = result
});
}
return(new OperationStatus {
Message = "Something went wrong while Action deleted.", StatusCode = StatusCode.ServerError, Result = result
});
}
catch (Exception ex)
{
throw ex;
}
}
internal async Task <OperationStatus> DeleteArea(string id, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@AreaID", id),
new SQLParam("@UserName", userName)
};
try
{
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
int result = await handler.ExecuteNonQueryAsync("[usp_PageAction_DeleteArea]", sQLParam, "@Status");
if (result == 1)
{
return(new OperationStatus {
Message = "Area deleted successfully.", StatusCode = StatusCode.Created, Result = result
});
}
return(new OperationStatus {
Message = "Something went wrong while Action deleted.", StatusCode = StatusCode.ServerError, Result = result
});
}
catch (Exception ex)
{
throw ex;
}
}
internal async Task <int> AddUpdate(WebBuilderInfo objWebBuilder)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>
{
new SQLParam("@WebBuilderID", objWebBuilder.WebBuilderID),
new SQLParam("@EditDOM", objWebBuilder.EditDOM),
new SQLParam("@ViewDOM", objWebBuilder.ViewDOM),
new SQLParam("@Culture", objWebBuilder.Culture),
new SQLParam("@UserName", objWebBuilder.UserName),
new SQLParam("@Extra", objWebBuilder.Extra),
new SQLParam("@Settings", objWebBuilder.Settings),
new SQLParam("@PageName", objWebBuilder.PageName),
new SQLParam("@Header", objWebBuilder.Header),
new SQLParam("@HeaderEdit", objWebBuilder.HeaderEdit),
new SQLParam("@Footer", objWebBuilder.Footer),
new SQLParam("@FooterEdit", objWebBuilder.FooterEdit),
new SQLParam("@PackageXML", objWebBuilder.PackageXML),
new SQLParam("@PageComponent", objWebBuilder.PageComponent),
new SQLParam("@HeaderFooterComponent", objWebBuilder.HeaderFooterComponent),
new SQLParam("@CloneWebBuilderID", objWebBuilder.CloneWebBuilderID),
new SQLParam("@SiteID", objWebBuilder.SiteID)
};
SQLExecuteNonQueryAsync sqlHandler = new SQLExecuteNonQueryAsync();
return(await sqlHandler.ExecuteNonQueryAsync("[usp_WebBuilder_AddUpdate]", sqlParam, "@webbuildernewID"));
}
catch
{
throw;
}
}
/// <summary>
/// Connect to database and add update pages.
/// </summary>
/// <param name="objPage">Object of PortalPage class.</param>
public async Task <string> AddUpdatePages(PortalPage objPage, List <PageRolePermission> RolePermissions, int siteID, string userName)
{
SQLExecuteNonQueryAsync sagesql = new SQLExecuteNonQueryAsync();
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PageID", objPage.PageID));
sQLParam.Add(new SQLParam("@PageName", objPage.PageName.ToString()));
sQLParam.Add(new SQLParam("@Title", objPage.Title));
sQLParam.Add(new SQLParam("@Description", objPage.Description));
sQLParam.Add(new SQLParam("@KeyWords", objPage.KeyWords));
sQLParam.Add(new SQLParam("@IsActive", objPage.IsActive));
sQLParam.Add(new SQLParam("@SiteID", siteID));
sQLParam.Add(new SQLParam("@AddedBy", userName));
try
{
string pageid = string.Empty;
pageid = await sagesql.ExecuteNonQueryAsGivenTypeAsync <string>("[usp_PageMgr_AddUpdatePage]", sQLParam, "@output");
if (pageid != string.Empty && RolePermissions.Count > 0)
{
foreach (PageRolePermission rolePermission in RolePermissions)
{
await AddUpdteRolePermission(pageid, rolePermission.RoleName, rolePermission.SelectedPageActions, userName);
}
}
return(pageid);
}
catch
{
throw;
}
}
public async Task <OperationStatus> AddUpdateComponent(string ComponentName, string ComponentValue)
{
try
{
SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@ComponentName", ComponentName),
new SQLParam("@ComponentValue", ComponentValue)
};
int status = await sql.ExecuteNonQueryAsync("[dbo].[usp_Email_Template_Component_AddUpdate]", param, "@Status");
//if (status == (int)SpOperation.Insert)
if (status == 1)
{
return new OperationStatus()
{
Message = "Component Added Successfully."
}
}
;
return(new OperationStatus()
{
Message = "Component Updated Successfully."
});
}
catch
{
throw;
}
}
public async Task <OperationStatus> SaveRolewiseRedirect(string roleUrlXML, int siteID, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@RoleUrlXML", roleUrlXML),
new SQLParam("@UserName", userName),
new SQLParam("@SiteID", siteID)
};
try
{
SQLExecuteNonQueryAsync sqlhandler = new SQLExecuteNonQueryAsync();
int result = await sqlhandler.ExecuteNonQueryAsync("[dbo].[usp_RolewiseRedirect_AddUpdate]", sQLParam, "@Status");
if (result == 1)
{
return(new OperationStatus {
Message = "Role and Redirect Url mapped successfully.", StatusCode = StatusCode.Created, Result = result
});
}
return(new OperationStatus {
Message = "Something went wrong while mapping role and page.", StatusCode = StatusCode.ServerError, Result = result, IsSuccess = false
});
}
catch
{
throw;
}
}
public async Task <OperationStatus> AddUpdateTemplate(EmailTemplate tem, int SiteID, string UserName)
{
try
{
SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@TemplateID", tem.TemplateID),
new SQLParam("@EditDOM", tem.EditDOM),
new SQLParam("@ViewDOM", tem.ViewDOM),
new SQLParam("@Name", tem.Name),
new SQLParam("@Subject", tem.Subject),
new SQLParam("@CultureCode", tem.CultureCode),
new SQLParam("@ScreenShot", tem.ScreenShot),
new SQLParam("@CatID", tem.CategoryID),
new SQLParam("@SiteID", SiteID),
new SQLParam("@Username", UserName),
};
int TempID = await sql.ExecuteNonQueryAsync("[dbo].[usp_Email_Template_AddUpdate]", param, "@TempID");
return(new OperationStatus()
{
StatusCode = tem.TemplateID == 0 ? StatusCode.Created : StatusCode.Updated, Result = TempID
});
}
catch
{
throw;
}
}
public async Task <int> SaveAssetSettings(SaveAssetInfo asset)
{
int result = 1;
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@BundleAssetID", asset.AssetID));
sQLParam.Add(new SQLParam("@Name", asset.Names));
sQLParam.Add(new SQLParam("@AssetType", asset.AssetType));
sQLParam.Add(new SQLParam("@Position", asset.Position));
sQLParam.Add(new SQLParam("@FilePath", asset.FilePath));
sQLParam.Add(new SQLParam("@IsExternal", asset.IsExternal));
sQLParam.Add(new SQLParam("@ExcessMode", asset.ExcessMode));
sQLParam.Add(new SQLParam("@Application", asset.Application));
sQLParam.Add(new SQLParam("@UserAreaID", asset.UserAreaID));
sQLParam.Add(new SQLParam("@Roles", asset.Roles));
try
{
SQLExecuteNonQueryAsync objSQL = new SQLExecuteNonQueryAsync();
await objSQL.ExecuteNonQueryAsync("[dbo].[usp_Asset_Save]", sQLParam);
}
catch
{
throw;
}
return(result);
}
public async Task <int> UpdatePost(Post postObj, int siteId, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@PostId", postObj.PostId));
sQLParam.Add(new SQLParam("@SiteId", siteId));
sQLParam.Add(new SQLParam("@Name", postObj.Name));
sQLParam.Add(new SQLParam("@Form", postObj.Form));
sQLParam.Add(new SQLParam("@HasDetail", postObj.HasDetail));
sQLParam.Add(new SQLParam("@UpdatedBy", userName));
sQLParam.Add(new SQLParam("@ComponentDataList", postObj.ComponentDataList));
sQLParam.Add(new SQLParam("@ComponentDataDetail", postObj.ComponentDataDetail));
sQLParam.Add(new SQLParam("@ComponentDataListView", postObj.ComponentDataListView));
sQLParam.Add(new SQLParam("@ComponentDataDetailView", postObj.ComponentDataDetailView));
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
try
{
return(await handler.ExecuteNonQueryAsync("[usp_WebBuilder_DynamicPostType_UpdatePost]", sQLParam, "@output"));
}
catch
{
throw;
}
}
internal async Task <int> AddNewTemplate(Template obj, string appPath, int siteId, string userName)
{
int createdTemplateId = 0;
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@TemplateKey", obj.GenerateTemplateKey()));
sQLParam.Add(new SQLParam("@SiteId", siteId));
sQLParam.Add(new SQLParam("@PostId", obj.PostId));
sQLParam.Add(new SQLParam("@PostKey", obj.PostKey));
sQLParam.Add(new SQLParam("@TemplateName", obj.TemplateName));
sQLParam.Add(new SQLParam("@TemplateViewDom", obj.TemplateViewDom));
sQLParam.Add(new SQLParam("@TemplateEditDom", obj.TemplateEditDom));
sQLParam.Add(new SQLParam("@Screenshot", obj.ScreenshotFile(appPath)));
sQLParam.Add(new SQLParam("@Type", obj.Type));
sQLParam.Add(new SQLParam("@IsActive", obj.IsActive));
sQLParam.Add(new SQLParam("@AddedBy", userName));
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
try
{
createdTemplateId = await handler.ExecuteNonQueryAsync("[usp_WebBuilder_DynamicTemplate_AddNewTemplate]", sQLParam, "@CreatedTemplateId");
return(createdTemplateId);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and save email for subscribing.
/// </summary>
public async Task <int> SaveEmailSubscriber(NL_UserInfo objInfo)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@SubscriberID", objInfo.SubscriberID),
new SQLParam("@SubscriberEmail", objInfo.SubscriberEmail),
new SQLParam("@ClientIP", objInfo.ClientIP),
new SQLParam("@FirstName", objInfo.FirstName),
new SQLParam("@LastName", objInfo.LastName),
new SQLParam("@Location", objInfo.Location),
new SQLParam("@Gender", (int)objInfo.Gender),
new SQLParam("@InterestInAll", objInfo.InterestInAll),
new SQLParam("@Interest", objInfo.Interest),
new SQLParam("@IsImported", objInfo.IsImported),
new SQLParam("@RecipientGroup", objInfo.RecipientGroup),
new SQLParam("@CompanyName", objInfo.CompanyName),
new SQLParam("@PhoneNumber", objInfo.PhoneNumber),
new SQLParam("@Profession", objInfo.Profession),
new SQLParam("@Source", objInfo.Source),
new SQLParam("@AddedBy", objInfo.AddedBy)
};
SQLExecuteNonQueryAsync sqlh = new SQLExecuteNonQueryAsync();
return(await sqlh.ExecuteNonQueryAsync("[dbo].[usp_Wb_Mail_NL_Subscriber_Add]", Param, "@OpStatus"));
}
catch
{
throw;
}
}
public async Task <OperationStatus> DeleteSideMenu(Guid ID)
{
try
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@Id", ID)
};
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
int result = await handler.ExecuteNonQueryAsync("[dbo].[usp_DashboardLink_Delete]", param, "@Status");
if (result == 1)
{
return(new OperationStatus {
Message = "Menu item deleted successfully.", StatusCode = StatusCode.Deleted, Result = result
});
}
return(new OperationStatus {
Message = "Something went wrong while deleting menu data.", StatusCode = StatusCode.ServerError, Result = result
});
}
catch
{
throw;
}
}
internal async Task <int> AddMailByApp(MassMailAddInfo objMassMail, string username, string appName)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@MessageTitle", objMassMail.MessageTitle),
new SQLParam("@Gender", objMassMail.Gender),
new SQLParam("@ToAllGender", objMassMail.ToAllGender),
new SQLParam("@Interests", objMassMail.Interests),
new SQLParam("@Subject", objMassMail.Subject),
new SQLParam("@MessageBody", objMassMail.MessageBody),
new SQLParam("@IsInstant", objMassMail.IsInstant),
new SQLParam("@ScheduledOn", objMassMail.UTCScheduled),
new SQLParam("@TimeZoneOffset", objMassMail.TimeZoneOffset),
new SQLParam("@Username", username),
new SQLParam("@AppName", appName)
};
SQLExecuteNonQueryAsync objHandler = new SQLExecuteNonQueryAsync();
return(await objHandler.ExecuteNonQueryAsync("[dbo].[usp_Wb_MassMail_AddMail_ByApp]", Param, "@output"));
}
catch
{
throw;
}
}
public async Task <OperationStatus> DeleteRoleByID(string roleID, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@RoleID", roleID),
new SQLParam("@UserName", userName)
};
try
{
SQLExecuteNonQueryAsync sqlhandler = new SQLExecuteNonQueryAsync();
int result = await sqlhandler.ExecuteNonQueryAsync("[dbo].[usp_Roles_DeleteByID]", sQLParam, "@Status");
if (result == 1)
{
return(new OperationStatus {
Message = "Role deleted successfully.", StatusCode = StatusCode.Deleted, Result = result
});
}
return(new OperationStatus {
Message = "Something went wrong while deleting role.", StatusCode = StatusCode.ServerError, Result = result
});
}
catch
{
throw;
}
}
public async Task Add(CountryLanguage countryLanguage, string userName)
{
List <SQLParam> sQLParam = new List <SQLParam>
{
new SQLParam("@CultureCode", countryLanguage.CultureCode),
new SQLParam("@CultureName", countryLanguage.CultureName),
new SQLParam("@FallbackCulture", countryLanguage.CultureName),
new SQLParam("@FallbackCultureCode", countryLanguage.CultureCode),
new SQLParam("@CreatedBy", userName),
new SQLParam("@Country", countryLanguage.Country),
new SQLParam("@CountryCode", countryLanguage.CountryCode),
new SQLParam("@Language", countryLanguage.Language),
new SQLParam("@LanguageCode", countryLanguage.LanguageCode)
};
try
{
SQLExecuteNonQueryAsync sqlhandler = new SQLExecuteNonQueryAsync();
await sqlhandler.ExecuteNonQueryAsync("[dbo].[usp_Localization_AddLanguage]", sQLParam);
}
catch
{
throw;
}
}
public async Task DeleteUserArea(int userAreaID)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@UserAreaID", userAreaID));
SQLExecuteNonQueryAsync objSQL = new SQLExecuteNonQueryAsync();
await objSQL.ExecuteNonQueryAsync("[dbo].[usp_Asset_UserArea_Delete]", sQLParam);
}
public async Task DeleteComponent(int componentId, int siteId)
{
List <SQLParam> param = new List <SQLParam>();
param.Add(new SQLParam("@ComponentId", componentId));
param.Add(new SQLParam("@SiteId", siteId));
SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
await sql.ExecuteNonQueryAsync("usp_Webbuilder_GenericData_DeleteByComponentId", param);
}
public async void RemoveCustomer(CustomerModel objCustomer)
{
SQLExecuteNonQueryAsync Sqlh = new SQLExecuteNonQueryAsync();
List <SQLParam> param = new List <SQLParam>()
{
new SQLParam("@customerid", objCustomer.CustomerId)
};
await Sqlh.ExecuteNonQueryAsync("u_sp_CustomerRemove", param);
}
public async void UpdatePassword(LoginModel objPassword)
{
SQLExecuteNonQueryAsync SQLH = new SQLExecuteNonQueryAsync();
List <SQLParam> param = new List <SQLParam>()
{
new SQLParam("@newpassword", objPassword.NewPassword),
new SQLParam("@password", objPassword.Password)
};
await SQLH.ExecuteNonQueryAsync("u_ChangePassword", param);
}
public async Task <int> AddProject(ProjectInfo objInfo)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@ProjectName", objInfo.ProjectName));
Param.Add(new SQLParam("@ProjectCode", objInfo.ProjectCode));
string strSpName = "usp_AddProject";
SQLExecuteNonQueryAsync sqlHAsy = new SQLExecuteNonQueryAsync();
return(await sqlHAsy.ExecuteNonQueryAsync(strSpName, Param));
}
internal async Task <int> CloneTemplate(int templateID, string addedBy, int siteID, string appPath)
{
Template obj = await GetTemplateById(templateID, siteID);
string ssName = "";
if (!String.IsNullOrEmpty(obj.Screenshot))
{
try
{
//generate name for cloned screenshot
TimeSpan ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0);
string timestamp = Convert.ToInt64(ts.TotalSeconds).ToString();
ssName = String.Format("{0}.{1}.{2}.{3}.png", obj.PostId, obj.Type, timestamp, Path.GetRandomFileName());
//copy screenshot
string dirPath = String.Format("{0}\\DynamicPost\\Assets\\screenshots\\", appPath);
//string ssPath = String.Format("{0}\\{1}", dirPath, obj.Screenshot);
string[] ssPaths = obj.Screenshot.Split('/');
if (ssPaths.Length > 1)
{
string ssPath = ssPaths[ssPaths.Length - 1];
ssPath = String.Format("{0}\\{1}", dirPath, ssPath);
string clonePath = String.Format("{0}\\{1}", dirPath, ssName);
if (File.Exists(ssPath))
{
File.Copy(ssPath, clonePath);
}
ssName = "/DynamicPost/Assets/screenshots/" + ssName;
}
}
catch {
throw;
}
}
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@TemplateId", obj.TemplateId));
sQLParam.Add(new SQLParam("@TemplateKey", (new Template()).GenerateTemplateKey()));
sQLParam.Add(new SQLParam("@Screenshot", ssName));
sQLParam.Add(new SQLParam("@SiteId", obj.SiteId));
sQLParam.Add(new SQLParam("@AddedBy", addedBy));
try
{
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
await handler.ExecuteNonQueryAsync("[usp_WebBuilder_DynamicPostType_CloneTemplate]", sQLParam);
return(1);
}
catch
{
throw;
}
}
public async Task <int> AddUpdateGenericComp(ComponentDetails comp)
{
List <SQLParam> param = new List <SQLParam>();
param.Add(new SQLParam("@ComponentId", comp.ComponentId));
param.Add(new SQLParam("@ComponentName", comp.ComponentName));
param.Add(new SQLParam("@JsonData", comp.JSONData));
param.Add(new SQLParam("@Label", comp.Label));
param.Add(new SQLParam("@SiteId", comp.SiteId));
SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
return(await sql.ExecuteNonQueryAsync("usp_Webbuilder_GenericData_AddUpdate", param, "@Status"));
}
internal async Task <OperationStatus> AddUpdateMassMail(MassMailAddInfo objMassMail, string username)
{
try
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@MassMailID", objMassMail.MassMailID),
new SQLParam("@MessageMailTitle", objMassMail.MessageTitle),
new SQLParam("@IsRole", objMassMail.IsRolesUsers),
new SQLParam("@IsCustom", objMassMail.IsCustomMailList),
new SQLParam("@CustomRecipientGroup", objMassMail.CustomRecipientGroup),
new SQLParam("@IsSubscribe", objMassMail.IsSubscribeUser),
new SQLParam("@HasTarget", objMassMail.HasTargetUserInterest),
new SQLParam("@Gender", objMassMail.Gender),
new SQLParam("@ToAllGender", objMassMail.ToAllGender),
new SQLParam("@Roles", objMassMail.Roles),
new SQLParam("@Interests", objMassMail.Interests),
new SQLParam("@AdvanceFilters", objMassMail.AdvanceFilters),
new SQLParam("@AdditionalUser", objMassMail.AdditionalUser),
new SQLParam("@Subject", objMassMail.Subject),
new SQLParam("@MessageBody", objMassMail.MessageBody),
new SQLParam("@MessageEditDOM", objMassMail.MessageEditDOM),
new SQLParam("@IsInstant", objMassMail.IsInstant),
new SQLParam("@ScheduledOn", objMassMail.UTCScheduled),
new SQLParam("@TimeZoneOffset", objMassMail.TimeZoneOffset),
new SQLParam("@Username", username)
};
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
int result = await handler.ExecuteNonQueryAsync("[dbo].[usp_Wb_massMail_AddUpdateMassMail]", param, "@output");
if (result == (int)StatusCode.Created)
{
return(new OperationStatus {
IsSuccess = true, Message = "Mass mail created successfully.", StatusCode = StatusCode.Created, Result = result
});
}
else if (result == (int)StatusCode.Updated || result == 2)
{
return(new OperationStatus {
IsSuccess = true, Message = "Mass mail updated successfully.", StatusCode = StatusCode.Updated, Result = result
});
}
return(new OperationStatus {
IsSuccess = false, Message = "Something went wrong.", StatusCode = StatusCode.ServerError, Result = result
});
}
catch
{
throw;
}
}
public async Task <int> UpdateGroup(int GroupID)
{
try
{
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("GroupID", GroupID)
};
return(await handler.ExecuteNonQueryAsync("", param, "@status"));
}
catch
{
throw;
}
}
public async Task <int> SettingValueUpdate(string settingKey, string settingValue)
{
try
{
List <SQLParam> sqlParam = new List <SQLParam>();
sqlParam.Add(new SQLParam("@SettingKey", settingKey));
sqlParam.Add(new SQLParam("@SettingValue", settingValue));
SQLExecuteNonQueryAsync sagesql = new SQLExecuteNonQueryAsync();
return(await sagesql.ExecuteNonQueryAsync("[usp_Webbuilder_Settings_UpdateValue]", sqlParam));
}
catch
{
throw;
}
}
public async void UpdateLocalizationStatus(string Localization)
{
try
{
List <SQLParam> param = new List <SQLParam>
{
new SQLParam("@Localization", Localization)
};
SQLExecuteNonQueryAsync sql = new SQLExecuteNonQueryAsync();
await sql.ExecuteNonQueryAsync("[dbo].[usp_Localization_SetLocalization]", param);
}
catch
{
throw;
}
}
public async Task DeleteImportUserByID(int subscriberID)
{
try
{
List <SQLParam> Param = new List <SQLParam>
{
new SQLParam("@SubscriberID", subscriberID)
};
SQLExecuteNonQueryAsync sqlh = new SQLExecuteNonQueryAsync();
await sqlh.ExecuteNonQueryAsync("usp_Wb_Mail_NL_Subscriber_DelImportedByID", Param);
}
catch
{
throw;
}
}
internal async Task UpdatePostDataOrder(string order)
{
List <SQLParam> sQLParam = new List <SQLParam>();
sQLParam.Add(new SQLParam("@Order", order));
SQLExecuteNonQueryAsync handler = new SQLExecuteNonQueryAsync();
try
{
await handler.ExecuteNonQueryAsync("[usp_WebBuilder_DynamicPostData_UpdatePostDataOrder]", sQLParam);
}
catch
{
throw;
}
}
