public ActionResult PointHistory(CommonModel SearchParam) { try { int totalRowCnt; //개시물 총갯수 //검색처리 if (SearchParam.SearchKeyword != "") { SearchParam.SearchString = string.Format(" AND memId = '{0}' ", SearchParam.SearchKeyword); } MemberPointHistoryList M = new MemberPointHistoryList { CommonParam = SearchParam , PointHistoryList = _MemberService.MemberPointHistoryList(SearchParam, out totalRowCnt) }; ViewBag.totalRowCount = totalRowCnt; return View(M); } catch (System.Exception ex) { CustomLog4Net customLog = new CustomLog4Net(); customLog.logger.Error(this.ControllerContext.Controller, ex); throw; } }
public ActionResult Index(CommonModel SearchParam) { try { int totalRowCnt; //개시물 총갯수 if (TempData["commonModelParam"] != null) { SearchParam = (CommonModel)TempData["commonModelParam"]; } //검색처리 if (SearchParam.SearchKeyword != "") { if (SearchParam.SearchField == "") { //하...여기를 어찌해야하느냐... //일단 필드가 추가되면 빌드를 다시해야하는 어처구니 없는 상황으로 내비둠..... SearchParam.SearchString = string.Format(" AND ( memId Like '%{0}%' OR memName Like '%{0}%' )", SearchParam.SearchKeyword); } else { SearchParam.SearchString = string.Format(" AND {0} Like '%{1}%'", SearchParam.SearchField, SearchParam.SearchKeyword); } } MemberList M = new MemberList { PermissionCode = SearchParam.PermissionCode , CommonParam = SearchParam , ListInfo = _MemberService.MemberList(SearchParam, out totalRowCnt) }; ViewBag.totalRowCount = totalRowCnt; return View(M); } catch (System.Exception ex) { CustomLog4Net customLog = new CustomLog4Net(); customLog.logger.Error(this.ControllerContext.Controller, ex); throw; } }
/// <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; }
public ActionResult ViewInfo(string memId, CommonModel param) { //파라미터가 없는 접근을 차단 if (!NoParamValueCheck(memId)) { return RedirectToAction("NoParameterValue", "Home"); } if (TempData["commonModelParam"] != null) { param = (CommonModel)TempData["commonModelParam"]; } MemberView M = new MemberView { CommonParam = param , MemberInfo = _MemberService.MemberView(memId, MemberInfo.GetMemberGradeCode(), param) }; //의도적인 예외처리 if (M.MemberInfo == null) { CustomLog4Net customLog = new CustomLog4Net(); customLog.ErrorToLog(this.ControllerContext); return RedirectToAction("WrongParameterValue", "Home"); } return View(M); }
public ActionResult Delete(string permissionCode, CommonModel param, MemberDTO dto) { //파라미터가 없는 접근을 차단 if (!NoParamValueCheck(permissionCode) || !NoParamValueCheck(dto.memId)) { return RedirectToAction("NoParameterValue", "Home"); } param.SearchField = Request.Params["SearchField"]; param.SearchKeyword = Request.Params["SearchKeyword"]; int result; dto.regIP = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; _MemberService.MemberDelete(permissionCode, param, dto, out result); TempData["resultNum"] = result; TempData["commonModelParam"] = param; return RedirectToAction("", new { Page = Request.Params["Page"] }); }
public ActionResult EditPasswordProc(string permissionCode, CommonModel param, MemberDTO dto) { //파라미터가 없는 접근을 차단 if (!NoParamValueCheck(permissionCode) || !NoParamValueCheck(dto.memId)) { return RedirectToAction("NoParameterValue", "Home"); } //넘어온 인자값 확인 if (dto.memPassword != Request.Params["memPassword2"]) { return Content("<script type='text/javascript'>alert('비밀번호/비밀번호 확인 이 일치하지 않습니다.');history.go(-1);</script>"); } param.SearchField = Request.Params["SearchField"]; param.SearchKeyword = Request.Params["SearchKeyword"]; int result; dto.regIP = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; //비밀번호 암호화 string noneHashPwd = dto.memPassword; AES256Cipher objEnc = new AES256Cipher(); string M_PWD_MD5_HASH = objEnc.MD5Hash(noneHashPwd); //MD5: PW -> M_PWD_MD5_HASH string M_PWD_SHA256_HASH = objEnc.SHA256Hash(M_PWD_MD5_HASH); //MD5: M_PWD_MD5_HASH -> M_PWD_SHA256_HASH dto.memPassword = M_PWD_SHA256_HASH; _MemberService.MemberUpdatePassword(permissionCode, param, dto, out result); //http://blog.i6020345.com/life-cycle-of-tempdata-in-asp-net-mvc/ TempData["resultNum"] = result; TempData["commonModelParam"] = param; return RedirectToAction("ViewInfo", new { memId = dto.memId, Page = Request.Params["Page"] }); }
public ActionResult EditProc(string permissionCode, CommonModel param, MemberDTO dto) { //파라미터가 없는 접근을 차단 if (!NoParamValueCheck(permissionCode) || !NoParamValueCheck(dto.memId)) { return RedirectToAction("NoParameterValue", "Home"); } param.SearchField = Request.Params["SearchField"]; param.SearchKeyword = Request.Params["SearchKeyword"]; int result; dto.regIP = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; _MemberService.MemberUpdateInfo(permissionCode, param, dto, out result); //http://blog.i6020345.com/life-cycle-of-tempdata-in-asp-net-mvc/ TempData["resultNum"] = result; TempData["commonModelParam"] = param; return RedirectToAction("ViewInfo", new { memId = dto.memId, Page = Request.Params["Page"] }); //return ViewInfo(dto.memId, param); //return RedirectToAction(c => c.ViewInfo) }
/// <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; }
public void MemberInsert(string permissionCode, CommonModel param, MemberDTO dto, out int outReturnValue) { throw new NotImplementedException(); }
/// <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; }