private static ApplicantFileHeader CreateApplicantFileHeader(IAS.DAL.Interfaces.IIASPersonEntities ctx, DTO.ApplicantUploadRequest request) { String[] header = request.UploadData.Header.Split(','); ApplicantHeaderRequest headRequest = new ApplicantHeaderRequest() { Context = ctx, FileName = request.FileName, TestingNumber = request.TestingNo, ExamPlaceCode = request.ExamPlaceCode, UserProfile = request.UserProfile, LineData = header }; //ApplicantFileHeader headerFile = new ApplicantFileHeader(headRequest) // { // PROVINCE_CODE = header.GetIndexOf(1), // COMP_CODE = header.GetIndexOf(2), // LICENSE_TYPE_CODE = header.GetIndexOf(3), // TESTING_DATE = PhaseDateHelper.PhaseToDateNull(header.GetIndexOf(4)), // EXAM_APPLY = PhaseApplyAmountHelper.Phase(header.GetIndexOf(5)), // EXAM_AMOUNT = PhaseCurrencyAmount.Phase(header.GetIndexOf(6)), // TEST_TIME_CODE = header.GetIndexOf(7), // }; //IQueryable<AG_EXAM_LICENSE_R> examLicense = ctx.AG_EXAM_LICENSE_R.Where(w => request.TestingNo.Contains(w.TESTING_NO) && request.ExamPlaceCode.Contains(w.EXAM_PLACE_CODE)); var examLicense = ctx.AG_EXAM_LICENSE_R.Where(w => w.TESTING_NO == request.TestingNo && w.EXAM_PLACE_CODE == request.ExamPlaceCode).FirstOrDefault(); var exmPlace = ctx.AG_EXAM_PLACE_R.Where(w => w.EXAM_PLACE_CODE == examLicense.EXAM_PLACE_CODE).FirstOrDefault(); int examFee = ctx.AG_PETITION_TYPE_R.FirstOrDefault(s => s.PETITION_TYPE_CODE == "01").FEE.ToInt(); ApplicantFileHeader headerFile = new ApplicantFileHeader(headRequest) { PROVINCE_CODE = exmPlace.PROVINCE_CODE, COMP_CODE = string.IsNullOrEmpty(exmPlace.EXAM_PLACE_GROUP_CODE) ? exmPlace.ASSOCIATION_CODE : exmPlace.EXAM_PLACE_GROUP_CODE, LICENSE_TYPE_CODE = header.GetIndexOf(3), TESTING_DATE = examLicense.TESTING_DATE, EXAM_APPLY = PhaseApplyAmountHelper.Phase(header.GetIndexOf(5)), EXAM_AMOUNT = PhaseCurrencyAmount.Phase(header.GetIndexOf(5)) * examFee, TEST_TIME_CODE = examLicense.TEST_TIME_CODE, }; return(headerFile); }
public ApplicantFileHeader(ApplicantHeaderRequest request) { flagRoomExam = true; _applyDate = DateTime.Now; _ctx = request.Context; UPLOAD_GROUP_NO = OracleDB.GetGenAutoId(); SOURCE_TYPE = GetSourceType(request.UserProfile); _testingNumber = request.TestingNumber; _examPlaceCode = request.ExamPlaceCode; _createBy = request.UserProfile; PROVINCE_CODE = request.LineData.GetIndexOf(1); //EXAM_PLACE_CODE = request.LineData.GetIndexOf(1); COMP_CODE = request.LineData.GetIndexOf(2); LICENSE_TYPE_CODE = request.LineData.GetIndexOf(3); TESTING_DATE = PhaseDateHelper.PhaseToDate(request.LineData.GetIndexOf(4)); EXAM_APPLY = PhaseApplyAmountHelper.Phase(request.LineData.GetIndexOf(5)); EXAM_AMOUNT = PhaseCurrencyAmount.Phase(request.LineData.GetIndexOf(6)); TEST_TIME_CODE = request.LineData.GetIndexOf(7); FILENAME = request.FileName; this._examLicense = CTX.AG_EXAM_LICENSE_R.SingleOrDefault(w => w.TESTING_NO == _testingNumber && w.EXAM_PLACE_CODE == _examPlaceCode); this._examPlace = _ctx.AG_EXAM_PLACE_R.SingleOrDefault(w => w.EXAM_PLACE_CODE == _examPlaceCode); this._examTime = _ctx.AG_EXAM_TIME_R.SingleOrDefault(w => w.TEST_TIME_CODE == _examLicense.TEST_TIME_CODE); this._licenseType = _ctx.AG_IAS_LICENSE_TYPE_R.SingleOrDefault(w => w.LICENSE_TYPE_CODE == LICENSE_TYPE_CODE); //if (this.SourceFrom == DTO.RegistrationType.Association) //{ // //this._examLicense = _ctx.AG_EXAM_LICENSE_R.SingleOrDefault(e => e.EXAM_PLACE_CODE == _examPlaceCode // // && e.TESTING_DATE == _TestTingDate // // && e.TEST_TIME_CODE == _TestTimeCode // // && e.LICENSE_TYPE_CODE == _LicenseTypeCode); //} //else if (this.SourceFrom == DTO.RegistrationType.Insurance) //{ // //this._examLicense = _ctx.AG_EXAM_LICENSE_R.SingleOrDefault(e => e.TESTING_NO == _testingNumber && e.EXAM_PLACE_CODE == _examPlaceCode); //} }