public void TestSelect_PaymentRequestLicense_From_MockData() { String zipName = "TestZip6"; DirectoryInfo zipFolder = CreateDirectory(Path.Combine(_netDrive, _oicPath), zipName, 0); //ดึงข้อมูลการเงินจากธนาคารใน Temp ตาม BatchID IEnumerable <AG_IAS_PAYMENT_G_T> paymentGTs = GetPaymentGTs(); foreach (AG_IAS_PAYMENT_G_T paymentGT in paymentGTs) { //หาข้อมูลที่ Sub Payment Head IEnumerable <AG_IAS_SUBPAYMENT_H_T> subPaymentHTs = GetSubPaymentHead(paymentGT); foreach (AG_IAS_SUBPAYMENT_H_T SubPaymentHT in subPaymentHTs) { IEnumerable <AG_IAS_SUBPAYMENT_D_T> subPaymentDTs = GetSubPaymentDetails(SubPaymentHT); foreach (AG_IAS_SUBPAYMENT_D_T subPaymentDT in subPaymentDTs) { AG_IAS_LICENSE_D licenD = LicenseDs.SingleOrDefault(w => w.UPLOAD_GROUP_NO == subPaymentDT.UPLOAD_GROUP_NO && w.SEQ_NO == subPaymentDT.SEQ_NO); AG_IAS_LICENSE_H licenH = LicenseHs.Single(w => w.UPLOAD_GROUP_NO == licenD.UPLOAD_GROUP_NO); AG_IAS_LICENSE_TYPE_R licenType = LicenseTypeRs.Single(l => l.LICENSE_TYPE_CODE == subPaymentDT.LICENSE_TYPE_CODE); AG_IAS_ATTACH_FILE_LICENSE attach = AttachLicenses.Single(a => a.ID_CARD_NO == licenD.ID_CARD_NO && a.GROUP_LICENSE_ID == licenD.UPLOAD_GROUP_NO && a.ATTACH_FILE_PATH.EndsWith("03.jpg")); AddLicenseRequest(zipFolder, SubPaymentHT, subPaymentDT, licenD, licenH, licenType, attach); } } } using (ZipFile zip = new ZipFile()) { zip.AddDirectory(zipFolder.FullName); // recurses subdirectories zip.Save(zipFolder.FullName + ".zip"); } }
private static LicenseFileHeader CreateLicenseFileHeader(IAS.DAL.Interfaces.IIASPersonEntities ctx, LicenseFileHeader header, String lineData, CompressFileDetail compress, string approveCom) { String[] rowDatas = lineData.Split(','); String licenseTypeCode = GetDataField(rowDatas, 3); // AG_IAS_APPROVE_DOC_TYPE comp = ctx.AG_IAS_APPROVE_DOC_TYPE.Where(w => w.APPROVE_DOC_TYPE == licenseTypeCode && w.ITEM_VALUE == "Y").FirstOrDefault(); header.IMPORT_DATETIME = DateTime.Now; header.LICENSE_TYPE_CODE = licenseTypeCode; header.COMP_CODE = GetDataField(rowDatas, 1); header.COMP_NAME = GetDataField(rowDatas, 2); header.LICENSE_TYPE = licenseTypeCode; header.SEND_DATE = LicenseFileHelper.PhaseToDate(GetDataField(rowDatas, 4)); header.TOTAL_AGENT = LicenseFileHelper.PhaseToAmount(GetDataField(rowDatas, 5)); header.TOTAL_FEE = LicenseFileHelper.PhaseToMoney(GetDataField(rowDatas, 6)); header.ERR_MSG = ""; if (string.IsNullOrEmpty(approveCom)) { approveCom = null; } header.APPROVE_COMPCODE = approveCom == null ? null : approveCom; AG_IAS_PETITION_TYPE_R petitionType = ctx.AG_IAS_PETITION_TYPE_R.SingleOrDefault(a => a.PETITION_TYPE_CODE == header.PettitionTypeCodeRequest); header.PetitionTypeR = petitionType; AG_IAS_LICENSE_TYPE_R licenseType = ctx.AG_IAS_LICENSE_TYPE_R.SingleOrDefault(a => a.LICENSE_TYPE_CODE == header.LicenseTypeCodeRequest); header.LicenseTypeR = licenseType; header.CompressFileDetail = compress; return(header); }
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); //} }
private static void AddLicenseRequest(IAS.DAL.Interfaces.IIASPersonEntities ctx, String _netDrive, DirectoryInfo zipFolder, AG_IAS_SUBPAYMENT_H_T SubPaymentHT, AG_IAS_SUBPAYMENT_D_T subPaymentDT, AG_IAS_LICENSE_D licenD, AG_IAS_LICENSE_H licenH, AG_IAS_LICENSE_TYPE_R licenType, AG_IAS_ATTACH_FILE_LICENSE attach) { String filePath = String.Format(@"{0}\{1}\{2}\{3}", zipFolder.FullName, ((String.IsNullOrEmpty(licenH.COMP_CODE))?"0000": licenH.COMP_CODE), SubPaymentHT.PETITION_TYPE_CODE, licenType.LICENSE_TYPE_CODE); DirectoryInfo dirInfo = new DirectoryInfo(Path.Combine(_netDrive, filePath)); if (!dirInfo.Exists) { dirInfo.Create(); } FileInfo fileInfo = new FileInfo(Path.Combine(dirInfo.FullName, "1.txt")); if (!fileInfo.Exists) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(fileInfo.FullName, true, Encoding.GetEncoding(874))) { file.WriteLine("ชื่อรูป,เลขที่ใบอนุญาต,เลขบัตรประชาชน,ชื่อ,สกุล,วันที่ออกใบอนุญาต,วันที่หมดอายุ,บริษัท,ประเภทใบอนุญาต,"); } } using (System.IO.StreamWriter file = new System.IO.StreamWriter(fileInfo.FullName, true, Encoding.GetEncoding(874))) { file.WriteLine(String.Format("{0},{1},{2},{3},{4},\"{5}\",\"{6}\",{7},{8},", subPaymentDT.ID_CARD_NO, WordSpacing(subPaymentDT.LICENSE_NO), WordSpacing(subPaymentDT.ID_CARD_NO), String.Format("{0} {1}", licenD.TITLE_NAME, licenD.NAMES), licenD.LASTNAME, ((DateTime)licenD.LICENSE_DATE).ToString("dd/MM/yyy", CultureInfo.CreateSpecificCulture("th-TH")), ((DateTime)licenD.LICENSE_EXPIRE_DATE).ToString("dd/MM/yyy", CultureInfo.CreateSpecificCulture("th-TH")), licenH.COMP_NAME, licenType.LICENSE_TYPE_NAME)); } Int32 start = attach.ATTACH_FILE_PATH.LastIndexOf('.'); Int32 len = attach.ATTACH_FILE_PATH.Length; String extension = attach.ATTACH_FILE_PATH.Substring(attach.ATTACH_FILE_PATH.LastIndexOf('.'), len - start); MoveFileResponse response = FileManagerService.RemoteFileCommand(new MoveFileRequest() { CurrentContainer = "", CurrentFileName = attach.ATTACH_FILE_PATH, TargetContainer = String.Format(@"{0}\{1}", dirInfo.FullName.Replace(_netDrive, ""), "images"), TargetFileName = String.Format("{0}{1}", licenD.ID_CARD_NO, extension) }).Action(); if (response.Code != "0000") { throw new ApplicationException(response.Message); } }
public static String StartCompressByPayment(IAS.DAL.Interfaces.IIASPersonEntities ctx, DateTime findDate, String userName, String zipName) { string _netDrive = ConfigurationManager.AppSettings["DEFAULT_NET_DRIVE"]; string _userNetDrive = ConfigurationManager.AppSettings["USER_NET_DRIVE"]; string _passNetDrive = ConfigurationManager.AppSettings["PASS_NET_DRIVE"]; String _compressPath = ConfigurationManager.AppSettings["COMPRESS_FOLDER"].ToString(); String imageTypeCode = ConfigurationManager.AppSettings["CODE_ATTACH_PHOTO"].ToString(); NASDrive nasDrive; nasDrive = new NASDrive(_netDrive, _userNetDrive, _passNetDrive); // กำหนด รหัส TypeImage สำหรับค้นหา Boolean IsNotCreateFolder = true; DirectoryInfo zipFolder = null; //ดึงข้อมูลการเงินจากธนาคารใน Temp ตาม BatchID IEnumerable <AG_IAS_PAYMENT_G_T> paymentGTs = GetPaymentGTs(ctx, findDate); foreach (AG_IAS_PAYMENT_G_T paymentGT in paymentGTs) { //หาข้อมูลที่ Sub Payment Head IEnumerable <AG_IAS_SUBPAYMENT_H_T> subPaymentHTs = GetSubPaymentHead(ctx, paymentGT); foreach (AG_IAS_SUBPAYMENT_H_T SubPaymentHT in subPaymentHTs) { IEnumerable <AG_IAS_SUBPAYMENT_D_T> subPaymentDTs = GetSubPaymentDetails(ctx, SubPaymentHT); foreach (AG_IAS_SUBPAYMENT_D_T subPaymentDT in subPaymentDTs) // milk มาทำ เพิ่ม if else กันกรณีหลุด ไม่มีค่าแล้วเป็นข้อความ error { if ((subPaymentDT.UPLOAD_GROUP_NO != null) && (subPaymentDT.SEQ_NO != null)) { AG_IAS_LICENSE_D licenD = ctx.AG_IAS_LICENSE_D.SingleOrDefault(w => w.UPLOAD_GROUP_NO == subPaymentDT.UPLOAD_GROUP_NO && w.SEQ_NO == subPaymentDT.SEQ_NO); AG_IAS_LICENSE_H licenH = ctx.AG_IAS_LICENSE_H.Single(w => w.UPLOAD_GROUP_NO == licenD.UPLOAD_GROUP_NO); if (subPaymentDT.LICENSE_TYPE_CODE != null) { if (licenD.OIC_APPROVED_BY != null) { String whereType = String.Format("_{0}.", imageTypeCode); AG_IAS_LICENSE_TYPE_R licenType = ctx.AG_IAS_LICENSE_TYPE_R.Single(l => l.LICENSE_TYPE_CODE == subPaymentDT.LICENSE_TYPE_CODE); AG_IAS_ATTACH_FILE_LICENSE attach = ctx.AG_IAS_ATTACH_FILE_LICENSE.SingleOrDefault(a => a.ID_CARD_NO == licenD.ID_CARD_NO && a.GROUP_LICENSE_ID == licenD.UPLOAD_GROUP_NO && a.ATTACH_FILE_PATH.Contains(whereType)); if (attach == null) { nasDrive.Dispose(); throw new ApplicationException(String.Format("ไม่พบ รูปสำหรับทำใบอนุญาติของ {0} {1} {2}", licenD.NAMES, licenD.LASTNAME, licenD.ID_CARD_NO)); } if (IsNotCreateFolder) { zipFolder = CreateDirectory(Path.Combine(_netDrive, _compressPath), (String.IsNullOrEmpty(zipName)) ? findDate.ToString("yyyy-MM-dd-hhmmss") : zipName, 0); IsNotCreateFolder = false; } AddLicenseRequest(ctx, _netDrive, zipFolder, SubPaymentHT, subPaymentDT, licenD, licenH, licenType, attach); } } else { throw new ApplicationException(String.Format("ไม่พบประเภทใบอนุญาตของ {0}{1} {2} {3}", licenD.TITLE_NAME, licenD.NAMES, licenD.LASTNAME, licenD.ID_CARD_NO)); } } else { throw new ApplicationException(String.Format("ไม่พบเลขอ้างอิงในการอัพโหลดเอกสารของ หมายเลขบัตรประชาชน {0} ", subPaymentDT.ID_CARD_NO)); } } } } String zipfileName = ""; if (!IsNotCreateFolder) { using (ZipFile zip = new ZipFile()) { zip.AddDirectory(zipFolder.FullName); // recurses subdirectories zipfileName = zipFolder.FullName + ".zip"; zip.Save(zipfileName); zipfileName = zipfileName.Replace(_netDrive, ""); } } nasDrive.Dispose(); return(zipfileName); }
public static String StartCompressByOicApprove(IAS.DAL.Interfaces.IIASPersonEntities ctx, DateTime findDate, String userName, String zipName) { string _netDrive = ConfigurationManager.AppSettings["DEFAULT_NET_DRIVE"]; string _userNetDrive = ConfigurationManager.AppSettings["USER_NET_DRIVE"]; string _passNetDrive = ConfigurationManager.AppSettings["PASS_NET_DRIVE"]; String _compressPath = ConfigurationManager.AppSettings["COMPRESS_FOLDER"].ToString(); String imageTypeCode = ConfigurationManager.AppSettings["CODE_ATTACH_PHOTO"].ToString(); NASDrive nasDrive; nasDrive = new NASDrive(_netDrive, _userNetDrive, _passNetDrive); // กำหนด รหัส TypeImage สำหรับค้นหา Boolean IsNotCreateFolder = true; DirectoryInfo zipFolder = null; DateTime startDate = new DateTime(findDate.Year, findDate.Month, findDate.Day, 0, 0, 0); DateTime endDate = new DateTime(findDate.Year, findDate.Month, findDate.Day, 23, 59, 59); //ดึงข้อมูลการเงินจากธนาคารใน Temp ตาม BatchID IEnumerable <AG_IAS_LICENSE_D> licenseDs = ctx.AG_IAS_LICENSE_D. Where(a => a.OIC_APPROVED_DATE >= startDate && a.OIC_APPROVED_DATE <= endDate); foreach (AG_IAS_LICENSE_D licenD in licenseDs) // milk มาทำ เพิ่ม if else กันกรณีหลุด ไม่มีค่าแล้วเป็นข้อความ error { AG_IAS_LICENSE_H licenH = ctx.AG_IAS_LICENSE_H.Single(w => w.UPLOAD_GROUP_NO == licenD.UPLOAD_GROUP_NO); String whereType = String.Format("_{0}.", imageTypeCode); AG_IAS_LICENSE_TYPE_R licenType = ctx.AG_IAS_LICENSE_TYPE_R.Single(l => l.LICENSE_TYPE_CODE == licenH.LICENSE_TYPE_CODE); //AG_IAS_ATTACH_FILE_LICENSE attach = ctx.AG_IAS_ATTACH_FILE_LICENSE.SingleOrDefault(a => a.ID_CARD_NO == licenD.ID_CARD_NO // && a.GROUP_LICENSE_ID == licenD.UPLOAD_GROUP_NO // && a.ATTACH_FILE_PATH.Contains(whereType)); AG_IAS_ATTACH_FILE_LICENSE attach = Helpers.GetIASConfigHelper.GetAttachLicensePhoto(ctx, licenD.ID_CARD_NO, licenD.UPLOAD_GROUP_NO); if (attach == null) { nasDrive.Dispose(); throw new ApplicationException(String.Format("ไม่พบ รูปสำหรับทำใบอนุญาติของ {0} {1} {2}", licenD.NAMES, licenD.LASTNAME, licenD.ID_CARD_NO)); } if (IsNotCreateFolder) { zipFolder = CreateDirectory(Path.Combine(_netDrive, _compressPath), (String.IsNullOrEmpty(zipName)) ? findDate.ToString("yyyy-MM-dd-hhmmss") : zipName, 0); IsNotCreateFolder = false; } AddLicenseRequest(ctx, _netDrive, zipFolder, licenD, licenH, licenType, attach); } String zipfileName = ""; if (!IsNotCreateFolder) { using (ZipFile zip = new ZipFile()) { zip.AddDirectory(zipFolder.FullName); // recurses subdirectories zipfileName = zipFolder.FullName + ".zip"; zip.Save(zipfileName); zipfileName = zipfileName.Replace(_netDrive, ""); } } nasDrive.Dispose(); return(zipfileName); }
public void TestSelect_PaymentRequestLicense_From_DAL() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); IList <AG_IAS_LICENSE_H> _licenseHs = new List <AG_IAS_LICENSE_H>(); IList <AG_IAS_LICENSE_D> _licenseDs = new List <AG_IAS_LICENSE_D>(); _licenseTypeRs = ctx.AG_IAS_LICENSE_TYPE_R.ToList(); _petitionTypeRs = ctx.AG_IAS_PETITION_TYPE_R.ToList(); String zipName = "TestZip"; DirectoryInfo zipFolder = CreateDirectory(_netDrive, zipName, 0); //ดึงข้อมูลการเงินจากธนาคารใน Temp ตาม BatchID var paymentGTs = ctx.AG_IAS_PAYMENT_G_T.Where(f => f.STATUS == "P" && f.GROUP_REQUEST_NO == "999999561000000040") .ToList(); foreach (AG_IAS_PAYMENT_G_T paymentGT in paymentGTs) { //หาข้อมูลที่ Sub Payment Head //var subPaymentHTs = ctx.AG_IAS_SUBPAYMENT_H_T // .Where(w => w.GROUP_REQUEST_NO == paymentGT.GROUP_REQUEST_NO && // (w.STATUS != null && w.STATUS == "P")) // .ToList(); var subPaymentHTs = ctx.AG_IAS_SUBPAYMENT_H_T .Where(w => w.GROUP_REQUEST_NO == paymentGT.GROUP_REQUEST_NO && (w.STATUS != null && w.STATUS == "P") && ( w.PETITION_TYPE_CODE == "11" || w.PETITION_TYPE_CODE == "13" || w.PETITION_TYPE_CODE == "14" || w.PETITION_TYPE_CODE == "15" || w.PETITION_TYPE_CODE == "16" || w.PETITION_TYPE_CODE == "17" || w.PETITION_TYPE_CODE == "18" ) ).ToList(); foreach (AG_IAS_SUBPAYMENT_H_T SubPaymentHT in subPaymentHTs) { IEnumerable <AG_IAS_SUBPAYMENT_D_T> subPaymentDTs = ctx.AG_IAS_SUBPAYMENT_D_T.Where(w => w.HEAD_REQUEST_NO == SubPaymentHT.HEAD_REQUEST_NO && !String.IsNullOrEmpty(w.RECEIPT_NO)); foreach (AG_IAS_SUBPAYMENT_D_T subPaymentDT in subPaymentDTs) { AG_IAS_LICENSE_D licenD = ctx.AG_IAS_LICENSE_D.SingleOrDefault(w => w.UPLOAD_GROUP_NO == subPaymentDT.UPLOAD_GROUP_NO && w.SEQ_NO == subPaymentDT.SEQ_NO); AG_IAS_LICENSE_H licenH = ctx.AG_IAS_LICENSE_H.Single(w => w.UPLOAD_GROUP_NO == licenD.UPLOAD_GROUP_NO); AG_IAS_ATTACH_FILE_LICENSE attach = ctx.AG_IAS_ATTACH_FILE_LICENSE.Single(a => a.ID_CARD_NO == licenD.ID_CARD_NO && a.GROUP_LICENSE_ID == licenD.UPLOAD_GROUP_NO && a.ATTACH_FILE_PATH.EndsWith("03.jpg")); AG_IAS_LICENSE_TYPE_R licenType = LicenseTypeRs.Single(l => l.LICENSE_TYPE_CODE == subPaymentDT.LICENSE_TYPE_CODE); String filePath = String.Format(@"{0}\{1}\{2}", zipFolder.FullName, SubPaymentHT.PETITION_TYPE_CODE, licenType.LICENSE_TYPE_NAME); DirectoryInfo dirInfo = new DirectoryInfo(Path.Combine(_netDrive, filePath)); if (!dirInfo.Exists) { dirInfo.Create(); } FileInfo fileInfo = new FileInfo(Path.Combine(dirInfo.FullName, "1.txt")); if (!fileInfo.Exists) { using (System.IO.StreamWriter file = fileInfo.CreateText()) { file.WriteLine("ชื่อรูป,เลขที่ใบอนุญาต,เลขบัตรประชาชน,ชื่อ,สกุล,วันที่ออกใบอนุญาต,วันที่หมดอายุ,บริษัท,ประเภทใบอนุญาต,"); } } using (System.IO.StreamWriter file = fileInfo.AppendText()) { file.WriteLine(String.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},", subPaymentDT.ID_CARD_NO, WordSpacing(subPaymentDT.LICENSE_NO), WordSpacing(subPaymentDT.ID_CARD_NO), String.Format("{0} {1}", licenD.TITLE_NAME, licenD.NAMES), licenD.LASTNAME, ((DateTime)licenD.LICENSE_DATE).ToString("dd/MM/yyy", CultureInfo.CreateSpecificCulture("th-TH")), ((DateTime)licenD.LICENSE_EXPIRE_DATE).ToString("dd/MM/yyy", CultureInfo.CreateSpecificCulture("th-TH")), licenH.COMP_NAME, licenType.LICENSE_TYPE_NAME)); } } } } }