public async Task <JsonResult> GetCompNm(int compSn) { var baLoginKey = Session[Global.LoginID].ToString(); var baInfo = await _scUsrService.getBaInfoById(baLoginKey); var compInfo = await vcCompInfoService.getCompMappingInfosList(compSn, baInfo.BaSn); var dropDwonConCode = Mapper.Map <IList <JoinMentorViewModel> >(compInfo); JoinMentorViewModel title = new JoinMentorViewModel(); title.ConCode = "분야 코드 선택"; dropDwonConCode.Insert(0, title); SelectList conCodeListSelect = new SelectList(dropDwonConCode, "ConCode", "ConCode"); return(Json(conCodeListSelect)); }
public async Task <ActionResult> MentorCompMapping(JoinMentorViewModel paramodel, string curPage) { ViewBag.naviLeftMenu = Global.MentorMng; var baLoginKey = Session[Global.LoginID].ToString(); var baInfo = await _scUsrService.getBaInfoById(baLoginKey); // 기업 List SqlParameter loginKey = new SqlParameter("TCMS_LOGIN_KEY", Session[Global.LoginID]); object[] parameters22 = new object[] { loginKey }; var obj22 = await procMngService.baGetCompSelectList(parameters22); //var obj23 = obj22.Where(bw => bw.MENTOR_SN == null); var dropDownCompList22 = Mapper.Map <List <JoinMentorViewModel> >(obj22); JoinMentorViewModel title22 = new JoinMentorViewModel(); title22.CompSn = "0"; title22.CompNm = "기업선택"; dropDownCompList22.Insert(0, title22); SelectList compSelectList = new SelectList(dropDownCompList22, "CompSn", "CompNm"); ViewBag.SelectCompList = compSelectList; // 멘토 select List //SqlParameter loginId2 = new SqlParameter("LOGIN_ID", Session[Global.LoginID]); // sql 파라미터 값 설정 //object[] parameters2 = new object[] { loginId2 }; // 객체에 데이터 삽입 //var obj2 = await procBaMentorMapping.getBaMentorMapping(parameters2); // 해당 기업과 관련된 리스트데이터 가져오기 var obj2 = await _scUsrService.baGetMappingMentor(baInfo.BaSn); var dropDownMentor = Mapper.Map <List <JoinMentorViewModel> >(obj2); foreach (var item in dropDownMentor) { var mentorInfo = await _scUsrService.selectScUsrByTcms(item.MentorLoginKey); var mentorNm = mentorInfo.Name; item.MentorNm = mentorNm; } JoinMentorViewModel title = new JoinMentorViewModel(); title.MentorSn = "0"; title.MentorNm = "멘토 선택"; dropDownMentor.Insert(0, title); SelectList mentorListSelect = new SelectList(dropDownMentor, "MentorSn", "MentorNm"); ViewBag.SelectMentorList = mentorListSelect; // 분야 select List var conCodeList = new List <SelectListItem>(); conCodeList.Add(new SelectListItem { Value = "0", Text = "분야 코드 선택", Selected = true }); SelectList list = new SelectList(conCodeList, "Value", "Text"); ViewBag.SelectConCodeList = list; // 해당 BA에 매핑된 멘토 SelectList SqlParameter baSn = new SqlParameter("BA_SN", baInfo.BaSn.ToString()); object[] baSnSql = new object[] { baSn }; var obj = await procMngService.baGetCompMentorMappingList(baSnSql); var usrViewsInfo = Mapper.Map <List <JoinMentorViewModel> >(obj); // mapping 됐는지 안됐는지 확인 foreach (var item in usrViewsInfo) { var itemCompSn = int.Parse(item.CompSn); var itemBaSn = int.Parse(item.BaSn); var itemNumSn = item.NumSn; var itemSubNumSn = item.SubNumSn; var itemConCode = item.ConCode; var checkMapping = await vcMentorMappingService.checkCompMentorMapping(itemCompSn, itemBaSn, itemNumSn, itemSubNumSn, itemConCode); if (checkMapping.Count > 0) { item.MappingYn = "Y"; } else { item.MappingYn = "N"; } } var usrViewsInfos = Mapper.Map <List <JoinMentorViewModel> >(usrViewsInfo); var usrViewsInfosOrderby = usrViewsInfo.OrderBy(bw => bw.MappingYn); int pagingSize = int.Parse(ConfigurationManager.AppSettings["PagingSize"]); return(View(new StaticPagedList <JoinMentorViewModel>(usrViewsInfosOrderby.ToPagedList(int.Parse(curPage ?? "1"), pagingSize), int.Parse(curPage ?? "1"), pagingSize, usrViewsInfos.Count))); }
public async Task <ActionResult> MentorCompMapping(JoinMentorViewModel paramodel) { ViewBag.naviLeftMenu = Global.MentorMng; // compSn을 이용하여 vc_comp_mapping에서 ba_sn, num_sn 추출 var compSn = int.Parse(paramodel.CompSn); SqlParameter loginId = new SqlParameter("LOGIN_ID", Session[Global.LoginID]); // sql 파라미터 값 설정 object[] parameters = new object[] { loginId }; // 객체에 데이터 삽입 var obj = await procBaMentorMapping.getBaMentorNonMapping(parameters); // 해당 기업과 관련된 리스트데이터 가져오기 var baSn = obj[0].BA_SN; var compMappingInfo = await vcCompInfoService.getCompMappingInfosList(compSn, baSn); var numSn = compMappingInfo[0].NumSn; VcMentorMapping mentorMapping = new VcMentorMapping(); mentorMapping.CompSn = int.Parse(paramodel.CompSn); mentorMapping.MentorSn = int.Parse(paramodel.MentorSn); mentorMapping.BaSn = compMappingInfo[0].BaSn; mentorMapping.NumSn = compMappingInfo[0].NumSn; mentorMapping.SubNumSn = compMappingInfo[0].SubNumSn; mentorMapping.ConCode = paramodel.ConCode; mentorMapping.RegDt = DateTime.Now; mentorMapping.UpdDt = DateTime.Now; // 해당 기업의 매핑이 처음인지 아닌지 확인 // 해당 BA가 WRITE_YN을 가지고 있을 때 Y에 대한 권한을 주는 과정 var checkMapping = await vcMentorMappingService.getCheckMapping(compSn, baSn, numSn); var checkBaWriterList = await vcCompInfoService.checkBaWriterList(compSn, baSn, numSn); var checkBaWiret = checkBaWriterList.Where(bw => bw.WriteYn == "Y").ToList(); if (checkBaWiret.Count != 0) { // BA가 작성 권한이 있다는 이야기 if (checkMapping.Count == 0) { // 작성 권한이 있는 BA가 첫번째로 할당해주는 멘토에게 작성 권한 부여 mentorMapping.WriteYn = "Y"; } else { mentorMapping.WriteYn = "N"; } } else { mentorMapping.WriteYn = "N"; } vcMentorMappingService.insertMentorMapping(mentorMapping); //await _scUsrService.SaveDbContextAsync(); return(RedirectToAction("MentorCompMapping", "MentorMng", new { area = "BizManager" })); }
public async Task <ActionResult> RegMentor(JoinMentorViewModel joinMentorViewModel) { ViewBag.LeftMenu = Global.MentorMng; string excutorId = null; //사업담당자 일 경우 담당 사업만 조회 if (Session[Global.UserDetailType].ToString() == "M") { excutorId = Session[Global.LoginID].ToString(); } //사업 DropDown List Data var listScBizWork = await _scBizWorkService.GetBizWorkList(int.Parse(Session[Global.CompSN].ToString()), excutorId); var bizWorkDropDown = Mapper.Map <List <BizWorkDropDownModel> >(listScBizWork); if (Session[Global.UserDetailType].ToString() == "A") { BizWorkDropDownModel title = new BizWorkDropDownModel(); title.BizWorkSn = 0; title.BizWorkNm = "사업명 선택"; bizWorkDropDown.Insert(0, title); } SelectList bizList = new SelectList(bizWorkDropDown, "BizWorkSn", "BizWorkNm"); ViewBag.SelectBizWorkList = bizList; if (ModelState.IsValid) { if (joinMentorViewModel.BizWorkSn == 0) { ModelState.AddModelError("", "사업명을 선택하지 않았습니다."); return(View(joinMentorViewModel)); } var scUsr = Mapper.Map <ScUsr>(joinMentorViewModel); var scCompInfo = Mapper.Map <ScCompInfo>(joinMentorViewModel); //회원정보 추가 정보 설정 scUsr.RegId = Session[Global.LoginID].ToString(); scUsr.RegDt = DateTime.Now; scUsr.Status = "N"; scUsr.UsrType = "M"; scUsr.UsrTypeDetail = "E"; SHACryptography sha2 = new SHACryptography(); scUsr.LoginPw = sha2.EncryptString(scUsr.LoginPw); //회사정보 추가 정보 설정 scCompInfo.Status = "N"; scCompInfo.RegId = Session[Global.LoginID].ToString(); scCompInfo.RegDt = DateTime.Now; //멘토 매핑정보 생성 ScMentorMappiing scMentorMappiing = new ScMentorMappiing(); scMentorMappiing.BizWorkSn = joinMentorViewModel.BizWorkSn; scMentorMappiing.MentorId = scUsr.LoginId; scMentorMappiing.Status = "N"; scMentorMappiing.MngCompSn = int.Parse(Session[Global.CompSN].ToString()); scMentorMappiing.RegId = scUsr.RegId; scMentorMappiing.RegDt = scUsr.RegDt; scUsr.ScMentorMappiings.Add(scMentorMappiing); //저장 scCompInfo.ScUsrs.Add(scUsr); //bool result = _scUsrService.AddCompanyUser(scCompInfo, scUsr, syUser); int result = await _scMentorMappingService.AddMentorAsync(scCompInfo); if (result != -1) { return(RedirectToAction("MentorList", "MentorMng")); } else { ModelState.AddModelError("", "멘토 등록 실패."); return(View(joinMentorViewModel)); } } return(View(joinMentorViewModel)); }