/// <summary>
/// 임시패스워드 발급
/// </summary>
/// <param name="email"></param>
/// <param name="newEncPassword"></param>
/// <returns></returns>
public int UpdateMemberTempPassword(string email, string newEncPassword)
{
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50);
param.Add("p_NewPassword", newEncPassword, DbType.String, ParameterDirection.Input, 200);
return(connection.Execute("SP_PartnerAdmin_Update_Member_TempPassword", param, commandType: CommandType.StoredProcedure));
}
}
}
public List <T> GetetPartnerAdminMenuList <T>()
{
List <T> list = null;
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
list = connection.Query <T>("SP_PartnerAdmin_Select_PartnerAdminMenu", commandType: CommandType.StoredProcedure).AsList();
}
}
return(list);
}
/// <summary>
/// 멤버 인증 완료
/// </summary>
/// <param name="email"></param>
/// <param name="authCode"></param>
public int UpdateAuthMember(string email, string authCode)
{
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50);
param.Add("p_AuthCode", authCode, DbType.String, ParameterDirection.Input, 200);
return(connection.Execute("SP_PartnerAdmin_Update_AuthMember", param, commandType: CommandType.StoredProcedure));
}
}
}
/// <summary>
/// 회원가입
/// </summary>
/// <param name="email"></param>
/// <param name="encPassword"></param>
/// <param name="name"></param>
public void InsertMemberinfo(string email, string encPassword, string name)
{
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50);
param.Add("p_Password", encPassword, DbType.String, ParameterDirection.Input, 200);
param.Add("p_Name", name, DbType.String, ParameterDirection.Input, 20);
connection.Execute("SP_PartnerAdmin_Insert_Member", param, commandType: CommandType.StoredProcedure);
}
}
}
public virtual List <T> SelectProductnfo <T>(string partnerId)
{
List <T> list = null;
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_partnerId", partnerId, DbType.String, ParameterDirection.Input, 50);
list = connection.Query <T>("SPP_Select_ProductInfo", param, commandType: CommandType.StoredProcedure).AsList();
return(list);
}
}
}
/// <summary>
/// 멤버 이메일 인증 대상 리스트
/// </summary>
/// <param name="email"></param>
public List <T> SelectAuthMember <T>(string email)
{
List <T> list = null;
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_Email", email, DbType.String, ParameterDirection.Input, 50);
list = connection.Query <T>("SP_PartnerAdmin_Select_AuthMember_byEmail", param, commandType: CommandType.StoredProcedure).AsList();
}
}
return(list);
}
public List <T> GetOrderChartList <T>(string domCd, int beforeDay)
{
List <T> list = null;
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_domCd", domCd, DbType.String, ParameterDirection.Input, 2);
param.Add("p_day", beforeDay, DbType.Int32, ParameterDirection.Input, 4);
list = connection.Query <T>("SP_PartnerAdmin_Select_ChartOrderByOrderM", param, commandType: CommandType.StoredProcedure).AsList();
}
}
return(list);
}
public virtual List <T> SelectProductTarget <T>(string partnerId, string goodId, int currentPageNo, int limitPageNo)
{
List <T> list = null;
using (CommonSSHClientConnectBiz sshClientConnect = new CommonSSHClientConnectBiz())
{
using (var connection = new MySqlConnection(MysqlConnection))
{
connection.Open();
var param = new DynamicParameters();
param.Add("p_partnerId", partnerId, DbType.String, ParameterDirection.Input, 50);
param.Add("p_goodId", goodId, DbType.String, ParameterDirection.Input, 50);
param.Add("p_currentPageNo", currentPageNo, DbType.Int32, ParameterDirection.Input, 4);
param.Add("p_limitPageNo", limitPageNo, DbType.Int32, ParameterDirection.Input, 4);
list = connection.Query <T>("SP_PartnerAdmin_Select_ProductTarget", param, commandType: CommandType.StoredProcedure).AsList();
return(list);
}
}
}