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;
}
