Exemplo n.º 1
0
        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();
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        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;
        }
Exemplo n.º 4
0
        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;
            }
        }
Exemplo n.º 5
0
        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);
        }
Exemplo n.º 6
0
        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 = ""
            });
        }
Exemplo n.º 7
0
        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);
        }
Exemplo n.º 8
0
        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());
                }
            }
        }
Exemplo n.º 9
0
        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);
        }
Exemplo n.º 10
0
        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()));
            }
        }
Exemplo n.º 11
0
        public static ReceiveNumber CreateReceiveNumber()
        {
            ctx = DAL.DALFactory.GetPersonContext();

            ReceiveNumber referanceNumber = new ReceiveNumber(_oicNumber, RunningNumber, DateTime.Now);

            return(referanceNumber);
        }
Exemplo n.º 12
0
        internal virtual IPersonService CreateIPersonService()
        {
            // TODO: Instantiate an appropriate concrete class.
            ctx = new IAS.DataServices.Test.Mocking.MockIASPersonEntities();
            IPersonService target = new PersonService(ctx);

            return(target);
        }
Exemplo n.º 13
0
        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);
        }
Exemplo n.º 14
0
        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);
        }
Exemplo n.º 15
0
 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,,");
 }
Exemplo n.º 16
0
        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();
        }
Exemplo n.º 18
0
        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);
            }
        }
Exemplo n.º 19
0
        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);
        }
Exemplo n.º 20
0
        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();
        }
Exemplo n.º 21
0
        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;
        }
Exemplo n.º 22
0
        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());
            }
        }
Exemplo n.º 23
0
        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);
        }
Exemplo n.º 25
0
        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);
        }
Exemplo n.º 26
0
        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() {
        }
Exemplo n.º 27
0
        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("ไม่พบข้อมูลของเจ้าของใบสั่งจ่าย กรุณาติดต่อผู้ดูแลระบบ");
            }
        }
Exemplo n.º 28
0
        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;
            //}
        }
Exemplo n.º 30
0
        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);
        }