public static void LicensePetitionType(IAS.DAL.IASPersonEntities ctx, OracleConnection Connection, LicensePetitionType1314Request licenseRequest) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH"); var entLicenseD = ctx.AG_IAS_LICENSE_D.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); // entLicenseD.LICENSE_NO = LicenseNo; entLicenseD.LICENSE_DATE = DateTime.Now; entLicenseD.LICENSE_EXPIRE_DATE = licenseRequest.EXPIRATION_DATE; OracleCommand objCmd = new OracleCommand() { Connection = Connection, CommandText = "IAS_UPDATE_1314", CommandType = CommandType.StoredProcedure }; objCmd.Parameters.Add("P_LICENSE_NO", OracleDbType.Varchar2).Value = licenseRequest.LICENSE_NO; objCmd.Parameters.Add("P_EXPIRE_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; // Convert.ToDateTime(ReceiveDate); objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; // Convert.ToDateTime(ReceiveDate); objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = licenseRequest.RECEIPT_NO; // requestNo; objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = licenseRequest.PAYMENT_NO; objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = SetValue(licenseRequest.REQUEST_NO); objCmd.Parameters.Add("PV_CODE", OracleDbType.Varchar2).Value = licenseRequest.AREA; // area; objCmd.ExecuteNonQuery(); }
public ExamFileHeader(ExamFileHeaderRequest request) { _ctx = request.Context; UPLOAD_GROUP_NO = OracleDB.GetGenAutoId(); _createBy = request.UserProfile; ASSOCIATE_NAME = ExamSubStringHelper.Get(request.LineData, 1, 80).Trim(); LICENSE_TYPE_CODE = ExamSubStringHelper.Get(request.LineData, 81, 2).Trim(); PROVINCE_CODE = ExamSubStringHelper.Get(request.LineData, 83, 2).Trim(); ASSOCIATE_CODE = ExamSubStringHelper.Get(request.LineData, 85, 3).Trim(); TESTING_DATE = ExamSubStringHelper.Get(request.LineData, 88, 10).Trim(); EXAM_TIME_CODE = ExamSubStringHelper.Get(request.LineData, 98, 2).Trim(); CNT_PER = request.LineData.Length > 100 ? ExamSubStringHelper.Get(request.LineData, 100, request.LineData.Length).Trim():""; }
private static ExamFileHeader CreateExamFileHeader(IAS.DAL.IASPersonEntities ctx, DTO.ApplicantUploadRequest request) { String header = request.UploadData.Header; ExamFileHeaderRequest headRequest = new ExamFileHeaderRequest() { Context = ctx, FileName = request.FileName, UserProfile = request.UserProfile, LineData = request.UploadData.Header }; ExamFileHeader headerFile = new ExamFileHeader(headRequest); return(headerFile); }
private static ExamFileDetail CreateExamFileDetail(IAS.DAL.IASPersonEntities ctx, String rawData, Int32 rownum) { String[] data = rawData.Split('|'); ExamFileDetail detail = new ExamFileDetail(ctx) { SEQ_NO = rownum.ToString("0000"), SEAT_NO = data.GetIndexOf(1), ID_CARD_NO = data.GetIndexOf(2), TITLE = data.GetIndexOf(3), NAMES = data.GetIndexOf(4), LAST_NAME = data.GetIndexOf(5), ADDRESS1 = data.GetIndexOf(6), ADDRESS2 = data.GetIndexOf(7), AREA_CODE = data.GetIndexOf(8), BIRTH_DATE = data.GetIndexOf(9).String_dd_MM_yyyy_ToDate('/', true), SEX = data.GetIndexOf(10), EDUCATION_CODE = data.GetIndexOf(11), COMP_CODE = data.GetIndexOf(12), APPROVE_DATE = data.GetIndexOf(13).String_dd_MM_yyyy_ToDate('/', true), EXAM_RESULT = data.GetIndexOf(14), SCORE_1 = data.GetIndexOf(15), SCORE_2 = data.GetIndexOf(16), SCORE_3 = data.GetIndexOf(17), SCORE_4 = data.GetIndexOf(18), SCORE_5 = data.GetIndexOf(19), SCORE_6 = data.GetIndexOf(20), SCORE_7 = data.GetIndexOf(21), SCORE_8 = data.GetIndexOf(22), SCORE_9 = data.GetIndexOf(23), SCORE_10 = data.GetIndexOf(24), SCORE_11 = data.GetIndexOf(25), SCORE_12 = data.GetIndexOf(26), SCORE_13 = data.GetIndexOf(27), SCORE_14 = data.GetIndexOf(28), SCORE_15 = data.GetIndexOf(29), SCORE_16 = data.GetIndexOf(30), }; return(detail); }
public static DTO.ResponseService <ExamFileHeader> ConcreateApplicantFileRequest(IAS.DAL.IASPersonEntities ctx, DTO.ApplicantUploadRequest request) { DTO.ResponseService <ExamFileHeader> response = new DTO.ResponseService <ExamFileHeader>(); ExamFileHeader header = CreateExamFileHeader(ctx, request); Int32 row = 0; foreach (String record in request.UploadData.Body) { row++; ExamFileDetail detail = CreateExamFileDetail(ctx, record, row); header.AddDetail(detail); } response.DataResponse = header; return(response); }