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