/// <summary>
/// 회원 로그인 로그 목록(페이징 아님)
/// </summary>
/// <param name="permissionCode"></param>
/// <param name="memId"></param>
/// <param name="beforeMonth">최근 조회 월 숫자형</param>
/// <param name="outTotalRowCount"></param>
/// <returns></returns>
public List<SPMemberLoginLogList_Result> MemberLoginLogList(string permissionCode, string memId, int beforeMonth)
{
List<SPMemberLoginLogList_Result> lst = new List<SPMemberLoginLogList_Result>();
using (MemberEntities EfContext = new MemberEntities())
{
lst = EfContext.SPMemberLoginLogList(permissionCode, memId, beforeMonth).ToList();
}
return lst;
}
/// <summary>
/// 회원 포인트 적립/사용 내역 목록
/// </summary>
/// <param name="param"></param>
/// <param name="outTotalRowCount"></param>
/// <returns></returns>
public List<SPMemberPointHistoryList_Result> MemberPointHistoryList(CommonModel param, out int outTotalRowCount)
{
if (!param.Page.HasValue || param.Page == 0)
{
param.Page = 1;
}
if (!param.Pagesize.HasValue || param.Pagesize == 0)
{
param.Pagesize = 10;
}
ObjectParameter totalRowCount = new ObjectParameter("totalRowCount", typeof(int));
List<SPMemberPointHistoryList_Result> lst = new List<SPMemberPointHistoryList_Result>();
using (MemberEntities EfContext = new MemberEntities())
{
lst = EfContext.SPMemberPointHistoryList(param.PermissionCode, param.Page, param.Pagesize, param.SearchString, totalRowCount).ToList();
}
outTotalRowCount = (int)totalRowCount.Value;
return lst;
}
/// <summary>
/// 회원 로그인
/// </summary>
/// <param name="permissionCode">접근권한코드</param>
/// <param name="memId">아이디</param>
/// <param name="memPassword">비밀번호</param>
/// <param name="regIP">접근IP</param>
/// <param name="platformCode">접근환경</param>
/// <param name="loginAgent">브라우저Agent</param>
/// <returns></returns>
public SPMemberLogin_Result MemberLogin(string permissionCode, string memId, string memPassword, string regIP, string platformCode, string loginAgent)
{
SPMemberLogin_Result result = new SPMemberLogin_Result();
using (MemberEntities EfContext = new MemberEntities())
{
result = EfContext.SPMemberLogin(permissionCode, memId, memPassword, regIP, platformCode, loginAgent).FirstOrDefault();
}
return result;
}
/// <summary>
/// 회원정보 삭제
/// </summary>
/// <param name="permissionCode"></param>
/// <param name="param"></param>
/// <param name="memberDTO"></param>
/// <param name="outReturnValue"></param>
public void MemberDelete(string permissionCode, CommonModel param, MemberDTO dto, out int outReturnValue)
{
ObjectParameter returnValue = new ObjectParameter("returnValue", typeof(int));
using (MemberEntities EfContext = new MemberEntities())
{
EfContext.SPMemberDelete(permissionCode, dto.memId, dto.regIP, returnValue);
}
outReturnValue = (int)returnValue.Value;
}
/// <summary>
/// 회원정보 수정
/// </summary>
/// <param name="permissionCode"></param>
/// <param name="param"></param>
/// <param name="memberDTO"></param>
/// <returns></returns>
public void MemberUpdateInfo(string permissionCode, CommonModel param, MemberDTO dto, out int outReturnValue)
{
ObjectParameter returnValue = new ObjectParameter("returnValue", typeof(int));
using (MemberEntities EfContext = new MemberEntities())
{
EfContext.SPMemberUpdateInfo(permissionCode, dto.memId, dto.memName, dto.memMobile
, dto.memSite, dto.memSMSListenYN, dto.memDMListenYN
, ""//dto.memPicturePath.ToString()
, dto.memGradeCode, dto.regIP, dto.memStatusCode, returnValue);
}
outReturnValue = (int)returnValue.Value;
}
/// <summary>
/// 회원 정보 조회
/// </summary>
/// <param name="memId"></param>
/// <param name="param"></param>
/// <returns></returns>
public SPMemberSelect_Result MemberView(string memId, string permissionCode, CommonModel param)
{
SPMemberSelect_Result result = new SPMemberSelect_Result();
using (MemberEntities EfContext = new MemberEntities())
{
result = EfContext.SPMemberSelect(permissionCode, memId).FirstOrDefault();
}
return result;
}
