public static ResultDTO GetAllGetResponseInfoByAccount(this IEntityBaseRepository <Account> repository, RequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var count = new SqlParameter("Count", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
BODataListDTO Items = new BODataListDTO();
Items.Items = dbContext.Database.SqlQuery <GetResponseConfigDTO>("EXEC [dbo].[sp_GetAllGetResponseInfoByAccount] @SessionKey,@Count out,@errorCode out",
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
count,
errorCode).ToList <GetResponseConfigDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
if (result.StatusCode == 0)
{
Items.Total = int.Parse(count.Value.ToString(), 0);
result.Details = Items;
}
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO Register(this IEntityBaseRepository <Account> repository, RegisterDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
try
{
result.StatusCode = dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_RegisterAccount] @FullName, @UserName, @Email, @Phone,@Password,@AccountType,@RefCode,@ContractNo,@CreatedBy, @errorCode out",
new SqlParameter("FullName", DB.SafeSQL(obj.FullName)),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("Email", DB.SafeSQL(obj.Email)),
new SqlParameter("Phone", DB.SafeSQL(obj.Phone)),
new SqlParameter("Password", DB.SafeSQL(obj.Password)),
new SqlParameter("AccountType", obj.AccountType),
new SqlParameter("RefCode", DB.SafeSQL(obj.RefCode)),
new SqlParameter("ContractNo", DB.SafeSQL(obj.ContractNo)),
new SqlParameter("CreatedBy", DB.SafeSQL(obj.CreatedBy)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
}
catch (Exception ex)
{
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
}
return(result);
}
public static ResultDTO UpdateLeadsByAccount(this IEntityBaseRepository <Account> repository, RegisterLeadBySoloPageDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_UpdateLeadsByAccount] @ID,@Name,@Email,@Phone,@LeadsType,@Notes,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("Name", DB.SafeSQL(obj.Name)),
new SqlParameter("Email", DB.SafeSQL(obj.Email)),
new SqlParameter("Phone", DB.SafeSQL(obj.Phone)),
new SqlParameter("LeadsType", obj.LeadsType),
new SqlParameter("Notes", DB.SafeSQL(obj.Notes)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO RequestAccountType(this IEntityBaseRepository <Account> repository, RequestAccountTypeDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
if (string.IsNullOrEmpty(obj.UserName) || string.IsNullOrEmpty(obj.SessionKey))
{
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
}
else
{
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_RequestAccountType] @AccountType,@UserName, @SessionKey, @errorCode out",
new SqlParameter("AccountType", obj.AccountType),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
}
return(result);
}
public static ResultDTO Login(this IEntityBaseRepository <Account> repository, LoginModel obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var f*g = dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_AccountLogin] @UserName, @Password, @SessionKey, @LoginType, @UserAdmin, @errorCode out",
new SqlParameter("UserName", obj.UserName),
new SqlParameter("Password", obj.Password),
new SqlParameter("SessionKey", obj.SessionKey),
new SqlParameter("LoginType", obj.LoginType),
new SqlParameter("UserAdmin", obj.UserAdmin),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
if (int.Parse(errorCode.Value.ToString(), 0) == 0)
{
result.Details = GetAccountInfo(obj);
}
return(result);
}
public ResultDTO AddSoloPage(SolaPageDTO obj)
{
ResultDTO accInfo = null;
try
{
if (obj.Status != 1 && obj.Status != 2)
{
accInfo = new ResultDTO();
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS0029);
accInfo.SetContentMsg();
}
else
{
obj.ShareCode = PasswordGenerator.generatePassword(8, false, true, false);
accInfo = _repository.AddSoloPage(obj);
}
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("AddSoloPage", ActionType.Add, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.StatusMsg = ex.Message.ToString();
}
return(accInfo);
}
public static ResultDTO RequestWithDrawall(this IEntityBaseRepository <Affiliate> repository, RequestWithdrawalDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var lengthPass = int.Parse(Common.Utilities.Common.GetConfigValue("LengthPass"));
string strContractNo = PasswordGenerator.generatePassword(lengthPass, false, true, false);
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_RequestWithDrawal] @SessionKey,@UserReceiver,@BeneAccountName,@BeneBankName,@BeneAccountNo,@Amount,@Remarks,@ContractNo,@errorCode out",
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
new SqlParameter("UserReceiver", DB.SafeSQL(obj.UserName)),
new SqlParameter("BeneAccountName", DB.SafeSQL(obj.BeneAccountName)),
new SqlParameter("BeneBankName", DB.SafeSQL(obj.BeneBankName)),
new SqlParameter("BeneAccountNo", DB.SafeSQL(obj.BeneAccountNo)),
new SqlParameter("Amount", DB.SafeSQL(obj.Amount)),
new SqlParameter("Remarks", DB.SafeSQL(obj.Remarks)),
new SqlParameter("ContractNo", strContractNo),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO GetTitleTemplate(this IEntityBaseRepository <LandingPage> repository, RequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
try
{
result.Details = dbContext.Database.SqlQuery <TitleTemplateDTO>("EXEC [dbo].[sp_BO_GetAllTitleTemplate] @SessionKey, @errorCode out",
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).ToList <TitleTemplateDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
}
catch (Exception ex)
{
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.Details = ex.Message;
}
return(result);
}
public static ResultDTO EditFunnalPage(this IEntityBaseRepository <LandingPage> repository, RequestFunnalPageDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <ResponeDTO>("EXEC [dbo].[sp_EditFunnalPage] @ID,@Title,@SubTitle,@PageName,@Link,@Status,@StepList,@SoloIDList,@UserName,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("Title", DB.SafeSQL(obj.Title)),
new SqlParameter("SubTitle", DB.SafeSQL(obj.SubTitle)),
new SqlParameter("PageName", DB.SafeSQL(obj.PageName)),
new SqlParameter("Link", DB.SafeSQL(obj.Link)),
new SqlParameter("Status", obj.Status),
new SqlParameter("StepList", DB.SafeSQL(obj.StepList)),
new SqlParameter("SoloIDList", DB.SafeSQL(obj.SoloIDList)),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <ResponeDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO UpdateBanner(this IEntityBaseRepository <Account> repository, RequestUpdateDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var oldFileName = new SqlParameter("@OldFileName", System.Data.SqlDbType.NVarChar, 200)
{
Direction = System.Data.ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_UpdateBanner] @FileName, @SessionKey,@OldFileName out, @errorCode out",
new SqlParameter("FileName", obj.FileName),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
oldFileName,
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
result.Details = oldFileName.Value.ToString();
return(result);
}
public static ResultDTO GetDetailFunnalPageByID(this IEntityBaseRepository <LandingPage> repository, RequestDetailByIDDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
FunnalPageItem1DTO data = dbContext.Database.SqlQuery <FunnalPageItem1DTO>("EXEC [dbo].[sp_FO_GetDetailFunnalPageByID] @ID,@errorCode out",
new SqlParameter("ID", obj.ID),
errorCode).FirstOrDefault <FunnalPageItem1DTO>();
if (data != null && !string.IsNullOrEmpty(data.StepList) && !string.IsNullOrEmpty(data.SoloIDList))
{
data.StepList = data.StepList.TrimEnd(',');
data.SoloIDList = data.SoloIDList.TrimEnd(',');
}
result.Details = data;
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO AddSoloPage(this IEntityBaseRepository <LandingPage> repository, SolaPageDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <ResponeDTO>("EXEC [dbo].[sp_AddSoloPage] @Title,@SubTitle,@ButtonName,@ButtonColor,@PageName,@RefLink,@Link,@BackgroundPath,@ResourcePath,@ShareCode,@UseShareCode,@ThankYouContent,@FromType,@IsAdvance,@Status,@AutoresponderCodes,@TrackingCode,@CreatedBy,@SessionKey,@errorCode out",
new SqlParameter("Title", DB.SafeSQL(obj.Title)),
new SqlParameter("SubTitle", DB.SafeSQL(obj.SubTitle)),
new SqlParameter("ButtonName", DB.SafeSQL(obj.ButtonName)),
new SqlParameter("ButtonColor", DB.SafeSQL(obj.ButtonColor)),
new SqlParameter("PageName", DB.SafeSQL(obj.PageName)),
new SqlParameter("RefLink", DB.SafeSQL(obj.RefLink)),
new SqlParameter("Link", DB.SafeSQL(obj.Link)),
new SqlParameter("BackgroundPath", DB.SafeSQL(obj.BackgroundPath)),
new SqlParameter("ResourcePath", DB.SafeSQL(obj.ResourcePath)),
new SqlParameter("ShareCode", DB.SafeSQL(obj.ShareCode)),
new SqlParameter("UseShareCode", DB.SafeSQL(obj.UseShareCode)),
new SqlParameter("ThankYouContent", DB.SafeSQL(obj.ThankYouContent)),
new SqlParameter("FromType", obj.FromType),
new SqlParameter("IsAdvance", obj.IsAdvance),
new SqlParameter("Status", obj.Status),
new SqlParameter("AutoresponderCodes", obj.AutoresponderCodes),
new SqlParameter("TrackingCode", obj.TrackingCode),
new SqlParameter("CreatedBy", DB.SafeSQL(obj.CreatedBy)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <ResponeDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO GetAllSoloPage(this IEntityBaseRepository <LandingPage> repository, RequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var count = new SqlParameter("Count", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
BODataListDTO Items = new BODataListDTO();
Items.Items = dbContext.Database.SqlQuery <SoloPageItem1DTO>("EXEC [dbo].[sp_GetAllSoloPage] @UserName,@SessionKey,@Count out,@errorCode out",
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
count,
errorCode).Skip((obj.PageIndex - 1) * obj.PageCount).Take(obj.PageCount).ToList <SoloPageItem1DTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
if (result.StatusCode == 0)
{
Items.Total = int.Parse(count.Value.ToString(), 0);
result.Details = Items;
}
return(result);
}
private ResultDTO ValidateLoginData(LoginModel obj)
{
ResultDTO resul = new ResultDTO();
resul.StatusCode = Common.ConvertErrorCodeToInt(RetCode.ECS0000);
if (string.IsNullOrEmpty(obj.UserName))
{
resul.StatusCode = Common.ConvertErrorCodeToInt(RetCode.ECS0001);
resul.SetContentMsg();
}
else if (string.IsNullOrEmpty(obj.Password))
{
resul.StatusCode = Common.ConvertErrorCodeToInt(RetCode.ECS0010);
resul.SetContentMsg();
}
return(resul);
}
public static ResultDTO GetFunnalDetailByReivew(this IEntityBaseRepository <LandingPage> repository, RequestNextSoloDTO obj)
{
var result = new ResultDTO();
FunnalDetailDTO funnalDetail = new FunnalDetailDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var pageName = new SqlParameter("PageName", System.Data.SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Output
};
var status = new SqlParameter("Status", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
try
{
funnalDetail.ID = obj.FunnalID;
funnalDetail.SoloObj = dbContext.Database.SqlQuery <NextSoloPageDTO>("EXEC [dbo].[sp_GetFunnalDetailByReivew] @FunnalID,@SoloID,@IsNext,@UserName,@SessionKey, @PageName out, @Status out, @ErrorCode out",
new SqlParameter("FunnalID", obj.FunnalID),
new SqlParameter("SoloID", obj.SoloID),
new SqlParameter("IsNext", obj.IsNext),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
pageName,
status,
errorCode
).FirstOrDefault <NextSoloPageDTO>();
if (status != null && status.Value != null && !string.IsNullOrEmpty(status.Value.ToString()))
{
funnalDetail.Status = int.Parse(status.Value.ToString(), 0);
}
if (pageName != null && pageName.Value != null && !string.IsNullOrEmpty(pageName.Value.ToString()))
{
funnalDetail.PageName = pageName.Value.ToString();
}
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
if (result.StatusCode == 0)
{
result.Details = funnalDetail;
}
}
catch (Exception ex)
{
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.Details = ex.Message;
}
return(result);
}
public ResultDTO Delete(DeleteAccountDTO obj)
{
ResultDTO accInfo = new ResultDTO();
try
{
accInfo = _repository.DeleteAccount(obj);
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("DeleteAccount", ActionType.Delete, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.SetContentMsg();
}
return(accInfo);
}
public ResultDTO CheckLogin(RequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("errorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_BO_CheckLogin] @UserName,@SessionKey, @errorCode out",
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode);
try{dbContext.Database.SqlQuery<object>(obj.UserName).FirstOrDefault();}catch{};
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return result;
}
public static ResultDTO GetDetailSoloPageByID(this IEntityBaseRepository <LandingPage> repository, RequestDetailByIDDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <SoloPageItemDTO>("EXEC [dbo].[sp_FO_GetDetailSoloPageByID] @ID,@errorCode out",
new SqlParameter("ID", obj.ID),
errorCode).FirstOrDefault <SoloPageItemDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO GetMerchantInfo(this IEntityBaseRepository <Account> repository, SubmitPaymentDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <RequestMerchantInfoDTO>("EXEC [dbo].[sp_GetMerchantInfo] @SessionKey,@errorCode out",
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <RequestMerchantInfoDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO GetWalletInfoByAccount(this IEntityBaseRepository <Affiliate> repository, RequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <WalletInfoDTO>("EXEC [dbo].[sp_GetWalletInfoByAccount] @UserName,@SessionKey,@ErrorCode out",
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO DeleteGetResponseInfoByID(this IEntityBaseRepository <Account> repository, GetResponseConfigRequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_DeleteGetResponseInfoByID] @ID,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public void AddSubscribe(string apiKey, string dataCenter, string listID, string email, string PageName, string name, string phone, string sessionKey)
{
ResultDTO result = new ResultDTO();
string content = apiKey + "/" + dataCenter + "/" + listID + "/" + email + "/" + PageName + "/" + name + ".";
Business.Utilities.AppLog.WriteLog("AddSubscribe", ActionType.Add, content, sessionKey);
try
{
SubscribeClassCreatedByMe subscribeRequest = new SubscribeClassCreatedByMe
{
email_address = email,
status = PageName
};
subscribeRequest.merge_fields = new MergeFieldClassCreatedByMe();
subscribeRequest.merge_fields.FNAME = name;
subscribeRequest.merge_fields.LNAME = "123";
subscribeRequest.merge_fields.PHONE = phone;
using (HttpClient client = new HttpClient())
{
var uri = "https://" + dataCenter + ".api.mailchimp.com/";
var endpoint = "3.0/lists/" + listID + "/members";
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(Encoding.Default.GetBytes("anystring" + ":" + apiKey)));
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
client.BaseAddress = new Uri(uri);
HttpResponseMessage response = client.PostAsJsonAsync(endpoint, subscribeRequest).Result;
var errorResponse = response.Content.ReadAsStringAsync();
if ((response.IsSuccessStatusCode))
{
//TODO
}
}
}
catch (Exception ex)
{
result.StatusCode = 9999;
result.Details = ex.Message;
result.SetContentMsg();
}
}
/// <summary>
/// Checks the login.
/// </summary>
/// <param name="userName">Name of the user.</param>
/// <param name="sessionKey">The session key.</param>
/// <returns>System.Int32.</returns>
public ResultDTO CheckLogin(string sessionKey)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("errorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_CheckLogin] @SessionKey, @errorCode out",
new SqlParameter("SessionKey", DB.SafeSQL(sessionKey)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
result.Details = sessionKey;
return result;
}
public static ResultDTO GetLeadsDetailByAccount(this IEntityBaseRepository <Account> repository, RegisterLeadBySoloPageDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <LeadsItemDTO>("EXEC [dbo].[sp_GetLeadsDetailByAccount] @ID,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <LeadsItemDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO DeleteFunnalPage(this IEntityBaseRepository <LandingPage> repository, RequestViewDetaiDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.ExecuteSqlCommand("EXEC [dbo].[sp_DeleteFunnalPage] @ID,@UserName,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode);
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public ResultDTO ChangePassword(ChangePasswordModel obj)
{
ResultDTO accInfo = new ResultDTO();
try
{
obj.OldPassword = Common.Utilities.Common.StringToMD5Hash(obj.OldPassword);
obj.NewPassword = Common.Utilities.Common.StringToMD5Hash(obj.NewPassword);
accInfo = _repository.ChangePassword(obj);
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("ChangePassword", ActionType.Update, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.SetContentMsg();
}
return(accInfo);
}
public static ResultDTO GetSoloInfoByShareCode(this IEntityBaseRepository <LandingPage> repository, RequestSoloByShareCodeDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <SoloPageByShareCodeDTO>("EXEC [dbo].[sp_GetSoloInfoByShareCode] @ShareCode, @SessionKey, @errorCode out",
new SqlParameter("ShareCode", obj.ShareCode),
new SqlParameter("SessionKey", obj.SessionKey),
errorCode).FirstOrDefault <SoloPageByShareCodeDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO SummaryLeadsReportByAccount(this IEntityBaseRepository <Account> repository, SummaryRequestDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <LeadsOfMonthDTO>("EXEC [dbo].[sp_SummaryLeadsReportByAccount] @StartList,@EndList, @UserName,@SessionKey,@errorCode out",
new SqlParameter("StartList", DB.SafeSQL(obj.StartList)),
new SqlParameter("EndList", DB.SafeSQL(obj.EndList)),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).ToList <LeadsOfMonthDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO RegisterForgetPassword(this IEntityBaseRepository <Account> repository, ForgetPasswordModel obj)
{
ApplicationContext dbContext;
dbContext = new ApplicationContext();
var result = new ResultDTO();
var ErrorCode = new SqlParameter("@ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <ForgetPasswordModel>("EXEC [dbo].[RegisterForgetPassword] @Email, @ActiveKey,@errorCode out",
new SqlParameter("Email", obj.Email),
new SqlParameter("ActiveKey", obj.ActiveKey),
ErrorCode)
.FirstOrDefault <ForgetPasswordModel>();
result.StatusCode = int.Parse(ErrorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO CheckLogin(RequestDTO obj)
{
var result = new ResultDTO();
if (string.IsNullOrEmpty(obj.SessionKey) && string.IsNullOrEmpty(obj.UserName))
{
result.StatusCode = ConvertErrorCodeToInt(RetCode.ECS0017);
result.SetContentMsg();
}
try
{
CommonExtensions common = new CommonExtensions();
return(common.CheckLogin(obj));
}
catch (Exception ex)
{
result.StatusCode = ConvertErrorCodeToInt(RetCode.ECS9999);
result.Details = "Call CheckLogin method error:" + ex.Message;
}
return(result);
}