/// <summary>
/// 사용자정보 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public RTN_SAVE_DATA PasswordChangeSave(T_MEMBER Param)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
using (TransactionScope tran = new TransactionScope())
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "PasswordChangeSave"
, Param.USER_ID.ToString("")
, Param.PASSWORD.ToString("")
);
db.ExecuteCommand(sql);
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
/// <summary>
/// 사용자정보 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public RTN_SAVE_DATA ReqPasswordChange(T_MEMBER Param)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
using (TransactionScope tran = new TransactionScope())
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "ReqPasswordChange"
, Param.USER_ID.ToString("-1")
, Param.PASSWORD_CHANGE_URL.ToString("")
);
rtn.DATA = db.ExecuteQuery <DateTime>(sql).First().ToString("yyyy-MM-dd HH:mm:ss");
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
public ActionResult MemberReg(int?id, int?storeCode = 3)
{
EMPLOYEE_INFO Cond = new EMPLOYEE_INFO {
MEMBER_CODE = id
};
T_MEMBER member = new T_MEMBER();
if (id != null && id > 0)
{
Cond = Service.employeeService.GetEmployeeList(new EMPLOYEE_COND {
MEMBER_CODE = Cond.MEMBER_CODE
}).FirstOrDefault();
member = new AccountService().GetMemberList(new T_MEMBER_COND {
MEMBER_CODE = Cond.MEMBER_CODE
}).First();
}
if (Cond.STORE_CODE == null)
{
Cond.STORE_CODE = storeCode;
}
T_STORE store = new ALT.BizService.BasicService().GetStoreList(new T_STORE_COND {
STORE_CODE = Cond.STORE_CODE
}).First();
ViewBag.member = member;
ViewBag.store = store;
return(View());
}
public string SaveMember(T_MEMBER Param)
{
string msg = string.Empty;
try
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Homepage\\Account.xml", "MemberSave"
, Param.MEMBER_CODE
, Param.USER_TYPE.ToString("2")
, Param.USER_ID
, Param.PASSWORD
, Param.USER_NAME
, Param.EMAIL
, Param.PHONE
, Param.MOBILE
, Param.ADDRESS1
, Param.ADDRESS2
, Param.ZIP_CODE
, Param.REMARK
, Param.HIDE == true ? "1" : "0"
, "0" /*Admin*/
);
db.ExecuteCommand(sql);
}
catch (Exception ex) {
msg = ex.Message;
}
return(msg);
}
public RTN_SAVE_DATA MemberModify(T_MEMBER Param, T_STORE Param2)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
using (TransactionScope tran = new TransactionScope())
{
if (Param.SHARE_AUTH_NUMBER.ToString("").Length != 2)
{
Param.SHARE_AUTH_NUMBER = "00";
}
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER.xml", "MemberSave"
, Param.MEMBER_CODE.ToString("-1")
, Param.USER_TYPE.ToString("5")
, Param.USER_ID.ToString("")
, Param.PASSWORD.ToString("")
, Param.USER_NAME.ToString("")
, Param.EMAIL.ToString("")
, Param.PHONE.ToString("")
, Param.MOBILE.ToString("")
, Param.ADDRESS1.ToString("")
, Param.ADDRESS2.ToString("")
, Param.ZIP_CODE.ToString("")
, Param.BIRTH.ToString("")
, Param.GENDER.ToString("1")
, Param.REMARK.ToString("")
, Param.PASSWORD_CHANGE_URL.ToString("")
, Param.SHARE_AUTH_NUMBER.ToString("")
, Convert.ToDateTime(Param.PASSWORD_AUTH_TIME.ToString("1901-01-01")).ToString("yyyy-MM-dd HH:mm:ss.fff")
, Param.HIDE == true ? "1" : "0"
, Param.INSERT_CODE.ToString() /*Admin*/
);
var rtn2 = db.ExecuteQuery <int>(sql);
rtn.DATA = Convert.ToString(rtn2.First());
sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER_EMPLOYEE.xml", "MemberModifySave"
, Param2.COMPANY_CODE.ToString("")
, Param2.STORE_CODE.ToString("")
, Param2.COMPANY_TYPE2.ToString("7")
, Param2.BUSI_REG_NUMBER.ToString("")
, Param.INSERT_CODE.ToString()
);
db.ExecuteCommand(sql);
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
public ActionResult DeleteConfirmed(int id)
{
T_MEMBER t_member = db.T_MEMBER.Single(t => t.ID == id);
db.T_MEMBER.DeleteObject(t_member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult MemberModifySave(T_MEMBER Param, T_STORE Param2)
{
if (Param2 == null || Param2.STORE_CODE == null)
{
Param2 = new T_STORE {
COMPANY_TYPE2 = SessionHelper.LoginInfo.STORE.COMPANY_TYPE2
, BUSI_REG_NUMBER = ""
}
}
;
Param2.COMPANY_CODE = Param2.COMPANY_CODE;
Param2.STORE_CODE = Param2.STORE_CODE;
string msg = string.Empty;
//Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
Param.BIRTH = Param.BIRTH.RemoveDateString();
T_MEMBER memData = new AccountService().GetMemberList(new T_MEMBER_COND {
USER_ID = Param.USER_ID
}).FirstOrDefault();
RTN_SAVE_DATA data = new RTN_SAVE_DATA();
if (Param.PASSWORD != "******")
{
if (!string.IsNullOrEmpty(Param.PASSWORD))
{
memData.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
}
}
memData.BIRTH = Param.BIRTH;
memData.USER_NAME = Param.USER_NAME;
memData.ZIP_CODE = Param.ZIP_CODE;
memData.ADDRESS1 = Param.ADDRESS1;
memData.ADDRESS2 = Param.ADDRESS2;
memData.PHONE = Param.PHONE;
memData.GENDER = Param.GENDER;
memData.INSERT_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
///memData.MEMBER_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
data = new AccountService().MemberModify(memData, Param2);
data.RETURN_URL = "/";
memData = new AccountService().GetMemberList(new T_MEMBER_COND {
USER_ID = Param.USER_ID
}).FirstOrDefault();
// SessionHelper.LoginInfo.STORE = new ALT.BizService.BasicService().GetStoreList(new T_STORE_COND { STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE }).First();
// SessionHelper.LoginInfo.MEMBER = memData;
return(new JsonResult {
Data = data
});
}
public ActionResult Edit(T_MEMBER t_member)
{
if (ModelState.IsValid)
{
db.T_MEMBER.Attach(t_member);
db.ObjectStateManager.ChangeObjectState(t_member, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(t_member));
}
public ActionResult Create(T_MEMBER t_member)
{
if (ModelState.IsValid)
{
db.T_MEMBER.AddObject(t_member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(t_member));
}
public JsonResult SaveAddMember(T_MEMBER Param)
{
string msg = string.Empty;
Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
msg = new AccountService().SaveMember(Param);
return(new JsonResult {
Data = new { error_message = msg }
});
}
public JsonResult MemberList(T_MEMBER Param)
{
var list = new HomePageService().GetMemberList(Param);
list.ForEach(i => i.PASSWORD = "******");
return(new JsonResult()
{
Data = new { list = list }
});
}
public List <T_MEMBER> GetMemberList(T_MEMBER Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "HomePage\\Account.xml", "GetMemberList"
, Cond.USER_ID.ToString("")
, Cond.USER_TYPE.ToString("")
, Cond.PHONE.ToString("")
, Cond.MOBILE.ToString("")
);
return(db.ExecuteQuery <T_MEMBER>(sql).ToList());
}
public JsonResult PasswordChangeSave(T_MEMBER Param)
{
Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
RTN_SAVE_DATA data = new AccountService().PasswordChangeSave(Param);
//new MailHelper() {
//}
return(new JsonResult()
{
Data = data
});
}
public JsonResult SaveMember(T_MEMBER Param)
{
string msg = string.Empty;
Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
Param.BIRTH = Param.BIRTH.RemoveDateString();
Param.INSERT_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
RTN_SAVE_DATA data = new AccountService().SaveMember(Param);
return(new JsonResult {
Data = new { data = data }
});
}
public RTN_SAVE_DATA SaveMember([FromBody] T_MEMBER Param)
{
Param.USER_ID = Global.SecurityInfo.Decrypt_data(Param.USER_ID);
Param.USER_NAME = Global.SecurityInfo.Decrypt_data(Param.USER_NAME);
Param.EMAIL = Global.SecurityInfo.Decrypt_data(Param.EMAIL);
Param.KAKAO_ID = Global.SecurityInfo.Decrypt_data(Param.KAKAO_ID);
Param.GOOGLE_ID = Global.SecurityInfo.Decrypt_data(Param.GOOGLE_ID);
Param.NAVER_ID = Global.SecurityInfo.Decrypt_data(Param.NAVER_ID);
Param.FACEBOOK_ID = Global.SecurityInfo.Decrypt_data(Param.FACEBOOK_ID);
Param.thumnailPath = Global.SecurityInfo.Decrypt_data(Param.thumnailPath);
RTN_SAVE_DATA rtnData = new AccountService().SaveMember(Param);
return(rtnData);
}
public JsonResult employeeSave(T_MEMBER Param)
{
SessionHelper.LOG_NAME = "직원저장";
string msg = string.Empty;
Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
Param.BIRTH = Param.BIRTH.RemoveDateString();
Param.INSERT_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
RTN_SAVE_DATA data = new AccountService().SaveMember(Param);
// data.RETURN_URL = "/advstep/step2";
//IList<T_MEMBER> list = new AccountService().GetMemberList(new T_MEMBER { USER_ID = Param.USER_ID });
//SessionHelper.LoginInfo.MEMBER = list.First();
return(new JsonResult {
Data = data
});
}
public JsonResult MemberModifySave(T_MEMBER Param)
{
string msg = string.Empty;
Param.PASSWORD = GlobalMvc.Util.Encrypt_PW(Param.PASSWORD);
Param.BIRTH = Param.BIRTH.RemoveDateString();
T_MEMBER memData = new AccountService().GetMemberList(new T_MEMBER_COND {
USER_ID = Param.USER_ID
}).FirstOrDefault();
RTN_SAVE_DATA data = new RTN_SAVE_DATA();
if (memData.PASSWORD != Param.PASSWORD)
{
data = new RTN_SAVE_DATA {
ERROR_MESSAGE = "비밀번호가 맞지 않습니다.", FOCUS_TAG_ID = "PASSWORD"
};
return(new JsonResult {
Data = data
});
}
Param.INSERT_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
Param.MEMBER_CODE = (int)(SessionHelper.LoginInfo.MEMBER == null ? 0 : SessionHelper.LoginInfo.MEMBER.MEMBER_CODE);
data = new AccountService().SaveMember(Param);
data.RETURN_URL = "/advstep/steplist";
memData = new AccountService().GetMemberList(new T_MEMBER_COND {
USER_ID = Param.USER_ID
}).FirstOrDefault();
SessionHelper.LoginInfo.MEMBER = memData;
return(new JsonResult {
Data = data
});
}
//
// GET: /Member/Delete/5
public ActionResult Delete(int id)
{
T_MEMBER t_member = db.T_MEMBER.Single(t => t.ID == id);
return(View(t_member));
}
/// <summary>
/// 사용자정보 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public RTN_SAVE_DATA SaveMember(T_MEMBER Param)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
Param.SAVE_MODE = Param.SAVE_MODE.ToString("");
if (Param.SAVE_MODE == "U" || Param.SAVE_MODE == "D")/*모바일에서 저장 할경우에만 값이 있음 N일경우에는 신규이기때문에 해당로직에서 제외*/
{
T_MEMBER data = this.GetMemberList(new T_MEMBER_COND {
USER_ID = Param.USER_ID
}).FirstOrDefault();
if (data == null)
{
data = new T_MEMBER()
{
USER_ID = Param.USER_ID
}
}
;
data.USER_NAME = Param.USER_NAME;
data.BIRTH = Param.BIRTH;
data.GENDER = Param.GENDER;
data.PHONE = Param.PHONE;
data.SAVE_MODE = Param.SAVE_MODE;
Param = data;
if (Param.SAVE_MODE == "D")
{
Param.HIDE = true;
}
}
if (string.IsNullOrEmpty(Param.USER_ID))
{
throw new Exception("아이디를 입력하여 주시기 바랍니다.");
}
if (string.IsNullOrEmpty(Param.PASSWORD))
{
throw new Exception("암호를 입력하여 주시기 바랍니다.");
}
using (TransactionScope tran = new TransactionScope()) {
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Account\\Member.xml", "MemberSave"
, Param.MEMBER_CODE.ToString("-1")
, Param.USER_TYPE.ToString("2")
, Param.USER_ID.ToString("")
, Param.PASSWORD.ToString("")
, Param.USER_NAME.ToString("")
, Param.EMAIL.ToString("")
, Param.PHONE.ToString("")
, Param.MOBILE.ToString("")
, Param.ADDRESS1.ToString("")
, Param.ADDRESS2.ToString("")
, Param.ZIP_CODE.ToString("")
, Param.BIRTH.ToString("")
, Param.GENDER.ToString("1")
, Param.PASSWORD_CHANGE_URL.ToString("")
, Param.PASSWORD_AUTH_TIME.ToString("1901-01-01 00:00:00")
, Param.KAKAO_ID.ToString("")
, Param.GOOGLE_ID.ToString("")
, Param.NAVER_ID.ToString("")
, Param.FACEBOOK_ID.ToString("")
, Param.HIDE == true ? "1" : "0"
, Param.REMARK.ToString("")
, Param.INSERT_CODE.ToString() /*Admin*/
, Param.SAVE_MODE.ToString("")
, Param.thumnailPath.ToString("")
);
rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).FirstOrDefault();
if (!string.IsNullOrEmpty(rtn.ERROR_MESSAGE))
{
throw new Exception(rtn.ERROR_MESSAGE);
}
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
//
// GET: /Member/Details/5
public ViewResult Details(int id)
{
T_MEMBER t_member = db.T_MEMBER.Single(t => t.ID == id);
return(View(t_member));
}
