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);
}
