public async Task <ActionResult> RegSend(RegSendViewModels dataRequestViewModel, string expertType, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.ExpertService;
if (ModelState.IsValid)
{
var scReqDoc = Mapper.Map <ScReqDoc>(dataRequestViewModel);
//회원정보 추가 정보 설정
scReqDoc.ChkYn = "N";
scReqDoc.ReqDt = DateTime.Now;
scReqDoc.SenderId = Session[Global.LoginID].ToString();
scReqDoc.Status = "N";
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Document.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scReqDocFile = new ScReqDocFile {
ScFileInfo = scFileInfo
};
scReqDocFile.RegType = "S";
scReqDoc.ScReqDocFiles.Add(scReqDocFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
//저장
int result = await _scReqDocService.AddReqDocAsync(scReqDoc);
if (result != -1)
{
return(RedirectToAction("SendList", "ExpertService", new { expertType = expertType }));
}
else
{
ModelState.AddModelError("", "자료요청 등록 실패.");
return(View(dataRequestViewModel));
}
}
ModelState.AddModelError("", "입력값 검증 실패.");
return(View(dataRequestViewModel));
}
public async Task <ActionResult> ModifyManual(ManualDetailViewModel manualDetailViewModel, string deleteFileSns, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.Cs;
var scForm = await _scFormService.GetScFormAsync(manualDetailViewModel.Manual.FormSn);
scForm.FormType = manualDetailViewModel.Manual.FormType;
scForm.Subject = manualDetailViewModel.Manual.Subject;
scForm.Contents = manualDetailViewModel.Manual.Contents;
scForm.UpdDt = DateTime.Now;
scForm.UpdId = Session[Global.LoginID].ToString();
//삭제파일 상태 업데이트
if (!string.IsNullOrEmpty(deleteFileSns.Trim()))
{
foreach (var deleteFileSn in deleteFileSns.Split(',').AsEnumerable())
{
scForm.ScFormFiles.Select(fi => fi.ScFileInfo).Where(fi => fi.FileSn == int.Parse(deleteFileSn)).FirstOrDefault().Status = "D";
}
}
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Manual.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scFormFile = new ScFormFile {
ScFileInfo = scFileInfo
};
scForm.ScFormFiles.Add(scFormFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
await _scFormService.ModifyScFormAsync(scForm);
return(RedirectToAction("Manual", "Cs"));
}
public async Task <ActionResult> RegManual(ManualViewModel manualViewModel, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.Cs;
var scForm =
Mapper.Map <ScForm>(manualViewModel);
scForm.Status = "N";
scForm.RegDt = DateTime.Now;
scForm.RegId = Session[Global.LoginID].ToString();
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Manual.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scFormFile = new ScFormFile {
ScFileInfo = scFileInfo
};
scForm.ScFormFiles.Add(scFormFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
int result = await _scFormService.AddScFormAsync(scForm);
if (result != -1)
{
return(RedirectToAction("Manual", "Cs"));
}
else
{
ModelState.AddModelError("", "메뉴얼 등록 실패.");
return(View(manualViewModel));
}
}
public async Task <ActionResult> ModifyReceive(DataRequstViewModels dataRequestViewModel, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.CompanyMng;
var scReqDoc = await _scReqDocService.GetReqDoc(dataRequestViewModel.ReqDocSn);
scReqDoc.ResContents = dataRequestViewModel.ResContents;
scReqDoc.ChkYn = "Y";
scReqDoc.ResDt = DateTime.Now;
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Document.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scReqDocFile = new ScReqDocFile {
ScFileInfo = scFileInfo
};
scReqDocFile.RegType = "R";
scReqDocFile.ReqDocSn = dataRequestViewModel.ReqDocSn;
scReqDoc.ScReqDocFiles.Add(scReqDocFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
int result = await _scReqDocService.SaveDbContextAsync();
if (result != -1)
{
return(RedirectToAction("ReceiveDetail", "CompanyMng", new { reqDocSn = dataRequestViewModel.ReqDocSn }));
}
else
{
ModelState.AddModelError("", "답변 등록 실패.");
return(View(dataRequestViewModel));
}
}
public async Task<ActionResult> RegSend(RegSendViewModels dataRequestViewModel, string expertType, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.ExpertService;
if (ModelState.IsValid)
{
var scReqDoc = Mapper.Map<ScReqDoc>(dataRequestViewModel);
//회원정보 추가 정보 설정
scReqDoc.ChkYn = "N";
scReqDoc.ReqDt = DateTime.Now;
scReqDoc.SenderId = Session[Global.LoginID].ToString();
scReqDoc.Status = "N";
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Document.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scReqDocFile = new ScReqDocFile { ScFileInfo = scFileInfo };
scReqDocFile.RegType = "S";
scReqDoc.ScReqDocFiles.Add(scReqDocFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
//저장
int result = await _scReqDocService.AddReqDocAsync(scReqDoc);
if (result != -1)
return RedirectToAction("SendList", "ExpertService", new {expertType = expertType });
else
{
ModelState.AddModelError("", "자료요청 등록 실패.");
return View(dataRequestViewModel);
}
}
ModelState.AddModelError("", "입력값 검증 실패.");
return View(dataRequestViewModel);
}
public async Task<ActionResult> ModifyReceive(DataRequstViewModels dataRequestViewModel, string expertType, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.ExpertService;
var scReqDoc = await _scReqDocService.GetReqDoc(dataRequestViewModel.ReqDocSn);
scReqDoc.ResContents = dataRequestViewModel.ResContents;
scReqDoc.ChkYn = "Y";
scReqDoc.ResDt = DateTime.Now;
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Document.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scReqDocFile = new ScReqDocFile { ScFileInfo = scFileInfo };
scReqDocFile.RegType = "R";
scReqDocFile.ReqDocSn = dataRequestViewModel.ReqDocSn;
scReqDoc.ScReqDocFiles.Add(scReqDocFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
int result = await _scReqDocService.SaveDbContextAsync();
if (result != -1)
return RedirectToAction("ReceiveDetail", "ExpertService", new { reqDocSn = dataRequestViewModel.ReqDocSn, expertType = expertType });
else
{
ModelState.AddModelError("", "답변 등록 실패.");
return View(dataRequestViewModel);
}
}
public async Task<ActionResult> ModifyMentoringReport(MentoringReportViewModel dataRequestViewModel, string deleteFileSns, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MentoringReport;
var mentorId = Session[Global.LoginID].ToString();
if (ModelState.IsValid)
{
var scMentoringReport = await _scMentoringReportService.GetMentoringReportById(dataRequestViewModel.ReportSn);
scMentoringReport.Attendee = dataRequestViewModel.Attendee;
scMentoringReport.BizWorkSn = dataRequestViewModel.BizWorkSn;
scMentoringReport.CompSn = dataRequestViewModel.CompSn;
scMentoringReport.MentorAreaCd = dataRequestViewModel.MentorAreaCd;
scMentoringReport.MentoringContents = dataRequestViewModel.MentoringContents;
scMentoringReport.MentoringDt = dataRequestViewModel.MentoringDt;
scMentoringReport.MentoringEdHr = dataRequestViewModel.MentoringEdHr;
scMentoringReport.MentoringPlace = dataRequestViewModel.MentoringPlace;
scMentoringReport.MentoringStHr = dataRequestViewModel.MentoringStHr;
scMentoringReport.MentoringSubject = dataRequestViewModel.MentoringSubject;
scMentoringReport.SubmitDt = dataRequestViewModel.SubmitDt;
scMentoringReport.UpdId = mentorId;
scMentoringReport.UpdDt = DateTime.Now;
//삭제파일 상태 업데이트
if (!string.IsNullOrEmpty(deleteFileSns.Trim()))
{
foreach (var deleteFileSn in deleteFileSns.Split(',').AsEnumerable())
{
scMentoringReport.ScMentoringFileInfoes.Select(mtfi => mtfi.ScFileInfo).Where(fi => fi.FileSn == int.Parse(deleteFileSn)).FirstOrDefault().Status = "D";
}
}
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Mentoring_Report.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scMentoringFileInfo = new ScMentoringFileInfo { ScFileInfo = scFileInfo };
//파일타입에 따라 재정의해서 넣어야 함(첨부파일, 사진)
scMentoringFileInfo.Classify = fileHelper.HasImageFile(file) ? "P" : "A";
scMentoringReport.ScMentoringFileInfoes.Add(scMentoringFileInfo);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//수정
await _scMentoringReportService.ModifyScMentoringReportAsync(scMentoringReport);
return RedirectToAction("MentoringReportList", "MentoringReport");
}
ModelState.AddModelError("", "입력값 검증 실패.");
return View(dataRequestViewModel);
}
public async Task<ActionResult> RegMentoringTotalReport(MentoringTotalReportViewModel dataRequestViewModel, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MentoringReport;
var mentorId = Session[Global.LoginID].ToString();
if (ModelState.IsValid)
{
var scMentoringTotalReport = Mapper.Map<ScMentoringTotalReport>(dataRequestViewModel);
scMentoringTotalReport.MentorId = mentorId;
scMentoringTotalReport.RegId = mentorId;
scMentoringTotalReport.RegDt = DateTime.Now;
scMentoringTotalReport.Status = "N";
//신규파일정보저장 및 파일업로드
if (files != null)
{
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Mentoring_Total.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scMentoringTrFileInfo = new ScMentoringTrFileInfo { ScFileInfo = scFileInfo };
scMentoringTrFileInfo.Classify = "A";
scMentoringTotalReport.ScMentoringTrFileInfoes.Add(scMentoringTrFileInfo);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
int result = await _scMentoringTotalReportService.AddScMentoringTotalReportAsync(scMentoringTotalReport);
if (result != -1)
return RedirectToAction("MentoringTotalReportList", "MentoringReport");
else
{
ModelState.AddModelError("", "자료요청 등록 실패.");
return View(dataRequestViewModel);
}
}
ModelState.AddModelError("", "입력값 검증 실패.");
return View(dataRequestViewModel);
}
public async Task <ActionResult> RegMentoringReport(MentoringReportViewModel dataRequestViewModel, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.naviLeftMenu = Global.MentoringReport;
var mentorId = Session[Global.LoginID].ToString();
SqlParameter loginId = new SqlParameter("LOGIN_ID", Session[Global.LoginID]); // sql 파라미터 값 설정
object[] parameters = new object[] { loginId }; // 객체에 데이터 삽입
var obj = await procMngService.getCompMapping(parameters); // 해당 기업과 관련된 리스트데이터 가져오기
var usrViews = Mapper.Map <List <MentoringReportViewModel> >(obj);
//if (ModelState.IsValid)
//{
var scMentoringReport = Mapper.Map <ScMentoringReport>(dataRequestViewModel);
//var comp = usrViews[0].CompSn;
scMentoringReport.MentorId = mentorId;
scMentoringReport.RegId = mentorId;
scMentoringReport.RegDt = DateTime.Now;
scMentoringReport.Status = "N";
scMentoringReport.CompSn = scMentoringReport.CompSn;
var compInfo = await _vcCompInfoService.getVcCompInfoByCompSn(scMentoringReport.CompSn ?? default(int));
// ConCode, NumSn, SubNumSn 자동 할당
// MentorId로 해당 기업의 num_sn, sub_num_sn을 가져온다
SqlParameter compSn2 = new SqlParameter("COMP_SN", scMentoringReport.CompSn);
SqlParameter loginId2 = new SqlParameter("LOGIN_ID", Session[Global.LoginID].ToString());
object[] parameters2 = new object[] { compSn2, loginId2 };
var compList = await procMngService.getMentorCompNumSn(parameters2);
var mentorLoginKey = Session[Global.LoginID].ToString();
var mentorInfo = await _vcUsrService.getMentorInfoById(mentorLoginKey);
var baSn = mentorInfo.BaSn;
//var conCodeInfo = await _vcMentorMappingService.getConcodeInfo(dataRequestViewModel.CompSn, baSn, mentorInfo.MentorSn, compList[0].NUM_SN, compList[0].SUB_NUM_SN);
scMentoringReport.NumSn = compList[0].NUM_SN;
scMentoringReport.SubNumSn = compList[0].SUB_NUM_SN;
scMentoringReport.ConCode = compList[0].CON_CODE;
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
//var compSn = usrViews[cnt].CompSn;
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Mentoring_Report.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var tcmsLoginKey = Session[Global.LoginID].ToString();
var tcmsLoginKeyCon = int.Parse(tcmsLoginKey);
var mentorUsrInfo = await _vcUsrService.getUsrInfoByTcmsKey(tcmsLoginKeyCon);
var mentorIdInfo = mentorUsrInfo.LoginId;
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = mentorIdInfo, RegDt = DateTime.Now
};
var scMentoringFileInfo = new ScMentoringFileInfo {
ScFileInfo = scFileInfo
};
//파일타입에 따라 재정의해서 넣어야 함(첨부파일, 사진)
scMentoringFileInfo.Classify = fileHelper.HasImageFile(file) ? "P" : "A";
scMentoringReport.RegId = mentorIdInfo;
scMentoringReport.MentorId = mentorIdInfo;
scMentoringReport.ScMentoringFileInfoes.Add(scMentoringFileInfo);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
int result = await _scMentoringReportService.AddScMentoringReportAsync(scMentoringReport);
if (result != -1)
{
return(RedirectToAction("MentoringReportList", "MentoringReport"));
}
else
{
ModelState.AddModelError("", "자료요청 등록 실패.");
return(View(dataRequestViewModel));
}
// }
//ModelState.AddModelError("", "입력값 검증 실패.");
//return View(dataRequestViewModel);
}
public async Task <ActionResult> ModifyMentoringReport(MentoringReportViewModel dataRequestViewModel, string deleteFileSns, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MentoringReport;
var mentorId = Session[Global.LoginID].ToString();
if (ModelState.IsValid)
{
var scMentoringReport = await _scMentoringReportService.GetMentoringReportById(dataRequestViewModel.ReportSn);
scMentoringReport.Attendee = dataRequestViewModel.Attendee;
scMentoringReport.BizWorkSn = dataRequestViewModel.BizWorkSn;
scMentoringReport.CompSn = dataRequestViewModel.CompSn;
scMentoringReport.MentorAreaCd = dataRequestViewModel.MentorAreaCd;
scMentoringReport.MentoringContents = dataRequestViewModel.MentoringContents;
scMentoringReport.MentoringDt = dataRequestViewModel.MentoringDt;
scMentoringReport.MentoringEdHr = dataRequestViewModel.MentoringEdHr;
scMentoringReport.MentoringPlace = dataRequestViewModel.MentoringPlace;
scMentoringReport.MentoringStHr = dataRequestViewModel.MentoringStHr;
scMentoringReport.MentoringSubject = dataRequestViewModel.MentoringSubject;
scMentoringReport.SubmitDt = dataRequestViewModel.SubmitDt;
scMentoringReport.UpdId = mentorId;
scMentoringReport.UpdDt = DateTime.Now;
//삭제파일 상태 업데이트
if (!string.IsNullOrEmpty(deleteFileSns.Trim()))
{
foreach (var deleteFileSn in deleteFileSns.Split(',').AsEnumerable())
{
scMentoringReport.ScMentoringFileInfoes.Select(mtfi => mtfi.ScFileInfo).Where(fi => fi.FileSn == int.Parse(deleteFileSn)).FirstOrDefault().Status = "D";
}
}
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Mentoring_Report.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scMentoringFileInfo = new ScMentoringFileInfo {
ScFileInfo = scFileInfo
};
//파일타입에 따라 재정의해서 넣어야 함(첨부파일, 사진)
scMentoringFileInfo.Classify = fileHelper.HasImageFile(file) ? "P" : "A";
scMentoringReport.ScMentoringFileInfoes.Add(scMentoringFileInfo);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//수정
await _scMentoringReportService.ModifyScMentoringReportAsync(scMentoringReport);
return(RedirectToAction("MentoringReportList", "MentoringReport"));
}
ModelState.AddModelError("", "입력값 검증 실패.");
return(View(dataRequestViewModel));
}
public void ModifyFileInfo(ScFileInfo scFileInfo)
{
scFileInfoRepository.Update(scFileInfo);
}
public async Task<ActionResult> RegManual(ManualViewModel manualViewModel, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.Cs;
var scForm =
Mapper.Map<ScForm>(manualViewModel);
scForm.Status = "N";
scForm.RegDt = DateTime.Now;
scForm.RegId = Session[Global.LoginID].ToString();
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Manual.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scFormFile = new ScFormFile { ScFileInfo = scFileInfo };
scForm.ScFormFiles.Add(scFormFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
int result = await _scFormService.AddScFormAsync(scForm);
if (result != -1)
return RedirectToAction("Manual", "Cs");
else
{
ModelState.AddModelError("", "메뉴얼 등록 실패.");
return View(manualViewModel);
}
}
public async Task <ActionResult> ModifyMyInfo(JoinExpertViewModel joinExpertViewModel, string DeleteFileSn, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MyInfo;
var scExpertMapping = await _scExpertMappingService.GetExpertAsync(Session[Global.LoginID].ToString());
scExpertMapping.ScUsr.UsrTypeDetail = joinExpertViewModel.UsrTypeDetail;
scExpertMapping.ScUsr.Name = joinExpertViewModel.Name;
scExpertMapping.ScUsr.TelNo = joinExpertViewModel.TelNo1 + "-" + joinExpertViewModel.TelNo2 + "-" + joinExpertViewModel.TelNo3;
scExpertMapping.ScUsr.MbNo = joinExpertViewModel.MbNo1 + "-" + joinExpertViewModel.MbNo2 + "-" + joinExpertViewModel.MbNo3;
scExpertMapping.ScUsr.Email = joinExpertViewModel.Email1 + "@" + joinExpertViewModel.Email2;
scExpertMapping.ScUsr.ScCompInfo.CompNm = joinExpertViewModel.CompNm;
scExpertMapping.ScUsr.ScCompInfo.OwnNm = joinExpertViewModel.ComOwnNm;
scExpertMapping.ScUsr.ScCompInfo.RegistrationNo = joinExpertViewModel.ComRegistrationNo;
scExpertMapping.ScUsr.ScCompInfo.TelNo = joinExpertViewModel.ComTelNo1 + "-" + joinExpertViewModel.ComTelNo2 + "-" + joinExpertViewModel.ComTelNo3;
scExpertMapping.ScUsr.ScCompInfo.PostNo = joinExpertViewModel.ComPostNo;
scExpertMapping.ScUsr.ScCompInfo.Addr1 = joinExpertViewModel.ComAddr1;
scExpertMapping.ScUsr.ScCompInfo.Addr2 = joinExpertViewModel.ComAddr2;
//업종 , 종목
int compSn = int.Parse(Session[Global.CompSN].ToString());
if (joinExpertViewModel.BizTypes.Count > 0)
{
_scBizTypeService.DeleteScBizTypeByCompSn(compSn);
foreach (var item in joinExpertViewModel.BizTypes)
{
var scBizType = new ScBizType
{
CompSn = compSn,
BizTypeCd = item.BizTypeCd,
BizTypeNm = item.BizTypeNm
};
_scBizTypeService.AddScBizType(scBizType);
}
}
//파일정보 업데이트
if (!string.IsNullOrEmpty(DeleteFileSn))
{
scExpertMapping.ScUsr.ScUsrResume.ScFileInfo.Status = "D";
}
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Resume.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scUsrResume = new ScUsrResume {
ScFileInfo = scFileInfo
};
scExpertMapping.ScUsr.ScUsrResume = scUsrResume;
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
int result = await _scExpertMappingService.SaveDbContextAsync();
if (result != -1)
{
return(RedirectToAction("MyInfo", "Main"));
}
else
{
ModelState.AddModelError("", "내정보 수정 실패.");
var usrView =
Mapper.Map <JoinExpertViewModel>(scExpertMapping);
return(View(usrView));
}
}
public async Task<ActionResult> ModifyMyInfo(MentorMyInfoViewModel mentorViewModel, ModifyMentorParamModel param, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MyInfo;
ScUsr scUsr = await _scUsrService.SelectMentorInfo(Session[Global.LoginID].ToString());
if (Session[Global.LoginID].ToString() != param.LoginIdChk)
{
mentorViewModel =
Mapper.Map<MentorMyInfoViewModel>(scUsr);
ModelState.AddModelError("", "로그인된 아이디가 아닙니다.");
return View(mentorViewModel);
}
//실제패스워드와 입력패스워드 비교
SHACryptography sha2 = new SHACryptography();
if (param.LoginPwChk != sha2.EncryptString(mentorViewModel.LoginPw))
{
mentorViewModel =
Mapper.Map<MentorMyInfoViewModel>(scUsr);
ModelState.AddModelError("", "비밀번호가 일치하지 않습니다.");
return View(mentorViewModel);
}
scUsr.AccountNo = mentorViewModel.AccountNo;
scUsr.Addr1 = mentorViewModel.Addr1;
scUsr.Addr2 = mentorViewModel.Addr2;
scUsr.BankNm = mentorViewModel.BankNm;
scUsr.Email = mentorViewModel.Email1 + "@" + mentorViewModel.Email2;
scUsr.FaxNo = mentorViewModel.FaxNo1 + "-" + mentorViewModel.FaxNo2 + "-" + mentorViewModel.FaxNo3;
scUsr.MbNo = mentorViewModel.MbNo1 + "-" + mentorViewModel.MbNo2 + "-" + mentorViewModel.MbNo3;
scUsr.Name = mentorViewModel.Name;
scUsr.PostNo = mentorViewModel.PostNo;
scUsr.TelNo = mentorViewModel.TelNo1 + "-" + mentorViewModel.TelNo2 + "-" + mentorViewModel.TelNo3;
scUsr.UsrTypeDetail = mentorViewModel.UsrTypeDetail;
//_scUsrService.ModifyScUsr(scUsr);
//파일정보 업데이트
if (!string.IsNullOrEmpty(param.DeleteFileSn))
{
scUsr.ScUsrResume.ScFileInfo.Status = "D";
}
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if(file !=null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Resume.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = param.LoginIdChk, RegDt = DateTime.Now };
var scUsrResume = new ScUsrResume { ScFileInfo = scFileInfo };
scUsr.ScUsrResume = scUsrResume;
//_scUsrService.ModifyMentorInfo(scUsr);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
_scUsrService.ModifyScUsr(scUsr);
//다성공시 커밋
await _scUsrService.SaveDbContextAsync();
return RedirectToAction("MyInfo", "Main");
}
public async Task <ActionResult> RegMentoringTotalReport(MentoringTotalReportViewModel dataRequestViewModel, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MentoringReport;
var mentorId = Session[Global.LoginID].ToString();
if (ModelState.IsValid)
{
var scMentoringTotalReport = Mapper.Map <ScMentoringTotalReport>(dataRequestViewModel);
scMentoringTotalReport.MentorId = mentorId;
scMentoringTotalReport.RegId = mentorId;
scMentoringTotalReport.RegDt = DateTime.Now;
scMentoringTotalReport.Status = "N";
//신규파일정보저장 및 파일업로드
if (files != null)
{
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Mentoring_Total.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now
};
var scMentoringTrFileInfo = new ScMentoringTrFileInfo {
ScFileInfo = scFileInfo
};
scMentoringTrFileInfo.Classify = "A";
scMentoringTotalReport.ScMentoringTrFileInfoes.Add(scMentoringTrFileInfo);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
int result = await _scMentoringTotalReportService.AddScMentoringTotalReportAsync(scMentoringTotalReport);
if (result != -1)
{
return(RedirectToAction("MentoringTotalReportList", "MentoringReport"));
}
else
{
ModelState.AddModelError("", "자료요청 등록 실패.");
return(View(dataRequestViewModel));
}
}
ModelState.AddModelError("", "입력값 검증 실패.");
return(View(dataRequestViewModel));
}
public void ModifyFileInfo(ScFileInfo scFileInfo)
{
scFileInfoRepository.Update(scFileInfo);
}
public async Task<ActionResult> ModifyManual(ManualDetailViewModel manualDetailViewModel, string deleteFileSns, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.Cs;
var scForm = await _scFormService.GetScFormAsync(manualDetailViewModel.Manual.FormSn);
scForm.FormType = manualDetailViewModel.Manual.FormType;
scForm.Subject = manualDetailViewModel.Manual.Subject;
scForm.Contents = manualDetailViewModel.Manual.Contents;
scForm.UpdDt = DateTime.Now;
scForm.UpdId = Session[Global.LoginID].ToString();
//삭제파일 상태 업데이트
if (!string.IsNullOrEmpty(deleteFileSns.Trim()))
{
foreach (var deleteFileSn in deleteFileSns.Split(',').AsEnumerable())
{
scForm.ScFormFiles.Select(fi => fi.ScFileInfo).Where(fi => fi.FileSn == int.Parse(deleteFileSn)).FirstOrDefault().Status = "D";
}
}
//첨부파일
if (files != null)
{
var fileHelper = new FileHelper();
foreach (var file in files)
{
if (file != null)
{
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Manual.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scFormFile = new ScFormFile { ScFileInfo = scFileInfo };
scForm.ScFormFiles.Add(scFormFile);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
}
//저장
await _scFormService.ModifyScFormAsync(scForm);
return RedirectToAction("Manual", "Cs");
}
public async Task <ActionResult> ModifyMyInfo(MentorMyInfoViewModel mentorViewModel, ModifyMentorParamModel param, IEnumerable <HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MyInfo;
ScUsr scUsr = await _scUsrService.SelectMentorInfo(Session[Global.LoginID].ToString());
if (Session[Global.LoginID].ToString() != param.LoginIdChk)
{
mentorViewModel =
Mapper.Map <MentorMyInfoViewModel>(scUsr);
ModelState.AddModelError("", "로그인된 아이디가 아닙니다.");
return(View(mentorViewModel));
}
//실제패스워드와 입력패스워드 비교
SHACryptography sha2 = new SHACryptography();
if (param.LoginPwChk != sha2.EncryptString(mentorViewModel.LoginPw))
{
mentorViewModel =
Mapper.Map <MentorMyInfoViewModel>(scUsr);
ModelState.AddModelError("", "비밀번호가 일치하지 않습니다.");
return(View(mentorViewModel));
}
scUsr.AccountNo = mentorViewModel.AccountNo;
scUsr.Addr1 = mentorViewModel.Addr1;
scUsr.Addr2 = mentorViewModel.Addr2;
scUsr.BankNm = mentorViewModel.BankNm;
scUsr.Email = mentorViewModel.Email1 + "@" + mentorViewModel.Email2;
scUsr.FaxNo = mentorViewModel.FaxNo1 + "-" + mentorViewModel.FaxNo2 + "-" + mentorViewModel.FaxNo3;
scUsr.MbNo = mentorViewModel.MbNo1 + "-" + mentorViewModel.MbNo2 + "-" + mentorViewModel.MbNo3;
scUsr.Name = mentorViewModel.Name;
scUsr.PostNo = mentorViewModel.PostNo;
scUsr.TelNo = mentorViewModel.TelNo1 + "-" + mentorViewModel.TelNo2 + "-" + mentorViewModel.TelNo3;
scUsr.UsrTypeDetail = mentorViewModel.UsrTypeDetail;
//_scUsrService.ModifyScUsr(scUsr);
//파일정보 업데이트
if (!string.IsNullOrEmpty(param.DeleteFileSn))
{
scUsr.ScUsrResume.ScFileInfo.Status = "D";
}
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Resume.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo {
FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = param.LoginIdChk, RegDt = DateTime.Now
};
var scUsrResume = new ScUsrResume {
ScFileInfo = scFileInfo
};
scUsr.ScUsrResume = scUsrResume;
//_scUsrService.ModifyMentorInfo(scUsr);
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
_scUsrService.ModifyScUsr(scUsr);
//다성공시 커밋
await _scUsrService.SaveDbContextAsync();
return(RedirectToAction("MyInfo", "Main"));
}
public async Task<ActionResult> ModifyMyInfo(JoinExpertViewModel joinExpertViewModel, string DeleteFileSn, IEnumerable<HttpPostedFileBase> files)
{
ViewBag.LeftMenu = Global.MyInfo;
var scExpertMapping = await _scExpertMappingService.GetExpertAsync(Session[Global.LoginID].ToString());
scExpertMapping.ScUsr.UsrTypeDetail = joinExpertViewModel.UsrTypeDetail;
scExpertMapping.ScUsr.Name = joinExpertViewModel.Name;
scExpertMapping.ScUsr.TelNo = joinExpertViewModel.TelNo1+"-"+ joinExpertViewModel.TelNo2 + "-" + joinExpertViewModel.TelNo3;
scExpertMapping.ScUsr.MbNo = joinExpertViewModel.MbNo1 + "-" + joinExpertViewModel.MbNo2 + "-" + joinExpertViewModel.MbNo3;
scExpertMapping.ScUsr.Email = joinExpertViewModel.Email1 + "@" + joinExpertViewModel.Email2;
scExpertMapping.ScUsr.ScCompInfo.CompNm = joinExpertViewModel.CompNm;
scExpertMapping.ScUsr.ScCompInfo.OwnNm = joinExpertViewModel.ComOwnNm;
scExpertMapping.ScUsr.ScCompInfo.RegistrationNo = joinExpertViewModel.ComRegistrationNo;
scExpertMapping.ScUsr.ScCompInfo.TelNo = joinExpertViewModel.ComTelNo1 + "-" + joinExpertViewModel.ComTelNo2 + "-" + joinExpertViewModel.ComTelNo3;
scExpertMapping.ScUsr.ScCompInfo.PostNo = joinExpertViewModel.ComPostNo;
scExpertMapping.ScUsr.ScCompInfo.Addr1 = joinExpertViewModel.ComAddr1;
scExpertMapping.ScUsr.ScCompInfo.Addr2 = joinExpertViewModel.ComAddr2;
//업종 , 종목
int compSn = int.Parse(Session[Global.CompSN].ToString());
if (joinExpertViewModel.BizTypes.Count > 0)
{
_scBizTypeService.DeleteScBizTypeByCompSn(compSn);
foreach (var item in joinExpertViewModel.BizTypes)
{
var scBizType = new ScBizType
{
CompSn = compSn,
BizTypeCd = item.BizTypeCd,
BizTypeNm = item.BizTypeNm
};
_scBizTypeService.AddScBizType(scBizType);
}
}
//파일정보 업데이트
if (!string.IsNullOrEmpty(DeleteFileSn))
{
scExpertMapping.ScUsr.ScUsrResume.ScFileInfo.Status = "D";
}
//신규파일정보저장 및 파일업로드
foreach (var file in files)
{
if (file != null)
{
var fileHelper = new FileHelper();
var savedFileName = fileHelper.GetUploadFileName(file);
var subDirectoryPath = Path.Combine(FileType.Resume.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString());
var savedFilePath = Path.Combine(subDirectoryPath, savedFileName);
var scFileInfo = new ScFileInfo { FileNm = Path.GetFileName(file.FileName), FilePath = savedFilePath, Status = "N", RegId = Session[Global.LoginID].ToString(), RegDt = DateTime.Now };
var scUsrResume = new ScUsrResume { ScFileInfo = scFileInfo };
scExpertMapping.ScUsr.ScUsrResume = scUsrResume;
await fileHelper.UploadFile(file, subDirectoryPath, savedFileName);
}
}
int result = await _scExpertMappingService.SaveDbContextAsync();
if (result != -1)
return RedirectToAction("MyInfo", "Main");
else
{
ModelState.AddModelError("", "내정보 수정 실패.");
var usrView =
Mapper.Map<JoinExpertViewModel>(scExpertMapping);
return View(usrView);
}
}
