public async Task <int> AddCompanyUserAsync(VcCompInfo scCompInfo, VcUsrInfo scUsr, SHUSER_SyUser syUser) { //var rstScUsr = scUsrRespository.Insert(scUsr); //scCompInfo. var rstScCompInfo = scCompInfoRespository.Insert(scCompInfo); // vcCompInfoRepository //var rstSyUser = syUserRespository.Insert(syUser); //if (rstScCompInfo == null || rstSyUser != 1) //{ // return -1; //} if (rstScCompInfo == null) { return(-1); } var rst = await SaveDbContextAsync(); return(rst); //if (rst != 1) // return rst; //return await SaveDareDbContextAsync(); }
public async Task <JsonResult> UpdateLoginPassword(string ID, string LOGIN_PW) { // 누가 로그인 했는 지에 대한 ID 확인 VcUsrInfo scUsr = await _scUsrService.SelectScUsr(ID); if (scUsr != null) { //패스워드비교 SHACryptography sha2 = new SHACryptography(); //scUsr.LoginPw = sha2.EncryptString(LOGIN_PW); await _scUsrService.SaveDbContextAsync(); // 다래 임시 주석 //SHUSER_SyUser syUsr = new SHUSER_SyUser(); //syUsr.SmartPwd = scUsr.LoginPw; //syUsr.IdUser = scUsr.LoginId; //syUsr.MembBusnpersNo = scUsr.ScCompInfo.RegistrationNo; //var rst = _scUsrService.UpdatePassword(syUsr); return(Json(new { result = true })); } else { return(Json(new { result = false })); } }
public async Task <ActionResult> Index(LoginViewModel loginViewModel) { if (Session[Global.UserLogo] == null) { base.SetLogo("bi_main.png", "Login"); } if (!ModelState.IsValid) { return(View(loginViewModel)); } VcUsrInfo scUsr = await _scUsrService.SelectScUsr(loginViewModel.ID); if (scUsr != null) { //패스워드비교 //var vcCompInfo = await _vcCompInfoService.getVcCompInfoById(loginViewModel.ID); SHACryptography sha2 = new SHACryptography(); //if (scUsr.LoginPw == sha2.EncryptString(loginViewModel.Password)) //if (user.LOGIN_PW == param.LOGIN_PW) { base.LogOn(scUsr); switch (scUsr.UsrType) { case Global.Company: //기업 return(RedirectToAction("index", "Company/Main")); case Global.Mentor: //멘토 return(RedirectToAction("index", "Mentor/Main")); case Global.Expert: //전문가 return(RedirectToAction("index", "Expert/Main")); case Global.SysManager: //SCP return(RedirectToAction("index", "SysManager/Main")); case Global.BizManager: //사업관리자 return(RedirectToAction("index", "BizManager/Main")); default: ModelState.AddModelError("", "정의되지 않은 사용자 타입입니다."); return(View(loginViewModel)); } } //else //{ // ModelState.AddModelError("", "비밀번호가 일치하지 않습니다."); // return View(loginViewModel); //} } else { ModelState.AddModelError("", "아이디가 존재하지 않습니다."); return(View(loginViewModel)); } }
public async Task <int> AddBizManagerMemberAsync(VcUsrInfo scUsr) { var rstScUsr = scUsrRespository.Insert(scUsr); if (rstScUsr == null) { return(-1); } return(await SaveDbContextAsync()); }
public async Task <ActionResult> AgreeCompanyAgreement() { VcUsrInfo scUsr = await _scUsrService.selectScUsrByTcms(Session[Global.LoginID].ToString()); scUsr.AgreeYn = "Y"; _scUsrService.ModifyScUsr(scUsr); await _scUsrService.SaveDbContextAsync(); Session[Global.AgreeYn] = "Y"; return(RedirectToAction("Index", "Main")); }
/// <summary> /// [기능] : 로그온 세션생성 /// [작성] : 2014-10-23 김충기 /// [수정] : /// </summary> /// <param name="user"></param> protected void LogOn(VcUsrInfo user) { Session[Global.LoginID] = user.TcmsLoginKey.ToString(); //Session[Global.CompSN] = user.CompSn; //Session[Global.CompRegistrationNo] = registrationNo; Session[Global.UserNM] = user.Name; Session[Global.UserType] = user.UsrType; //Session[Global.UserDetailType] = user.UsrTypeDetail; Session[Global.UserTypeVal] = GetUserTypeVal(user.UsrType); // 권한체크용 Session[Global.AgreeYn] = user.AgreeYn; // 약관동의 부분 //Session[Global.UseErp] = user.UseErp; // Session에 UseErp 추가 }
public async Task <JsonResult> DeleteExpert(string[] loginIds) { ViewBag.LeftMenu = Global.ExpertMng; foreach (var loginId in loginIds) { VcUsrInfo scUsr = await _scUsrService.SelectScUsr(loginId); //scUsr.Status = "D"; await _scUsrService.SaveDbContextAsync(); } return(Json(new { result = true })); }
public async Task <ActionResult> DoLogin(LoginViewModel loginViewModel) { VcUsrInfo scUsr = await _scUsrService.SelectScUsr(loginViewModel.ID); if (scUsr != null) { //패스워드비교 SHACryptography sha2 = new SHACryptography(); //if (scUsr.LoginPw == sha2.EncryptString(loginViewModel.Password)) //if (user.LOGIN_PW == param.LOGIN_PW) { switch (scUsr.UsrType) { case "C": //기업 return(RedirectToAction("index", "Commany/Main")); case "M": //멘토 return(RedirectToAction("index", "Mentor/Main")); case "P": //전문가 return(RedirectToAction("index", "Expert/Main")); case "S": //SCP return(RedirectToAction("index", "SysManager/Main")); case "B": //사업관리자 return(RedirectToAction("index", "BizManager/Main")); case "A": //사업관리자 return(RedirectToAction("index", "BizManager/Main")); default: return(RedirectToAction("index", "Home")); } } //else //{ // return RedirectToAction("index", "Home"); //} } else { return(RedirectToAction("index", "Home")); } }
// GET: Company/MyInfo public async Task <ActionResult> MyInfo() { ViewBag.naviLeftMenu = Global.MyInfo; VcUsrInfo scUsr = await _scUsrService.SelectScUsr(Session[Global.LoginID].ToString()); var myInfo = Mapper.Map <CompanyMyInfoViewModel>(scUsr); //업종, 종목 //var listScBizType = await _scBizTypeService.GetScBizTypeByCompSn(int.Parse(scUsr.CompSn)); //var bizTypeViewModel = // Mapper.Map<List<BizTypeViewModel>>(listScBizType); //myInfo.BizTypes = bizTypeViewModel; return(View(myInfo)); }
//public async Task<ActionResult> ResetMentorPw(string bizWorkSn, string mentorId) //{ // ViewBag.LeftMenu = Global.MentorMng; // ScMentorMappiing scMentorMapping = await _scMentorMappingService.GetMentor(int.Parse(bizWorkSn), mentorId); // var usrView = // Mapper.Map<JoinMentorViewModel>(scMentorMapping); // SHACryptography sha2 = new SHACryptography(); // //ScUsr scUsr = await _scUsrService.SelectScUsr(model.ID); // //SHUSER_SyUser syUsr = new SHUSER_SyUser(); // //// 특정한 pw를 미리 설정 // //model.NewLoginPw = "ab12345678"; // //scUsr.LoginPw = sha2.EncryptString(model.NewLoginPw); // //syUsr.SmartPwd = scUsr.LoginPw; // //await _scUsrService.SaveDbContextAsync(); // //var rst = _scUsrService.UpdatePassword(syUsr); // //// 누가 누구의 pw를 초기화 시킬 것인지? // //string usrArea; // //if (Session[Global.UserType].ToString().Equals(Global.SysManager)) // //{ // // // 시스템 담당자 // // // 시스템 담당자가 -> 사업관리기관, 전문가 회원 pw 초기화 // // usrArea = "SysManager"; // //} // //else if (Session[Global.UserType].ToString().Equals(Global.BizManager)) // //{ // // // 사업관리기관 // // // 사업관리기관 -> 사업담당자, 멘토 pw 초기화 // // usrArea = "BizManager"; // //} // //return View(); // return View(usrView); //} // add Loy public async Task <ActionResult> UserPasswordReset(string mentorId) { //ScMentorMappiing scMentorMapping = await _scMentorMappingService.GetMentor(int.Parse(bizWorkSn), mentorId); //ScUsr scUsr = await _scUsrService.SelectScUsr(scMentorMapping.MentorId); VcUsrInfo scUsr = await _scUsrService.SelectScUsr(mentorId); SHACryptography sha2 = new SHACryptography(); var rstPw = "a12345678"; var sha2pw = sha2.EncryptString(rstPw); //scUsr.LoginPw = sha2pw; await _scUsrService.SaveDbContextAsync(); //var rst = _scUsrService.UserPasswordReset(scUsr); // 초기화 후 list로 돌아가기 return(RedirectToAction("MentorList", "MentorMng", new { area = "BizManager" })); }
//[HttpPost] //[ValidateAntiForgeryToken] //public async Task<ActionResult> RegExpertManager(JoinExpertViewModel joinExpertViewModel, string BizList) //{ // ViewBag.LeftMenu = Global.ExpertMng; // var bizMngList = await _scUsrService.GetBizManagerAsync(); // var bizMngDropDown = // Mapper.Map<List<BizMngDropDownModel>>(bizMngList); // BizMngDropDownModel title = new BizMngDropDownModel(); // title.CompSn = 0; // title.CompNm = "사업관리기관 선택"; // bizMngDropDown.Insert(0, title); // SelectList bizList = new SelectList(bizMngDropDown, "CompSn", "CompNm"); // ViewBag.SelectBizMngList = bizList; // if (ModelState.IsValid) // { // if(string.IsNullOrEmpty(BizList) || BizList == "0" ) // { // ModelState.AddModelError("", "사업명을 선택하지 않았습니다."); // return View(joinExpertViewModel); // } // var expert = await _scExpertMappingService.GetSameDetailTypeExpertAsync(int.Parse(BizList), joinExpertViewModel.UsrTypeDetail); // if(expert != null) // { // ModelState.AddModelError("", "동일한 분야의 전문가가 이미 사업에 맵핑되어 있습니다."); // return View(joinExpertViewModel); // } // var scUsr = Mapper.Map<ScUsr>(joinExpertViewModel); // var scCompInfo = Mapper.Map<ScCompInfo>(joinExpertViewModel); // //회원정보 추가 정보 설정 // scUsr.RegId = Session[Global.LoginID].ToString(); // scUsr.RegDt = DateTime.Now; // scUsr.Status = "N"; // scUsr.UsrType = "P"; // SHACryptography sha2 = new SHACryptography(); // scUsr.LoginPw = sha2.EncryptString(scUsr.LoginPw); // //회사정보 추가 정보 설정 // scCompInfo.Status = "N"; // scCompInfo.RegId = Session[Global.LoginID].ToString(); // scCompInfo.RegDt = DateTime.Now; // //전문가 매핑정보 생성 // IList<ScExpertMapping> scExpertMappings = new List<ScExpertMapping>(); // ScExpertMapping scExpertMapping = new ScExpertMapping(); // scExpertMapping.BizWorkSn = int.Parse(BizList); // scExpertMapping.ExpertId = scUsr.LoginId; // scExpertMapping.Status = "N"; // scExpertMapping.RegId = scUsr.RegId; // scExpertMapping.RegDt = scUsr.RegDt; // scExpertMappings.Add(scExpertMapping); // scUsr.ScExpertMappings = scExpertMappings; // //저장 // IList<ScUsr> scUsrs = new List<ScUsr>(); // scUsrs.Add(scUsr); // scCompInfo.ScUsrs = scUsrs; // //bool result = _scUsrService.AddCompanyUser(scCompInfo, scUsr, syUser); // int result = await _scUsrService.AddBizManagerAsync(scCompInfo); // if (result != -1) // return RedirectToAction("ExpertManager", "ExpertManager"); // else // { // ModelState.AddModelError("", "전문가 등록 실패."); // return View(joinExpertViewModel); // } // } // return View(joinExpertViewModel); //} //[HttpPost] //public async Task<JsonResult> DoLoginIdSelect(string LoginId) //{ // bool result = await _scUsrService.ChkLoginId(LoginId); // if (result.Equals(true)) // { // return Json(new { result = true }); // } // else // { // return Json(new { result = false }); // } //} //[HttpPost] //public async Task<JsonResult> GetBizList(string CompSn) //{ // var bizWork = await _scBizWorkService.GetBizWorkList(int.Parse(CompSn)); // var bizWorkDropDown = // Mapper.Map<List<BizWorkDropDownModel>>(bizWork); // return Json(bizWorkDropDown); //} public async Task <ActionResult> ExpertManagerDetail(string loginId) { ViewBag.LeftMenu = Global.ExpertMng; VcUsrInfo scUsr = await _scUsrService.SelectScUsr(loginId); var myInfo = Mapper.Map <JoinExpertViewModel>(scUsr); //업종, 종목 var listScBizType = await _scBizTypeService.GetScBizTypeByCompSn(myInfo.CompSn); var bizTypeViewModel = Mapper.Map <List <BizTypeViewModel> >(listScBizType); myInfo.BizTypes = bizTypeViewModel; return(View(myInfo)); }
public void insertVcUsrInfo(VcUsrInfo vcUsrInfo) { scUsrRespository.Add(vcUsrInfo); SaveDbContext(); }
public async void insertUsrforIf(VcUsrInfo scUsr) { scUsrRespository.Add(scUsr); await SaveDbContextAsync(); }
public int UserPasswordReset(VcUsrInfo scUsr) { var rstScUser = scUsrRespository.UserPasswordReset(scUsr); return(rstScUser); }
public async Task <ActionResult> ModifyMyInfo(CompanyMyInfoViewModel companyInfoViewModel, ModifyCompanyParamModel param) { ViewBag.LeftMenu = Global.MyInfo; VcUsrInfo scUsr = await _scUsrService.SelectScUsr(Session[Global.LoginID].ToString()); if (Session[Global.LoginID].ToString() != param.LoginIdChk) { companyInfoViewModel = Mapper.Map <CompanyMyInfoViewModel>(scUsr); ModelState.AddModelError("", "로그인된 아이디가 아닙니다."); return(View(companyInfoViewModel)); } //실제패스워드와 입력패스워드 비교 SHACryptography sha2 = new SHACryptography(); if (param.LoginPwChk != sha2.EncryptString(companyInfoViewModel.LoginPw)) { companyInfoViewModel = Mapper.Map <CompanyMyInfoViewModel>(scUsr); ModelState.AddModelError("", "비밀번호가 일치하지 않습니다."); return(View(companyInfoViewModel)); } //담당자정보 scUsr.Name = companyInfoViewModel.Name; scUsr.Email = companyInfoViewModel.Email1 + "@" + companyInfoViewModel.Email2; //scUsr.FaxNo = mentorViewModel.FaxNo1 + "-" + mentorViewModel.FaxNo2 + "-" + mentorViewModel.FaxNo3; scUsr.MbNo = companyInfoViewModel.MbNo1 + "-" + companyInfoViewModel.MbNo2 + "-" + companyInfoViewModel.MbNo3; scUsr.TelNo = companyInfoViewModel.TelNo1 + "-" + companyInfoViewModel.TelNo2 + "-" + companyInfoViewModel.TelNo3; //회사정보 foreign key //scUsr.ScCompInfo.CompNm = companyInfoViewModel.CompNm; //scUsr.ScCompInfo.OwnNm = companyInfoViewModel.ComOwnNm; //scUsr.ScCompInfo.TelNo = companyInfoViewModel.ComTelNo1 + "-" + companyInfoViewModel.ComTelNo2 + "-" + companyInfoViewModel.ComTelNo3; //scUsr.ScCompInfo.PostNo = companyInfoViewModel.ComPostNo; //scUsr.ScCompInfo.Addr1 = companyInfoViewModel.ComAddr1; //scUsr.ScCompInfo.Addr2 = companyInfoViewModel.ComAddr2; _scUsrService.ModifyScUsr(scUsr); //업종 ,종목 int compSn = int.Parse(Session[Global.CompSN].ToString()); if (companyInfoViewModel.BizTypes.Count > 0) { _scBizTypeService.DeleteScBizTypeByCompSn(compSn); foreach (var item in companyInfoViewModel.BizTypes) { var scBizType = new ScBizType { CompSn = compSn, BizTypeCd = item.BizTypeCd, BizTypeNm = item.BizTypeNm }; _scBizTypeService.AddScBizType(scBizType); } } //다성공시 커밋 await _scUsrService.SaveDbContextAsync(); return(RedirectToAction("MyInfo", "MyInfo")); }
public async Task <ActionResult> ChangePassword(ChangePasswordViewModel model) { ViewBag.LeftMenu = Global.MyInfo; if (Session[Global.LoginID].ToString() != model.ID) { ModelState.AddModelError("", "로그인된 아이디가 아닙니다."); return(View()); } VcUsrInfo scUsr = await _scUsrService.SelectScUsr(model.ID); if (scUsr != null) { //패스워드비교 SHACryptography sha2 = new SHACryptography(); //if (scUsr.LoginPw == sha2.EncryptString(model.LoginPw)) { //scUsr.LoginPw = sha2.EncryptString(model.NewLoginPw); await _scUsrService.SaveDbContextAsync(); /** * 다래 DB 연결 주석 * SHUSER_SyUser syUsr = new SHUSER_SyUser(); * syUsr.SmartPwd = scUsr.LoginPw; * syUsr.IdUser = scUsr.LoginId; * syUsr.MembBusnpersNo = scUsr.ScCompInfo.RegistrationNo; * var rst = _scUsrService.UpdatePassword(syUsr); */ string usrArea; if (Session[Global.UserType].ToString().Equals(Global.Company)) {// 기업회원 usrArea = "Company"; return(RedirectToAction("MyInfo", "MyInfo", new { area = usrArea })); } else if (Session[Global.UserType].ToString().Equals(Global.Mentor)) {// 멘토 usrArea = "Mentor"; } else if (Session[Global.UserType].ToString().Equals(Global.SysManager)) {// SCP 관리자 usrArea = "SysManager"; } else if (Session[Global.UserType].ToString().Equals(Global.BizManager)) {// 사업 관리자 usrArea = "BizManager"; } else if (Session[Global.UserType].ToString().Equals(Global.Expert)) {// 전문가 usrArea = "Expert"; } else { usrArea = ""; } return(RedirectToAction("MyInfo", "Main", new { area = usrArea })); } //else //{ // ModelState.AddModelError("", "비밀번호가 일치하지 않습니다."); // return View(); //} } else { ModelState.AddModelError("", "아이디가 존재하지 않습니다."); return(View()); } }
public void ModifyScUsr(VcUsrInfo scUsr) { scUsrRespository.Update(scUsr); }