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 LicensePetitionType15Request ConcreateLicensePetitionType15Request(AG_IAS_SUBPAYMENT_D_T subDetail) { LicensePetitionType15Request licenseRequest = new LicensePetitionType15Request() { UPLOAD_GROUP_NO = subDetail.UPLOAD_GROUP_NO, // row["UPLOAD_GROUP_NO"].ToString(), SEQ_NO = subDetail.SEQ_NO, // row["SEQ_NO"].ToString(), LICENSE_TYPE_CODE = subDetail.LICENSE_TYPE_CODE, // row["license_type_code"].ToString(), ID_CARD_NO = subDetail.ID_CARD_NO, // row["id_card_no"].ToString(), COMP_CODE = subDetail.COMPANY_CODE, // row["COMP_CODE"].ToString(), RECEIPT_DATE = (DateTime)subDetail.RECEIPT_DATE, // Convert.ToDateTime(row["receipt_date"]), RECEIPT_NO = subDetail.RECEIPT_NO, // row["receipt_no"].ToString(), PAYMENT_NO = subDetail.PAYMENT_NO, // row["payment_no"].ToString(), }; return(licenseRequest); }
public static LicensePetitionType1314Request ConcreateLicensePetitionType1314Request(AG_IAS_SUBPAYMENT_D_T subDetail, AG_IAS_LICENSE_D licenseD) { LicensePetitionType1314Request licenseRequest1314 = new LicensePetitionType1314Request() { SEQ_NO = subDetail.SEQ_NO, // row["SEQ_NO"].ToString(), UPLOAD_GROUP_NO = subDetail.UPLOAD_GROUP_NO, // row["UPLOAD_GROUP_NO"].ToString(), PETITION_TYPE_CODE = subDetail.PETITION_TYPE_CODE, RECEIPT_DATE = (DateTime)subDetail.RECEIPT_DATE, // Convert.ToDateTime(row["receipt_date"]), RECEIPT_NO = subDetail.RECEIPT_NO, // row["receipt_no"].ToString(), REQUEST_NO = licenseD.REQUEST_NO, PAYMENT_NO = subDetail.PAYMENT_NO, // row["payment_no"].ToString(), LICENSE_NO = licenseD.LICENSE_NO, AREA = (licenseD.AREA_CODE.Length >= 2)? licenseD.AREA_CODE.Substring(0, 2) : "" }; return(licenseRequest1314); }
public static void LicensePetitionType(IAS.DAL.Interfaces.IIASPersonEntities ctx, OracleConnection Connection, LicensePetitionType11Request licenseRequest) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH"); String LicenseNo = GenLicenseNumber.AG_LICENSE_RUNNING(ctx, (DateTime)licenseRequest.RECEIPT_DATE, licenseRequest.LICENSE_TYPE_CODE); // Convert.ToDateTime(dt.Rows[i]["receipt_date"]), dt.Rows[i]["license_type_code"].ToString()); var License = new DAL.AG_LICENSE_T { LICENSE_NO = LicenseNo, LICENSE_DATE = licenseRequest.RECEIPT_DATE, EXPIRE_DATE = licenseRequest.EXPIRATION_DATE, LICENSE_TYPE_CODE = licenseRequest.LICENSE_TYPE_CODE, NEW_LICENSE_NO = null, LICENSE_ACTOR = null, DATE_LICENSE_ACT = licenseRequest.RECEIPT_DATE, REMARK = null, UNIT_LINK_RENEW = null, START_UL_DATE = null, EXPIRE_UL_DATE = null, UNIT_LINK_STATUS = null }; ctx.AG_LICENSE_T.AddObject(License); //Check Null AG_IAS_LICENSE_D entLicenseD = ctx.AG_IAS_LICENSE_D.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); if (entLicenseD != null) { entLicenseD.LICENSE_NO = LicenseNo; entLicenseD.LICENSE_DATE = DateTime.Now; entLicenseD.LICENSE_EXPIRE_DATE = licenseRequest.EXPIRATION_DATE; } //Check Null AG_IAS_SUBPAYMENT_D_T entSubpaymentD = ctx.AG_IAS_SUBPAYMENT_D_T.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); if (entSubpaymentD != null) { entSubpaymentD.LICENSE_NO = LicenseNo; } OracleCommand objCmd = new OracleCommand() { Connection = Connection, CommandText = "IAS_UPDATE_11", CommandType = CommandType.StoredProcedure }; objCmd.Parameters.Add("P_id_card_no", OracleDbType.Varchar2).Value = SetValue(licenseRequest.ID_CARD_NO); objCmd.Parameters.Add("P_license_type_code", OracleDbType.Varchar2).Value = SetValue(licenseRequest.LICENSE_TYPE_CODE); objCmd.Parameters.Add("P_license_no", OracleDbType.Varchar2).Value = SetValue(LicenseNo); objCmd.Parameters.Add("COMP_CODE", OracleDbType.Varchar2).Value = SetValue(licenseRequest.COMP_CODE); objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = SetValue(entLicenseD.REQUEST_NO); objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = SetValue(licenseRequest.PAYMENT_NO); objCmd.Parameters.Add("P_testing_no", OracleDbType.Varchar2).Value = SetValue(licenseRequest.TESTING_NO); objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = SetValue(licenseRequest.RECEIPT_NO); objCmd.ExecuteNonQuery(); }
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 SubPaymentDetail(AG_IAS_SUBPAYMENT_D_T subPaymentDetail) { _subPaymentDetail = subPaymentDetail; }