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