public void CityBankTextFile_CanLoadFile_AndValidateData() { DTO.UploadData data = ReadDataFromFile(); IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); CityFileHeader header = BankFileFactory.ConcreateCityBankFileTransfer(ctx, "test.txt", data); Assert.IsNotNull(header); Assert.AreEqual(header.CityFileBoxHeaders.Count(), 3); Assert.AreEqual(header.CityFileOverFlows.Count(), 7); Assert.AreEqual(header.CityFileBatchHeaders.Count(), 6); Assert.AreEqual(header.CityFileDetails.Count(), 6); Assert.AreEqual(header.CityFileBatchTotals.Count(), 6); Assert.AreEqual(header.CityFileTotals.Count(), 3); Assert.AreEqual(header.CityFileTotals.ElementAt(0).CityFileDetails.Count(), 1); Assert.AreEqual(header.CityFileTotals.ElementAt(1).CityFileDetails.Count(), 3); Assert.AreEqual(header.CityFileTotals.ElementAt(2).CityFileDetails.Count(), 2); Int32 rownum = (1 + header.CityFileBoxHeaders.Count() + header.CityFileOverFlows.Count() + header.CityFileBatchHeaders.Count() + header.CityFileDetails.Count() + header.CityFileBatchTotals.Count() + header.CityFileTotals.Count() + 1); Assert.AreEqual(header.RowCount, rownum); DTO.UploadResult <DTO.SummaryBankTransaction, DTO.BankTransaction> uploadResult = header.ValidateData(); }
public void MailConfirmHelper_Can_send_mail_registration_toMember() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_REGISTRATION_T regis = ctx.AG_IAS_REGISTRATION_T.SingleOrDefault(a => a.EMAIL == "*****@*****.**"); MailConfirmHelper.SendMailConfirmRegistration(regis); }
public static byte[] CreateQRcode(string PDF_path, string UID) { ctx = DAL.DALFactory.GetPersonContext(); string ImgPath = @"OIC\QRCodeIASWebSite.jpg"; string _netDrive = ConfigurationManager.AppSettings["DEFAULT_NET_DRIVE"]; string _userNetDrive = ConfigurationManager.AppSettings["USER_NET_DRIVE"]; string _passNetDrive = ConfigurationManager.AppSettings["PASS_NET_DRIVE"]; byte[] buffer = null; using (NASDrive nasDrive = new NASDrive(_netDrive, _userNetDrive, _passNetDrive)) { Stream fileStream = new FileStream(_netDrive + "" + ImgPath, FileMode.Open); buffer = new Byte[fileStream.Length + 1]; BinaryReader br = new BinaryReader(fileStream); buffer = br.ReadBytes(Convert.ToInt32((fileStream.Length))); br.Close(); } return(buffer); //ReceiveNumber referanceNumber = new ReceiveNumber(_oicNumber, RunningNumber, DateTime.Now); //return referanceNumber; }
public void AddToAccountTest_Can_Default_Test() { try { IAS.DAL.Interfaces.IIASPersonEntities _ctx = DAL.DALFactory.GetPersonContext();; IAS.DAL.Interfaces.IIASFinanceEntities _ctxFin = DAL.DALFactory.GetFinanceContext(); using (var ts = new TransactionScope()) { OracleConnection Connection = new OracleConnection(ConfigurationManager .ConnectionStrings[ConnectionFor.OraDB_Finance.ToString()] .ToString()); Connection.Open(); BillBiz biz = new BillBiz(); AG_IAS_PAYMENT_G_T paymentG = _ctx.AG_IAS_PAYMENT_G_T.FirstOrDefault(); AG_IAS_SUBPAYMENT_D_T subd = _ctx.AG_IAS_SUBPAYMENT_D_T.FirstOrDefault(a => a.HEAD_REQUEST_NO == "130924165707249" && a.PAYMENT_NO == "0001"); //var res = biz.AddToAccount(ref _ctx, ref _ctxFin, ref Connection, subd,paymentG, "52-2-034", BankType.KTB, (Decimal)subd.AMOUNT); } } catch (Exception ex) { throw; } }
public static byte[] CreateQRcode(IAS.DAL.Interfaces.IIASPersonEntities ctx, CreateReceiptReqeust receipt) { byte[] qrcode = null; QRCodeEncoder encoder = new QRCodeEncoder(); StringBuilder data = new StringBuilder(""); data.AppendLine(String.Format("เลขที่ใบเสร็จ: {0}", receipt.RECEIPT_NO)); data.AppendLine(String.Format("ชื่อ: {0}", receipt.FIRSTNAME)); data.AppendLine(String.Format("จำนวนเงิน: {0}", receipt.AMOUNT.ToString("#,##0.00"))); data.AppendLine(String.Format("Code: {0}", receipt.LICENSE_TYPE_CODE)); string qrres = receipt.LinkRecipt(ctx); if (qrres.Contains("ไม่พบข้อมูล")) { return(null); } else { data.AppendLine(receipt.LinkRecipt(ctx)); Bitmap img = encoder.Encode(data.ToString(), System.Text.Encoding.UTF8); ImageConverter converter = new ImageConverter(); qrcode = (byte[])converter.ConvertTo(img, typeof(byte[])); } return(qrcode); }
public static CityFileDetail CreateCityBankDetail(IAS.DAL.Interfaces.IIASPersonEntities ctx, String line, Int32 rownum) { string detailId = OracleDB.GetGenAutoId(); return(new CityFileDetail() { ID = detailId, RECORD_TYPE = getSubstring(line, 0, 1), SequenceNo = rownum.ToString(), BANK_CODE = getSubstring(line, 144, 3), COMPANY_ACCOUNT = getSubstring(line, 3, 10), PAYMENT_DATE = getSubstring(line, 109, 8), PAYMENT_TIME = "", CUSTOMER_NAME = getSubstring(line, 209, 70), CUSTOMER_NO_REF1 = getSubstring(line, 389, 20), REF2 = getSubstring(line, 529, 20), REF3 = "", BRANCH_NO = getSubstring(line, 152, 4), TELLER_NO = "", KIND_OF_TRANSACTION = "", TRANSACTION_CODE = getSubstring(line, 51, 3), CHEQUE_NO = getSubstring(line, 31, 20), AMOUNT = getSubstring(line, 120, 13), CHEQUE_BANK_CODE = "" }); }
public static BankFileHeader ConcreateKTBFileTransfer(IAS.DAL.Interfaces.IIASPersonEntities ctx, String fileName, DTO.UploadData data) { String id = OracleDB.GetGenAutoId(); BankFileHeader header = new BankFileHeader(ctx, id, fileName); foreach (String record in data.Body) { switch (record.Substring(0, 1)) { case "H": CreateKTBHeader(header, record); break; case "D": header.AddDetail(CreateKTBDetail(record)); break; case "T": header.SetTotal(CreateKTBTotal(record)); break; default: break; } } return(header); }
public static void ConcreateEmail(IAS.DAL.Interfaces.IIASPersonEntities ctx, IEnumerable<DTO.ImportBankTransferData> datas) { IEnumerable<AG_IAS_PERSONAL_T> personalAdmins = ctx.AG_IAS_PERSONAL_T.Where(a=>a.MEMBER_TYPE=="4" || a.MEMBER_TYPE=="5"); String emailOut = ConfigurationManager.AppSettings["EmailOut"]; StringBuilder emailBody = new StringBuilder(); emailBody.AppendLine("รายละเอียดการปรับปรุงข้อมูล การนำเข้าการเงินจากธนาคาร<br /><br />"); foreach (DTO.ImportBankTransferData item in datas) { emailBody.AppendLine(String.Format("- ปรับปรุง เลขที่ใบสั่งจ่าย จาก {0} เป็น {1} <br />", item.Ref1, item.ChangeRef1)); } if(personalAdmins.Count() > 0) { foreach (AG_IAS_PERSONAL_T item in personalAdmins) { if (!String.IsNullOrEmpty(item.EMAIL)) EmailSender.Sending(emailBody, item.EMAIL, "ปรับปรุงข้อมูลนำเข้าการเงิน"); //EmailServiceFactory.GetEmailService().SendMail(emailOut, item.EMAIL, "ปรับปรุงข้อมูลนำเข้าการเงิน", emailBody.ToString()); } } }
public void TestSubLinq() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); var result = ctx.AG_IAS_SUBPAYMENT_D_T.Where(a => a.HEAD_REQUEST_NO == "131112111255517").Sum(a => a.AMOUNT); Assert.AreEqual(1000m, result); }
private void GenBankImportFileFromDataBase(String path, List <String> ids) { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); IEnumerable <AG_IAS_PAYMENT_G_T> billPayments = ctx.AG_IAS_PAYMENT_G_T .Where(a => a.GROUP_REQUEST_NO == "999999561000000032" || a.GROUP_REQUEST_NO == "999999561000000033" || a.GROUP_REQUEST_NO == "999999561000000034" || a.GROUP_REQUEST_NO == "999999561000000035").ToList(); FileKTBBank fileKTBBank = new FileKTBBank(ctx); fileKTBBank.AddHeader(); foreach (AG_IAS_PAYMENT_G_T item in billPayments) { fileKTBBank.AddDetail(item); } fileKTBBank.AddTotal(); using (System.IO.StreamWriter file = new System.IO.StreamWriter(path)) { file.WriteLine(convetANSI(fileKTBBank.LineKTBBankHeader.ToString())); foreach (LineKTBBankDetail line in fileKTBBank.LineKTBBankDetails) { file.WriteLine(convetANSI(line.ToString())); } file.WriteLine(convetANSI(fileKTBBank.LineKTBBankTotal.ToString())); } }
public static ReceiveNumber CreateReceiveNumber() { ctx = DAL.DALFactory.GetPersonContext(); ReceiveNumber referanceNumber = new ReceiveNumber(_oicNumber, RunningNumber, DateTime.Now); return(referanceNumber); }
internal virtual IPersonService CreateIPersonService() { // TODO: Instantiate an appropriate concrete class. ctx = new IAS.DataServices.Test.Mocking.MockIASPersonEntities(); IPersonService target = new PersonService(ctx); return(target); }
private static IEnumerable <AG_IAS_SUBPAYMENT_D_T> GetSubPaymentDetails(IAS.DAL.Interfaces.IIASPersonEntities ctx, AG_IAS_SUBPAYMENT_H_T SubPaymentHT) { 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)); return(subPaymentDTs); }
public void TestZipFile_Found() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); DateTime findDate = new DateTime(2013, 10, 10); String zipFilename = GenZipLicenseRequest.StartCompressByPayment(ctx, findDate, "admin", "zip1"); Assert.AreNotEqual(zipFilename, String.Empty); }
public void InitData() { ctx = DAL.DALFactory.GetPersonContext(); _lines.Add("1,9156460258875,นาง,Imp Broker221,นายหน้าประกันชีวิต221,17/1/2533,ญ,04,1001,,"); _lines.Add("2,1990000002211,นางสาว,Imp Broker222,นายหน้าประกันชีวิต222,18/1/2533,ญ,05,1001,,"); _lines.Add("3,9990000002220,นาย,Imp Broker223,นายหน้าประกันชีวิต223,19/1/2533,ช,04,1001,,"); _lines.Add("4,9990000002238,นาง,Imp Broker224,นายหน้าประกันชีวิต224,17/1/2533,ญ,04,1001,,"); _lines.Add("5,9990000002246,นางสาว,Imp Broker225,นายหน้าประกันชีวิต225,18/1/2533,ญ,05,1001,,"); }
public static String StartCompressByOicApprove(IAS.DAL.Interfaces.IIASPersonEntities ctx, List <DTO.GenLicenseDetail> LicenseDetail, 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 = new NASDrive(_netDrive, _userNetDrive, _passNetDrive); // กำหนด รหัส TypeImage สำหรับค้นหา Boolean IsNotCreateFolder = true; DirectoryInfo zipFolder = null; foreach (var item in LicenseDetail) { AG_IAS_LICENSE_D LD = ctx.AG_IAS_LICENSE_D.FirstOrDefault(s => s.ID_CARD_NO == item.ID_CARD_NO && s.UPLOAD_GROUP_NO == item.UPLOAD_GROUP_NO); AG_IAS_LICENSE_H LH = ctx.AG_IAS_LICENSE_H.Single(w => w.UPLOAD_GROUP_NO == LD.UPLOAD_GROUP_NO); AG_IAS_LICENSE_TYPE_R licenType = ctx.AG_IAS_LICENSE_TYPE_R.Single(s => s.LICENSE_TYPE_CODE == LH.LICENSE_TYPE_CODE); AG_IAS_ATTACH_FILE_LICENSE attach = Helpers.GetIASConfigHelper.GetAttachLicensePhoto(ctx, LD.ID_CARD_NO, LD.UPLOAD_GROUP_NO); if (attach == null) { nasDrive.Dispose(); throw new ApplicationException(String.Format("ไม่พบ รูปสำหรับทำใบอนุญาติของ {0} {1} {2}", LD.NAMES, LD.LASTNAME, LD.ID_CARD_NO)); } if (IsNotCreateFolder) { zipFolder = CreateDirectory(Path.Combine(_netDrive, _compressPath), (String.IsNullOrEmpty(zipName)) ? DateTime.Now.ToString("yyyy-MM-dd-hhmmss") : zipName, 0); IsNotCreateFolder = false; } AddLicenseRequest(ctx, _netDrive, zipFolder, LD, LH, 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, ""); } if (Directory.Exists(zipFolder.FullName)) { Directory.Delete(zipFolder.FullName, true); } } nasDrive.Dispose(); return(zipfileName); }
public void InitialDataMocking() { // *********** cost data ********************// CompanyCode = "3139"; CompanyName = "บริษัท ไทยพาณิชย์ประกันภัย จำกัด (มหาชน)"; _userId = "0000000000000000"; DateTime oneYearStart = new DateTime(2013, 1, 1); DateTime oneYearEnd = new DateTime(2014, 12, 31); DateTime fiveYearStart = new DateTime(2013, 1, 1); DateTime fiveYearEnd = new DateTime(2018, 12, 31); /*********************************************/ AG_IAS_LICENSE_H licenseH1 = CreateLicenseH("131004104328818", CompanyCode, CompanyName, 3, "13", "01"); _licenseHs.Add(licenseH1); _licenseDs.Add(CreateLicenseD(licenseH1, (1).ToString("0000"), "L000000111", oneYearStart, oneYearEnd, "1111111111111", "นาย", "กไก่", "กุ่กกุ๊ก", UserId)); _licenseDs.Add(CreateLicenseD(licenseH1, (2).ToString("0000"), "L000000112", oneYearStart, oneYearEnd, "1111111111112", "นาย", "ขไข่", "อยู่ในเล่า", UserId)); _licenseDs.Add(CreateLicenseD(licenseH1, (3).ToString("0000"), "L000000113", oneYearStart, oneYearEnd, "1111111111113", "นาย", "คควาย", "เข้านา", UserId)); AG_IAS_LICENSE_H licenseH2 = CreateLicenseH("131004104328819", CompanyCode, CompanyName, 3, "14", "02"); _licenseHs.Add(licenseH2); _licenseDs.Add(CreateLicenseD(licenseH2, (1).ToString("0000"), "L000000221", fiveYearStart, oneYearEnd, "2222222222221", "นาง", "กไก่", "กุ่กกุ๊ก", UserId)); _licenseDs.Add(CreateLicenseD(licenseH2, (2).ToString("0000"), "L000000222", fiveYearStart, fiveYearEnd, "2222222222222", "นาง", "ขไข่", "อยู่ในเล่า", UserId)); _licenseDs.Add(CreateLicenseD(licenseH2, (3).ToString("0000"), "L000000223", fiveYearStart, fiveYearEnd, "2222222222223", "นาง", "คควาย", "เข้านา", UserId)); AG_IAS_PAYMENT_G_T paymentGT = CreatePaymentGT("999999560900000001", "P", 6); _paymentGTs.Add(paymentGT); AG_IAS_SUBPAYMENT_H_T subHT1 = CreateSubPaymentHT(paymentGT, "1309231620210000", "13", "P", 3); _subPaymentHTs.Add(subHT1); DateTime d = DateTime.Now; _subPaymentDTs.Add(CreateSubPaymentDT(subHT1, (1).ToString("0000"), "1111111111111", "A", "12122e11300001", d)); _subPaymentDTs.Add(CreateSubPaymentDT(subHT1, (2).ToString("0000"), "1111111111112", "A", "12122e11300002", d)); _subPaymentDTs.Add(CreateSubPaymentDT(subHT1, (3).ToString("0000"), "1111111111113", "A", "12122e11300003", d)); AG_IAS_SUBPAYMENT_H_T subHT2 = CreateSubPaymentHT(paymentGT, "1309231620220000", "14", "P", 3); _subPaymentHTs.Add(subHT2); _subPaymentDTs.Add(CreateSubPaymentDT(subHT2, (1).ToString("0000"), "2222222222221", "A", "12122e11300004", d)); _subPaymentDTs.Add(CreateSubPaymentDT(subHT2, (2).ToString("0000"), "2222222222222", "A", "12122e11300005", d)); _subPaymentDTs.Add(CreateSubPaymentDT(subHT2, (3).ToString("0000"), "2222222222223", "A", "12122e11300006", d)); IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); _licenseTypeRs = ctx.AG_IAS_LICENSE_TYPE_R.ToList(); _petitionTypeRs = ctx.AG_IAS_PETITION_TYPE_R.ToList(); }
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 void SendMailConfirmRegistration_Can_Sent_Email() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_REGISTRATION_T regis = ctx.AG_IAS_REGISTRATION_T.SingleOrDefault(a => a.ID_CARD_NO == "1544447642968"); Assert.IsNotNull(regis); Boolean result = MailConfirmHelper.SendMailConfirmRegistration(regis); Assert.IsTrue(result); }
public static void LicensePetitionType(IAS.DAL.Interfaces.IIASPersonEntities ctx, OracleConnection Connection, LicensePetitionType15Request licenseRequest) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH"); string LicenseNo = GenLicenseNumber.AG_LICENSE_RUNNING(ctx, licenseRequest.RECEIPT_DATE, licenseRequest.LICENSE_TYPE_CODE); var License = new DAL.AG_LICENSE_T { LICENSE_NO = LicenseNo, LICENSE_DATE = licenseRequest.RECEIPT_DATE, // Convert.ToDateTime(ReceiveDate), EXPIRE_DATE = licenseRequest.EXPIRATION_DATE, // Convert.ToDateTime(Convert.ToString(expireDate)), LICENSE_TYPE_CODE = licenseRequest.LICENSE_TYPE_CODE, // licenseT, NEW_LICENSE_NO = null, LICENSE_ACTOR = null, DATE_LICENSE_ACT = licenseRequest.RECEIPT_DATE, // Convert.ToDateTime(ReceiveDate), REMARK = null, UNIT_LINK_RENEW = null, START_UL_DATE = null, EXPIRE_UL_DATE = null, UNIT_LINK_STATUS = null }; ctx.AG_LICENSE_T.AddObject(License); 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; // Convert.ToDateTime(Convert.ToString(expireDate)); var entSubpaymentD = ctx.AG_IAS_SUBPAYMENT_D_T.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); //string OldLicense = entSubpaymentD.LICENSE_NO.ToString(); entSubpaymentD.OLD_LICENSE_NO = entSubpaymentD.LICENSE_NO; entSubpaymentD.LICENSE_NO = LicenseNo; OracleCommand objCmd = new OracleCommand() { Connection = Connection, CommandText = "IAS_UPDATE_15", CommandType = CommandType.StoredProcedure }; objCmd.Parameters.Add("P_ID_CARD_NO", OracleDbType.Varchar2).Value = licenseRequest.ID_CARD_NO; objCmd.Parameters.Add("P_LICENSE_TYPE_CODE", OracleDbType.Varchar2).Value = licenseRequest.LICENSE_TYPE_CODE; objCmd.Parameters.Add("P_LICENSE_NO", OracleDbType.Varchar2).Value = LicenseNo; objCmd.Parameters.Add("P_COMP_CODE", OracleDbType.Varchar2).Value = licenseRequest.COMP_CODE; objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = licenseRequest.RECEIPT_NO; // requestNo; objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = licenseRequest.PAYMENT_NO; // payment_no; objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = licenseRequest.RECEIPT_NO; // receiptNo; objCmd.ExecuteNonQuery(); }
public LicenseFileHeader(IAS.DAL.Interfaces.IIASPersonEntities ctx, DTO.UserProfile userProfile, String fileName, String pettitionTypeCode, String licenseTypeCode) { _ctx = ctx; String id = OracleDB.GetGenAutoId(); this.IMPORT_ID = Convert.ToInt64(id); //this.LICENSE_TYPE_CODE = licenseTypeCode; this.PETTITION_TYPE = pettitionTypeCode; this._pettitionTypeUserRequest = pettitionTypeCode; this._licenseTypeUserRequest = licenseTypeCode; this.FILE_NAME = fileName; _userProfile = userProfile; }
public static String ConvertToCode(IAS.DAL.Interfaces.IIASPersonEntities ctx, String source) { string title = (source == "น.ส.") ? "นางสาว" : source; VW_IAS_TITLE_NAME entTitle = ctx.VW_IAS_TITLE_NAME.FirstOrDefault(s => s.NAME == title); if (entTitle == null) { return("999"); } else { return(entTitle.ID.ToString()); } }
public void TestEntityWhenNot_Save() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_PAYMENT_G_T payment = ctx.AG_IAS_PAYMENT_G_T.FirstOrDefault(a => a.GROUP_REQUEST_NO == "999999561000000151"); payment.STATUS = "M"; AG_IAS_PAYMENT_G_T paymentnew = ctx.AG_IAS_PAYMENT_G_T.FirstOrDefault(a => a.GROUP_REQUEST_NO == "999999561000000151"); AG_IAS_PAYMENT_G_T paymentnew_3 = ctx.AG_IAS_PAYMENT_G_T.FirstOrDefault(a => a.GROUP_REQUEST_NO == "999999561000000151" && a.STATUS == "M"); Assert.AreEqual(payment.STATUS, paymentnew.STATUS); Assert.IsNotNull(paymentnew_3); }
public void TestSelectGroupPaymentLicenseDaily() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); var paymentGTs = ctx.AG_IAS_PAYMENT_G_T.Where(a => a.STATUS == "P").GroupBy(p => p.PAYMENT_DATE); IList <DateTime> importDate = new List <DateTime>(); foreach (var item in paymentGTs.ToList()) { importDate.Add((DateTime)item.Key); } Assert.IsNotNull(paymentGTs); Assert.AreEqual(importDate.Count(), 4); }
public static AG_IAS_ATTACH_FILE_LICENSE GetAttachLicensePhoto(IAS.DAL.Interfaces.IIASPersonEntities ctx, String idCardNo, String uploadGroupNo) { AG_IAS_CONFIG config = ctx.AG_IAS_CONFIG.SingleOrDefault(a => a.ID == "13"); if (config == null || String.IsNullOrEmpty(config.ITEM_VALUE)) { throw new ApplicationException("ไม่พบข้อมูล Config รูปภาพ."); } var attach = ctx.AG_IAS_ATTACH_FILE_LICENSE.FirstOrDefault(a => a.ID_CARD_NO == idCardNo && a.GROUP_LICENSE_ID == uploadGroupNo && a.ATTACH_FILE_TYPE == config.ITEM_VALUE); return(attach); }
public void Duplicate_Data_Test_Null_Data() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); IEnumerable <AG_IAS_ATTACH_FILE> attachFiles = ctx.AG_IAS_ATTACH_FILE.Where(a => a.REGISTRATION_ID == "130924103253834"); if (attachFiles != null) { Assert.AreEqual(attachFiles.Count(), 0); IEnumerable <AG_IAS_ATTACH_FILE> attachFileUndup = DistinctDuplicatesHelper.Duplicates <AG_IAS_ATTACH_FILE>(attachFiles, false).ToList(); Assert.AreEqual(attachFileUndup.Count(), 0); } //DTO.UserProfile userProfile = new DTO.UserProfile() { }
public String LinkRecipt(IAS.DAL.Interfaces.IIASPersonEntities ctx) { AG_IAS_USERS user = ctx.AG_IAS_USERS.FirstOrDefault(a => a.USER_ID == CREATE_BY); if (user != null) { String urlroot = ConfigurationManager.AppSettings["WebPublicUrl"].ToString(); String requestdata = CryptoBase64.Encryption(String.Format("{0}||{1}", user.USER_NAME, FilePath)); return(String.Format("{0}UserControl/ViewFile.aspx?PostReceipt={1}", urlroot, requestdata)); } else { return("ไม่พบข้อมูลของเจ้าของใบสั่งจ่าย กรุณาติดต่อผู้ดูแลระบบ"); } }
public void CanGetConfig01_02_03() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); var list = ctx.AG_IAS_APPROVE_CONFIG .Where(s => s.ITEM_TYPE == "01" && "01_02_03".Contains(s.ID)) .Select(s => new DTO.ConfigEntity { Id = s.ID, Name = s.ITEM, Value = s.ITEM_VALUE, Description = s.DESCRIPTION }).ToList(); Assert.AreEqual(list.Count, 3); }
public void LicenseRequest_UploadFile_ValidationTest() { IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); DTO.UserProfile userProfile = CreateUserProfile(); DTO.UploadData data = ReadDataFromFile("ขอใหม่ - li01_1001_84.csv"); String fileName = "testData.txt"; //LicenseFileHeader licenseHeader = LicenseFileFactory.ConcreateLicenseRequest(ctx, userProfile, fileName, data, "11"); var res = CreateLicenseDataResponse(); //res.DataResponse = licenseHeader.ValidateDataOfKTB(); //if (res.IsError) //{ // throw new ApplicationException(res.ErrorMsg); //} //AG_IAS_TEMP_PAYMENT_HEADER payment_g_t = new AG_IAS_TEMP_PAYMENT_HEADER(); //licenseHeader.MappingToEntity<CityFileHeader, AG_IAS_TEMP_PAYMENT_HEADER>(payment_g_t); //ctx.AG_IAS_TEMP_PAYMENT_HEADER.AddObject(payment_g_t); //foreach (CityFileDetail item in licenseHeader.CityFileDetails) //{ // AG_IAS_TEMP_PAYMENT_DETAIL detail = new AG_IAS_TEMP_PAYMENT_DETAIL(); // item.MappingToEntity<AG_IAS_TEMP_PAYMENT_DETAIL>(detail); // ctx.AG_IAS_TEMP_PAYMENT_DETAIL.AddObject(detail); //} //ctx.AG_IAS_TEMP_PAYMENT_TOTAL.AddObject(licenseHeader.GetAG_IAS_TEMP_PAYMENT_TOTAL()); //try //{ // using (var ts = new TransactionScope()) // { // ctx.SaveChanges(); // ts.Complete(); // } //} //catch (Exception ex) //{ // throw; //} }
public void TestPersisAfterAddObject() { String id = "131029190252201"; IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext(); AG_IAS_TEMP_PAYMENT_DETAIL result = ctx.AG_IAS_TEMP_PAYMENT_DETAIL.SingleOrDefault(a => a.ID == id); AG_IAS_PAYMENT_DETAIL data = new AG_IAS_PAYMENT_DETAIL(); result.MappingToEntity <AG_IAS_TEMP_PAYMENT_DETAIL, AG_IAS_PAYMENT_DETAIL>(data); ctx.AG_IAS_PAYMENT_DETAIL.AddObject(data); AG_IAS_PAYMENT_DETAIL t = ctx.AG_IAS_PAYMENT_DETAIL.SingleOrDefault(a => a.ID == id); Assert.IsNotNull(t); }