/// <summary>
/// Internal constructor that is called by the OpenOnFile static method.
/// </summary>
/// <param name="path">File path to the container.</param>
/// <param name="packageFileMode">Container is opened in the specified mode if possible</param>
/// <param name="packageFileAccess">Container is opened with the specified access if possible</param>
/// <param name="share">Container is opened with the specified share if possible</param>
internal ZipPackage(string path, FileMode packageFileMode, FileAccess packageFileAccess, FileShare share)
: base(packageFileAccess)
{
ZipArchive? zipArchive = null;
ContentTypeHelper?contentTypeHelper;
_packageFileMode = packageFileMode;
_packageFileAccess = packageFileAccess;
try
{
_containerStream = new FileStream(path, _packageFileMode, _packageFileAccess, share);
_shouldCloseContainerStream = true;
ZipArchiveMode zipArchiveMode = ZipArchiveMode.Update;
if (packageFileAccess == FileAccess.Read)
{
zipArchiveMode = ZipArchiveMode.Read;
}
else if (packageFileAccess == FileAccess.Write)
{
zipArchiveMode = ZipArchiveMode.Create;
}
else if (packageFileAccess == FileAccess.ReadWrite)
{
zipArchiveMode = ZipArchiveMode.Update;
}
zipArchive = new ZipArchive(_containerStream, zipArchiveMode, true, Text.Encoding.UTF8);
_zipStreamManager = new ZipStreamManager(zipArchive, _packageFileMode, _packageFileAccess);
contentTypeHelper = new ContentTypeHelper(zipArchive, _packageFileMode, _packageFileAccess, _zipStreamManager);
}
catch
{
zipArchive?.Dispose();
_containerStream?.Dispose();
throw;
}
_zipArchive = zipArchive;
_contentTypeHelper = contentTypeHelper;
}
/// <summary>
/// Handles the BeginRequest event of the context control.
/// </summary>
/// <param name="sender">The source of the event</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data</param>
private static void PreRequestHandlerExecute(object sender, EventArgs e)
{
if (!WebMarkupMinContext.Current.IsCompressionEnabled())
{
return;
}
HttpContext context = ((HttpApplication)sender).Context;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string contentType = response.ContentType;
if (request.HttpMethod == "GET" && response.StatusCode == 200 &&
CompressionHelper.IsCompressionSupported(request) &&
ContentTypeHelper.IsTextBasedContentType(contentType))
{
context.Items["originalResponseFilter"] = response.Filter;
CompressionHelper.TryCompressContent(context);
}
}
public DownloadFileResponse Action()
{
ConnectNetDrive();
DownloadFileResponse response = new DownloadFileResponse();
try
{
_targetPath = _targetPath.Replace('/', '\\');
System.IO.FileInfo fileInfo = new FileInfo(_targetPath);
// check if exists
if (!fileInfo.Exists)
{
throw new FileNotFoundException(Resources.errorDeleteFile_FileNotFound, _fileName);
}
response.HashCode = FileObject.GetHashSHA1(_targetPath);
// open stream
System.IO.FileStream stream = new FileStream(_targetPath, FileMode.Open, FileAccess.Read);
// ดึง Content Type คืนไปฝั่ง Web ที Consume Service
response.ContentType = ContentTypeHelper.MimeType(fileInfo.Name);
response.FileName = _fileName;
response.Length = fileInfo.Length;
response.FileByteStream = stream;
response.Code = "0000";
response.Message = Resources.infoDeleteContainer_001;
}
catch (Exception ex)
{
response.Code = "0001";
response.Message = ex.Message;
}
finally
{
DisConnectNetDrive();
}
return(response);
}
/// <summary>
/// Processes a response content
/// </summary>
/// <param name="context">HTTP response</param>
protected override void ProcessContent(HttpContext context)
{
HttpRequest request = context.Request;
HttpResponse response = context.Response;
Encoding encoding = response.ContentEncoding;
string contentType = response.ContentType;
if (request.HttpMethod == "GET" && response.StatusCode == 200 &&
ContentTypeHelper.IsXmlBasedContentType(contentType) &&
context.CurrentHandler != null)
{
var xmlMinifier = WebMarkupMinContext.Current.Markup.CreateXmlMinifierInstance();
response.Filter = new XmlMinificationFilterStream(response.Filter, xmlMinifier,
request.RawUrl, encoding);
if (WebMarkupMinContext.Current.IsCopyrightHttpHeadersEnabled())
{
CopyrightHelper.AddXmlMinificationPoweredByHttpHeader(response);
}
}
}
public async Task <FileDownloadResponse> DownloadAsync(FileDownloadRequest fileDownloadReq)
{
var uploads = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", fileDownloadReq.UserId, "uploads");
var filePath = Path.Combine(uploads, fileDownloadReq.FileName);
if (!System.IO.File.Exists(filePath))
{
return(null);
}
var memory = new MemoryStream();
using (var stream = new FileStream(filePath, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(new FileDownloadResponse {
MemoryStream = memory, ContentType = ContentTypeHelper.GetContentType(filePath)
});
}
public async Task <ActionResult> Get(string fileKey)
{
// cases:
// return file content
// redirect to s3
// redirect to main file service
// file not found
try
{
var file = await this._fileAppService.Get(fileKey);
if (file.StorageType == StorageType.S3)
{
return(new RedirectResult(file.Link));
}
System.Net.Mime.ContentDisposition cd = new System.Net.Mime.ContentDisposition
{
FileName = HttpUtility.UrlEncode(file.Name, Encoding.UTF8).Replace("+", " ").Replace("%2b", "+"),
Inline = ContentTypeHelper.FileIsInline(file.Name) // false = prompt the user for downloading; true = browser to try to show the file inline
};
Response.Headers.Add("Content-Disposition", cd.ToString());
Response.Headers.Add("X-Content-Type-Options", "nosniff");
Response.Headers.Add("cache-control", "max-age=31536000");
return(File(file.Content, ContentTypeHelper.GetMimeType(file.Name), DateTimeOffset.Now.AddSeconds(1), new EntityTagHeaderValue(new Microsoft.Extensions.Primitives.StringSegment("\"inline\""))));
}
catch (FileKeyNotFoundException ex)
{
if (await this._configService.GetBool("IsMainServer"))
{
throw ex;
}
else
{
var url = await this._configService.Get("MainServiceUrl");
return(new RedirectResult($"{url}/{fileKey}"));
// redirect to main file service
}
}
}
/// <summary>
/// 20210310 保存
/// </summary>
/// <param name="minio"></param>
/// <param name="userBucketName"></param>
/// <param name="uploadFilePath"></param>
/// <param name="saveFileName"></param>
/// <returns></returns>
private static async Task Run(MinioClient minio, string userBucketName, string uploadFilePath, string saveFileName)
{
var bucketName = userBucketName;
var location = "us-east-1";
var objectName = saveFileName;
var filePath = uploadFilePath;
var contentType = ContentTypeHelper.GetContentType(saveFileName.Substring(saveFileName.LastIndexOf('.') + 1));
var file = new FileInfo(uploadFilePath);
try
{
var found = await minio.BucketExistsAsync(bucketName);
if (!found)
{
await minio.MakeBucketAsync(bucketName, location);
}
_minioClient.SetTraceOn(new LogHelper());//我们在上传开始的时候，打开日志，通过日志抛出的块编号来计算出当前进度
ViewModelLocator.Instance.FileUploadViewModel.FileSize = file.Length;
ViewModelLocator.Instance.FileUploadViewModel.TotalParts = file.Length / App.MinimumPartSize + 1;//计算出文件总块数
//上传文件
await minio.PutObjectAsync(bucketName, objectName, filePath, contentType);
Debug.WriteLine("Successfully uploaded " + objectName);
}
catch (MinioException e)
{
App.NewNLog.Error($"File Upload Error: {e}");
Debug.WriteLine($"File Upload Error: {e.Message}");
}
finally
{
_minioClient.SetTraceOff();
}
}
private void ResolveDependencies()
{
this._contentTypeHelper = AppContainer.Current.Resolve<ContentTypeHelper>();
this._taxonomyHelper = AppContainer.Current.Resolve<TaxonomyHelper>();
}
public FileContent(string fileName, int contentLength) : this(fileName, contentLength, ContentTypeHelper.GetMIMEType(fileName))
{
}
protected void Validate()
{
var sql = string.Empty;
OracleDB ora = new OracleDB();
if (IMPORT_ID == 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.IMPORT_ID_Required);
}
if (String.IsNullOrEmpty(PETITION_TYPE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.PETITION_TYPE_Required);
}
if (PetitionTypeR == null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.PETITION_TYPE_Required);
}
else
{
if (PetitionTypeR.PETITION_TYPE_CODE != "11" && PetitionTypeR.PETITION_TYPE_CODE != "18")
{
//chkLicense
if (String.IsNullOrEmpty(LICENSE_NO))
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_Required);
}
else
{
//chkLicenseMathId
sql = "SELECT lt.LICENSE_NO "
+ "FROM AG_LICENSE_T lt,AG_AGENT_LICENSE_T ag ,AG_AGENT_LICENSE_PERSON_T ap "
+ "WHERE lt.LICENSE_NO = '" + LICENSE_NO.Trim() + "' "
+ "and ((lt.LICENSE_NO = ag.LICENSE_NO and ag.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "') or "
+ "(lt.LICENSE_NO = ap.LICENSE_NO and ap.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "')) "
+ "group by lt.LICENSE_NO";
DataTable chkMathId = ora.GetDataTable(sql);
if (chkMathId.Rows.Count == 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_NotMath_ID_CARD);
}
else
{
if (PetitionTypeR.PETITION_TYPE_CODE == "13")
{
int renewTime = 0;
renewTime = GetRenewTime(LICENSE_NO);
renewTime = renewTime + 1;
if (renewTime >= 3)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_NotMath_Renew_13);
}
}
else if (PetitionTypeR.PETITION_TYPE_CODE == "14")
{
int renewTime = 0;
renewTime = GetRenewTime(LICENSE_NO);
renewTime = renewTime + 1;
if (renewTime <= 2)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_NotMath_Renew_14);
}
}
if (PetitionTypeR.PETITION_TYPE_CODE != "17" && PetitionTypeR.PETITION_TYPE_CODE != "18")
//&& LicenseFileHeader.LICENSE_TYPE_CODE != "03" && LicenseFileHeader.LICENSE_TYPE_CODE != "04")
{
sql = "SELECT ID_CARD_NO "
+ "FROM AG_AGENT_LICENSE_T "
+ "WHERE LICENSE_NO = '" + LICENSE_NO.Trim() + "' "
+ "AND INSURANCE_COMP_CODE = '" + COMP_CODE + "' ";
DataTable agent = ora.GetDataTable(sql);
if (agent.Rows.Count == 0)
{
if (!string.IsNullOrEmpty(COMP_CODE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_NotMath_Required);
}
}
}
if (LICENSE_ACTIVE_DATE == null || LICENSE_ACTIVE_DATE == DateTime.MinValue)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_ACTIVE_DATE_Required);
}
else
{
if (!String.IsNullOrEmpty(LICENSE_NO))
{
DateTime atDate = Convert.ToDateTime(LICENSE_ACTIVE_DATE).AddYears(-543);
sql = "SELECT lt.LICENSE_NO "
+ "FROM AG_LICENSE_T lt "
+ "WHERE lt.LICENSE_NO = '" + LICENSE_NO.Trim() + "' "
+ "AND lt.DATE_LICENSE_ACT = TO_DATE('" + string.Format("{0:dd/MM/yyyy}", atDate) + "','dd/MM/yyyy') ";
DataTable chkActiveDate = ora.GetDataTable(sql);
if (chkActiveDate.Rows.Count == 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_ACTIVE_DATE_Required);
}
}
}
if (LICENSE_EXPIRE_DATE == null || LICENSE_EXPIRE_DATE == DateTime.MinValue)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_EXPIRE_DATE_Required);
}
else
{
if (!String.IsNullOrEmpty(LICENSE_NO))
{
DateTime exDate = Convert.ToDateTime(LICENSE_EXPIRE_DATE).AddYears(-543);
sql = "SELECT lt.LICENSE_NO "
+ "FROM AG_LICENSE_T lt "
+ "WHERE lt.LICENSE_NO = '" + LICENSE_NO.Trim() + "' "
+ "AND lt.EXPIRE_DATE = TO_DATE('" + string.Format("{0:dd/MM/yyyy}", exDate) + "','dd/MM/yyyy') ";
DataTable chkExpireDate = ora.GetDataTable(sql);
if (chkExpireDate.Rows.Count == 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_EXPIRE_DATE_Required);
}
else
{
if (PetitionTypeR.PETITION_TYPE_CODE == "13" || PetitionTypeR.PETITION_TYPE_CODE == "14")
{
string currDateFormat = String.Format("{0:dd/MM/yyy}", DateTime.Now).ToString();
string ExDateFormat = String.Format("{0:dd/MM/yyyy}", LICENSE_EXPIRE_DATE).ToString();
DateTime currTime = DateTime.Parse(currDateFormat);
DateTime exTime = DateTime.Parse(ExDateFormat);
int dateCompare = DateTime.Compare(exTime, currTime);
if (dateCompare == -1)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_EXPIRE_DATE_Expire);
}
// check ต่ออายุภายใน 60 วัน
else
{
string strDate = LICENSE_EXPIRE_DATE.ToString();
string diffDate = DateCompare(strDate);
if ((Convert.ToInt32(diffDate) < 0) || !(Convert.ToInt32(diffDate) <= 60))
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_EXPIRE_DATE_SixtyDay);
}
}
}
}
}
}
}
}
}
else if (PetitionTypeR.PETITION_TYPE_CODE == "11" || PetitionTypeR.PETITION_TYPE_CODE == "18")
{
if (!String.IsNullOrEmpty(LICENSE_NO))
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_NO_Required);
}
if (LICENSE_ACTIVE_DATE != null || LICENSE_ACTIVE_DATE == DateTime.MinValue)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_ACTIVE_DATE_Required);
}
if (LICENSE_EXPIRE_DATE != null || LICENSE_EXPIRE_DATE == DateTime.MinValue)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_EXPIRE_DATE_Required);
}
}
}
if (String.IsNullOrEmpty(COMP_CODE) && ("17_18").Contains(PetitionTypeR.PETITION_TYPE_CODE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.COMP_CODE_Required);
}
//ขอรับใบอนุญาตเป็นบริษัทเดิมขอไม่ได้
if (PetitionTypeR.PETITION_TYPE_CODE == "18")
{
sql = "SELECT aal.INSURANCE_COMP_CODE "
+ "FROM AG_LICENSE_T al,AG_AGENT_LICENSE_T aal "
+ "WHERE aal.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' "
+ "AND al.LICENSE_NO = aal.LICENSE_NO "
+ "AND al.LICENSE_TYPE_CODE = '" + LicenseFileHeader.LICENSE_TYPE_CODE.Trim() + "' ";
DataTable agent = ora.GetDataTable(sql);
if (agent != null && agent.Rows.Count > 0)
{
string comAgent = agent.Rows[0]["INSURANCE_COMP_CODE"].ToString();
if (comAgent.Trim() == this.COMP_CODE.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.COMP_CODE_Required_02);
}
}
}
if (String.IsNullOrEmpty(SEQ))
{
AddBrokenRule(LicenseFileDetailBusinessRules.SEQ_Required);
}
else if (SEQ != Sequence)
{
AddBrokenRule(LicenseFileDetailBusinessRules.SEQ_NotOrder);
}
//ใบแทนใบอนุญาตเปลี่ยนชื่อสกุลค่าธรรมเนียมเป็น 0
if (PetitionTypeR.PETITION_TYPE_CODE == "16" && replaceType == DTO.ReplateType.ChangeNameandSur.GetEnumValue().ToString())
{
if (LICENSE_FEE == null || LICENSE_FEE != 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_FEE_Required);
}
}
else if (PetitionTypeR.PETITION_TYPE_CODE == "11" && (new[] { "11", "12" }).Contains(LicenseFileHeader.LICENSE_TYPE_CODE))
{
if (LICENSE_FEE == null || LICENSE_FEE != 0)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_FEE_Required);
}
}
else
{
if (LICENSE_FEE == null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_FEE_Required);
}
else
{
sql = "SELECT FEE "
+ "FROM AG_PETITION_TYPE_R "
+ "WHERE PETITION_TYPE_CODE = '" + PetitionTypeR.PETITION_TYPE_CODE + "' ";
DataTable dtFree = ora.GetDataTable(sql);
if (dtFree != null && dtFree.Rows.Count > 0)
{
DataRow drFree = dtFree.Rows[0];
decimal free = drFree[0].ToDecimal();
if (LICENSE_FEE != free)
{
AddBrokenRule(LicenseFileDetailBusinessRules.LICENSE_FEE_Required);
}
}
}
}
if (String.IsNullOrEmpty(CITIZEN_ID) || CITIZEN_ID.Length != 13)
{
AddBrokenRule(LicenseFileDetailBusinessRules.CITIZEN_ID_Required);
}
else if (!Utils.IdCard.Verify(CITIZEN_ID))
{
AddBrokenRule(LicenseFileDetailBusinessRules.CITIZEN_ID_Required);
}
if (String.IsNullOrEmpty(TITLE_NAME))
{
AddBrokenRule(LicenseFileDetailBusinessRules.TITLE_NAME_Required);
}
else
{
sql = "SELECT PRE_NAME_CODE "
+ "FROM AG_PERSONAL_T "
+ "WHERE ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' ";
DataTable dtPreNameCode = ora.GetDataTable(sql);
if (dtPreNameCode != null && dtPreNameCode.Rows.Count > 0)
{
DataRow dr = dtPreNameCode.Rows[0];
string perId = dr[0].ToString();
sql = "SELECT NAME "
+ "FROM VW_IAS_TITLE_NAME_PRIORITY "
+ "WHERE ID = '" + perId.Trim() + "' ";
DataTable dtPerPreName = ora.GetDataTable(sql);
if (dtPerPreName != null && dtPerPreName.Rows.Count > 0)
{
var drPerPreName = dtPerPreName.Rows[0];
string perPreName = drPerPreName[0].ToString();
if (TITLE_NAME.Trim() != perPreName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.TITLE_NAME_Required);
}
}
}
else if (dtPreNameCode.Rows.Count == 0)
{
if (PetitionTypeR.PETITION_TYPE_CODE == "11")
{
sql = "SELECT ap.PRE_NAME_CODE,ap.TESTING_NO "
+ "FROM AG_APPLICANT_T ap,AG_EXAM_LICENSE_R ex "
+ "WHERE ap.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' "
+ "and ap.TESTING_NO = ex.TESTING_NO "
+ "and ex.LICENSE_TYPE_CODE = '" + LicenseFileHeader.LICENSE_TYPE_CODE + "' "
+ "order by ap.TESTING_NO desc ";
DataTable dtAppPreCode = ora.GetDataTable(sql);
if (dtAppPreCode != null && dtAppPreCode.Rows.Count > 0)
{
DataRow drAppPreCode = dtAppPreCode.Rows[0];
string appPreId = drAppPreCode["PRE_NAME_CODE"].ToString();
sql = "SELECT NAME "
+ "FROM VW_IAS_TITLE_NAME_PRIORITY "
+ "WHERE ID = '" + appPreId.Trim() + "' ";
DataTable dtAppPreName = ora.GetDataTable(sql);
if (dtAppPreName != null && dtAppPreName.Rows.Count > 0)
{
var drAppPreName = dtAppPreName.Rows[0];
string appPreName = drAppPreName[0].ToString();
if (TITLE_NAME.Trim() != appPreName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.TITLE_NAME_Required);
}
}
}
}
}
}
if (String.IsNullOrEmpty(NAME))
{
AddBrokenRule(LicenseFileDetailBusinessRules.NAME_Required);
}
else
{
if (replaceType != DTO.ReplateType.ChangeNameandSur.GetEnumValue().ToString())
{
sql = "SELECT NAMES "
+ "FROM AG_PERSONAL_T "
+ "WHERE ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' ";
DataTable dtPerName = ora.GetDataTable(sql);
if (dtPerName != null && dtPerName.Rows.Count > 0)
{
DataRow drPerName = dtPerName.Rows[0];
string perName = drPerName[0].ToString();
if (NAME.Trim() != perName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.NAME_Required);
}
}
else if (dtPerName.Rows.Count == 0)
{
if (PetitionTypeR.PETITION_TYPE_CODE == "11")
{
sql = "SELECT ap.NAMES,ap.TESTING_NO "
+ "FROM AG_APPLICANT_T ap,AG_EXAM_LICENSE_R ex "
+ "WHERE ap.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' "
+ "and ap.TESTING_NO = ex.TESTING_NO "
+ "and ex.LICENSE_TYPE_CODE = '" + LicenseFileHeader.LICENSE_TYPE_CODE + "' "
+ "order by ap.TESTING_NO desc ";
DataTable dtAppName = ora.GetDataTable(sql);
if (dtAppName != null && dtAppName.Rows.Count > 0)
{
DataRow drAppName = dtAppName.Rows[0];
string appName = drAppName["NAMES"].ToString();
if (NAME.Trim() != appName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.NAME_Required);
}
}
}
}
}
}
if (String.IsNullOrEmpty(SURNAME))
{
AddBrokenRule(LicenseFileDetailBusinessRules.SURNAME_Required);
}
else
{
if (replaceType != DTO.ReplateType.ChangeNameandSur.GetEnumValue().ToString())
{
sql = "SELECT LASTNAME "
+ "FROM AG_PERSONAL_T "
+ "WHERE ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' ";
DataTable dtPerSurName = ora.GetDataTable(sql);
if (dtPerSurName != null && dtPerSurName.Rows.Count > 0)
{
DataRow drPerSurName = dtPerSurName.Rows[0];
string perSurName = drPerSurName[0].ToString();
if (SURNAME.Trim() != perSurName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.SURNAME_Required);
}
}
else if (dtPerSurName.Rows.Count == 0)
{
if (PetitionTypeR.PETITION_TYPE_CODE == "11")
{
sql = "SELECT ap.LASTNAME,ap.TESTING_NO "
+ "FROM AG_APPLICANT_T ap,AG_EXAM_LICENSE_R ex "
+ "WHERE ap.ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' "
+ "and ap.TESTING_NO = ex.TESTING_NO "
+ "and ex.LICENSE_TYPE_CODE = '" + LicenseFileHeader.LICENSE_TYPE_CODE.Trim() + "' "
+ "order by ap.TESTING_NO desc ";
DataTable dtAppLastName = ora.GetDataTable(sql);
if (dtAppLastName != null && dtAppLastName.Rows.Count > 0)
{
DataRow drAppLastName = dtAppLastName.Rows[0];
string appLastName = drAppLastName["LASTNAME"].ToString();
if (SURNAME.Trim() != appLastName.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.SURNAME_Required);
}
}
}
}
}
}
if (String.IsNullOrEmpty(ADDR1))
{
AddBrokenRule(LicenseFileDetailBusinessRules.ADDR1_Required);
}
else if (ADDR1.Length > 60)
{
ADDR1 = ADDR1.Substring(0, 60);
}
//if (String.IsNullOrEmpty(ADDR2))
// AddBrokenRule(LicenseFileDetailBusinessRules.ADDR2_Required);
if (String.IsNullOrEmpty(AREA_CODE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.AREA_CODE_Required);
}
//if (String.IsNullOrEmpty(EMAIL))
// AddBrokenRule(LicenseFileDetailBusinessRules.EMAIL_Required);
if (String.IsNullOrEmpty(CUR_ADDR))
{
AddBrokenRule(LicenseFileDetailBusinessRules.CUR_ADDR_Required);
}
else if (CUR_ADDR.Length > 60)
{
CUR_ADDR = CUR_ADDR.Substring(0, 60);
}
//if (String.IsNullOrEmpty(TEL_NO))
// AddBrokenRule(LicenseFileDetailBusinessRules.TEL_NO_Required);
if (String.IsNullOrEmpty(CUR_AREA_CODE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.CUR_AREA_CODE_Required);
}
//if (String.IsNullOrEmpty(REMARK))
// AddBrokenRule(LicenseFileDetailBusinessRules.REMARK_Required);
//if (String.IsNullOrEmpty(AR_ANSWER))
// AddBrokenRule(LicenseFileDetailBusinessRules.AR_ANSWER_Required);
if (!String.IsNullOrEmpty(AR_ANSWER))
{
if (AR_ANSWER == "NOTARDATE")
{
AddBrokenRule(LicenseFileDetailBusinessRules.AR_DATE_Required);
}
}
if (PetitionTypeR.PETITION_TYPE_CODE == "17")
{
if (String.IsNullOrEmpty(OLD_COMP_CODE))
{
AddBrokenRule(LicenseFileDetailBusinessRules.OLD_COMP_CODE_Required);
}
else
{
sql = "SELECT INSURANCE_COMP_CODE "
+ "FROM AG_AGENT_LICENSE_T "
+ "WHERE ID_CARD_NO = '" + CITIZEN_ID.Trim() + "' "
+ "AND LICENSE_NO = '" + LICENSE_NO.Trim() + "' ";
DataTable dtInsurance = ora.GetDataTable(sql);
if (dtInsurance != null && dtInsurance.Rows.Count > 0)
{
DataRow dr = dtInsurance.Rows[0];
string oldComCode = dr[0].ToString();
if (OLD_COMP_CODE.Trim() != oldComCode.Trim())
{
AddBrokenRule(LicenseFileDetailBusinessRules.OLD_COMP_CODE_Required);
}
}
}
}
else
{
if (!String.IsNullOrEmpty(OLD_COMP_CODE))
{
if (OLD_COMP_CODE.Length > 4)
{
AddBrokenRule(LicenseFileDetailBusinessRules.OLD_COMP_CODE_Required);
}
}
}
//if (String.IsNullOrEmpty(ERR_MSG))
// AddBrokenRule(LicenseFileDetailBusinessRules.ERR_MSG_Required);
//if (String.IsNullOrEmpty(LOAD_STATUS))
// AddBrokenRule(LicenseFileDetailBusinessRules.LOAD_STATUS_Required);
if (PetitionTypeR.PETITION_TYPE_CODE == "11")
{
var duplicense = (from hl in _ctx.AG_IAS_IMPORT_HEADER_TEMP
join dl in _ctx.AG_IAS_IMPORT_DETAIL_TEMP on hl.IMPORT_ID equals dl.IMPORT_ID
join lt in _ctx.AG_IAS_LICENSE_TYPE_R on hl.LICENSE_TYPE_CODE equals lt.LICENSE_TYPE_CODE
join ld in _ctx.AG_IAS_LICENSE_D on dl.CITIZEN_ID equals ld.ID_CARD_NO
join lh in _ctx.AG_IAS_LICENSE_H on ld.UPLOAD_GROUP_NO equals lh.UPLOAD_GROUP_NO
where dl.CITIZEN_ID == this.CITIZEN_ID &&
dl.LOAD_STATUS == "C" &&
ld.APPROVED == "Y" &&
lh.LICENSE_TYPE_CODE == LicenseFileHeader.LICENSE_TYPE_CODE &&
lh.PETITION_TYPE_CODE == LicenseFileHeader.PETTITION_TYPE &&
hl.LICENSE_TYPE_CODE == LicenseFileHeader.LICENSE_TYPE_CODE &&
hl.PETTITION_TYPE == LicenseFileHeader.PETTITION_TYPE
select lt.LICENSE_TYPE_NAME).FirstOrDefault();
if (duplicense != null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.CITIZEN_ID_Duplicate);
}
}
if (START_DATE != null)
{
if (START_DATE == DateTime.MinValue)
{
AddBrokenRule(LicenseFileDetailBusinessRules.STARDATE_Required);
}
}
if (!String.IsNullOrEmpty(SPECIAL_TYPE_CODE))
{
if (START_DATE == null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.STARDATE_Required);
}
}
var waiting = _ctx.AG_IAS_LICENSE_D.Where(w => w.ID_CARD_NO == this.CITIZEN_ID && w.APPROVED == "W").FirstOrDefault();
if (waiting != null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.CITIZEN_ID_Waiting);
}
//Validate Attach File Request
foreach (var item in LicenseFileHeader.DocumentTypeRequests)
{
var result = AttachFileDetails.FirstOrDefault(r => r.FileTypeCode == item.DOCUMENT_CODE);
if (result == null)
{
AG_IAS_DOCUMENT_TYPE attach = LicenseFileHeader.DocumentTypes.FirstOrDefault(a => a.DOCUMENT_CODE == item.DOCUMENT_CODE);
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("กรุณาแนบไฟล์ {0}.", (attach != null) ? attach.DOCUMENT_NAME : " ")));
}
else
{
//#region checkSize
AG_IAS_DOCUMENT_TYPE attach = LicenseFileHeader.DocumentTypes.FirstOrDefault(a => a.DOCUMENT_CODE == item.DOCUMENT_CODE && a.IS_CARD_PIC == "Y");
if (attach != null)
{
string fileName = result.FileName + result.Extension;
var contentType = ContentTypeHelper.MimeType(fileName);
var tagPicture = new string[] { "image/bmp", "image/gif", "image/jpeg", "image/png", "image/x-png", "image/pjpeg", "image/tiff" };
if (!tagPicture.Contains(contentType))
{
AddBrokenRule(LicenseFileDetailBusinessRules.PICTURE_Formate);
}
// else
//{
// string path = result.FullFileName;
// System.Drawing.Image img = System.Drawing.Image.FromFile(path);
// var inchesWidth = img.Width/img.HorizontalResolution;
// var inchesHieght = img.Height/img.VerticalResolution;
//if (img.Width != 354 && img.Height != 472)
//if (inchesWidth )
//{
//}
//{
// AddBrokenRule(new BusinessRule("AttachFileLicenses", Resources.errorLicenseFileDetail_001));
// AddBrokenRule(new BusinessRule("AttachFileLicenses", Resources.errorLicenseFileDetail_002));
//}
//}
}
//#endregion
}
}
//chkSpecialDocument
foreach (var atFile in AttachFileDetails)
{
String imageTypeCode = ConfigurationManager.AppSettings["CODE_ATTACH_PHOTO"].ToString();
sql = "SELECT DOCUMENT_CODE "
+ "FROM AG_IAS_DOCUMENT_TYPE "
+ "WHERE DOCUMENT_CODE = '" + atFile.FileTypeCode.Trim() + "' "
+ "AND DOCUMENT_CODE !='" + imageTypeCode.Trim() + "' ";
DataTable attach = ora.GetDataTable(sql);
if (attach != null && attach.Rows.Count != 0)
{
string fileName = atFile.FileName + atFile.Extension;
var contentType = ContentTypeHelper.MimeType(fileName);
var tagDocument = new string[] { "image/bmp", "image/gif", "image/jpeg", "image/png", "image/x-png", "image/pjpeg", "image/tiff", "application/msword"
, "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "application/pdf" };
if (!tagDocument.Contains(contentType))
{
AddBrokenRule(LicenseFileDetailBusinessRules.DOC_Formate);
}
else
{
var Special = _ctx.AG_IAS_DOCUMENT_TYPE.FirstOrDefault(r => r.DOCUMENT_CODE == atFile.FileTypeCode && (r.SPECIAL_TYPE_CODE_EXAM != null || r.SPECIAL_TYPE_CODE_TRAIN != null));
if (Special != null)
{
if (Special.SPECIAL_TYPE_CODE_EXAM != null)
{
var chkSpecialTemp = _ctx.AG_IAS_SPECIAL_T_TEMP.FirstOrDefault(r => r.SPECIAL_TYPE_CODE == Special.SPECIAL_TYPE_CODE_EXAM.Trim() && r.ID_CARD_NO.Trim() == CITIZEN_ID.Trim() && r.STATUS != "N");
if (chkSpecialTemp != null)
{
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("มีการส่งเอกสาร {0} มาแล้วไม่สามารส่งซ้ำได้.", (Special != null) ? Special.DOCUMENT_NAME : " ")));
}
else
{
var chkSpecialExam = _ctx.AG_IAS_EXAM_SPECIAL_T.FirstOrDefault(r => r.SPECIAL_TYPE_CODE == Special.SPECIAL_TYPE_CODE_EXAM.Trim() && r.ID_CARD_NO.Trim() == CITIZEN_ID.Trim());
if (chkSpecialExam != null)
{
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("มีการส่งเอกสาร {0} มาแล้วไม่สามารส่งซ้ำได้.", (Special != null) ? Special.DOCUMENT_NAME : " ")));
}
}
if (Special.SPECIAL_TYPE_CODE_EXAM != SPECIAL_TYPE_CODE)
{
AddBrokenRule(LicenseFileDetailBusinessRules.SPECIAL_TYPE_CODE_EXAM_NotFormate);
}
}
else if (Special.SPECIAL_TYPE_CODE_TRAIN != null)
{
var chkSpecialTemp = _ctx.AG_IAS_SPECIAL_T_TEMP.FirstOrDefault(r => r.SPECIAL_TYPE_CODE == Special.SPECIAL_TYPE_CODE_TRAIN.Trim() && r.ID_CARD_NO.Trim() == CITIZEN_ID.Trim() && r.STATUS != "N");
if (chkSpecialTemp != null)
{
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("มีการส่งเอกสาร {0} มาแล้วไม่สามารส่งซ้ำได้.", (Special != null) ? Special.DOCUMENT_NAME : " ")));
}
else
{
var docTrainSpecial = GetTrainSpecial();
if (docTrainSpecial.Contains(Special.SPECIAL_TYPE_CODE_TRAIN))
{
var expireDate = _ctx.AG_TRAIN_SPECIAL_T.FirstOrDefault(r => r.SPECIAL_TYPE_CODE.Trim() == Special.SPECIAL_TYPE_CODE_TRAIN.Trim() && r.ID_CARD_NO.Trim() == CITIZEN_ID.Trim());
if (expireDate != null)
{
//หมดอายุนับจาก startdate 5 ปี
DateTime docDate = Convert.ToDateTime(expireDate.START_DATE).AddYears(5);
DateTime currentDate = DateTime.Now;
string docDateFormat = String.Format("{0:dd/MM/yyyy}", docDate).ToString();
string currDateFormat = String.Format("{0:dd/MM/yyy}", currentDate).ToString();
DateTime docTime = DateTime.Parse(docDateFormat);
DateTime currTime = DateTime.Parse(currDateFormat);
int dateCompare = DateTime.Compare(currTime, docTime);
if (dateCompare == 1)
{
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("เอกสาร {0} ยังไม่หมดอายุไม่สามารถส่งซ้ำได้.", (Special != null) ? Special.DOCUMENT_NAME : " ")));
}
}
}
else
{
var chkSpecial = _ctx.AG_TRAIN_SPECIAL_T.FirstOrDefault(r => r.SPECIAL_TYPE_CODE.Trim() == Special.SPECIAL_TYPE_CODE_TRAIN.Trim() && r.ID_CARD_NO.Trim() == CITIZEN_ID.Trim());
if (chkSpecial != null)
{
AddBrokenRule(new BusinessRule("AttachFileLicenses", String.Format("มีการส่งเอกสาร {0} มาแล้วไม่สามารส่งซ้ำได้.", (Special != null) ? Special.DOCUMENT_NAME : " ")));
}
}
if (Special.SPECIAL_TYPE_CODE_TRAIN != SPECIAL_TYPE_CODE)
{
AddBrokenRule(LicenseFileDetailBusinessRules.SPECIAL_TYPE_CODE_TRAIN_NotFormate);
}
}
}
}
}
}
}
//ตรวจสอบเอกสารพิเศษ
if (!String.IsNullOrEmpty(SPECIAL_TYPE_CODE) && !String.IsNullOrEmpty(START_DATE.ToString()))
{
var docType = (from a in _ctx.AG_IAS_DOCUMENT_TYPE
where a.SPECIAL_TYPE_CODE_EXAM == SPECIAL_TYPE_CODE ||
a.SPECIAL_TYPE_CODE_TRAIN == SPECIAL_TYPE_CODE
select a.DOCUMENT_CODE).FirstOrDefault();
if (docType != null)
{
var Special = (from a in AttachFileDetails
where a.FileTypeCode == docType
select a.FileTypeCode).FirstOrDefault();
if (Special == null)
{
AddBrokenRule(LicenseFileDetailBusinessRules.SPECIAL_TYPE_CODE_NotFound);
}
}
}
}
public Type GetContentType()
{
return(ContentTypeHelper.ResolveContentType(ContentType));
}
/// <summary>
/// Resolve dependencies for Dynamite Helpers
/// </summary>
private void ResolveDependencies()
{
this.contentTypeHelper = AppContainer.Current.Resolve<ContentTypeHelper>();
this.taxonomyHelper = AppContainer.Current.Resolve<TaxonomyHelper>();
this.listHelper = AppContainer.Current.Resolve<ListHelper>();
this.contentOrganizerHelper = AppContainer.Current.Resolve<ContentOrganizerHelper>();
this.myCustomRule = AppContainer.Current.Resolve<MyCustomRule>();
}
/// <summary>
/// Internal constructor that is called by the Open(Stream) static methods.
/// </summary>
/// <param name="s"></param>
/// <param name="packageFileMode"></param>
/// <param name="packageFileAccess"></param>
internal ZipPackage(Stream s, FileMode packageFileMode, FileAccess packageFileAccess)
: base(packageFileAccess)
{
ZipArchive? zipArchive = null;
ContentTypeHelper?contentTypeHelper;
_packageFileMode = packageFileMode;
_packageFileAccess = packageFileAccess;
try
{
if (s.CanSeek)
{
switch (packageFileMode)
{
case FileMode.Open:
if (s.Length == 0)
{
throw new FileFormatException(SR.ZipZeroSizeFileIsNotValidArchive);
}
break;
case FileMode.CreateNew:
if (s.Length != 0)
{
throw new IOException(SR.CreateNewOnNonEmptyStream);
}
break;
case FileMode.Create:
if (s.Length != 0)
{
s.SetLength(0); // Discard existing data
}
break;
}
}
ZipArchiveMode zipArchiveMode = ZipArchiveMode.Update;
if (packageFileAccess == FileAccess.Read)
{
zipArchiveMode = ZipArchiveMode.Read;
}
else if (packageFileAccess == FileAccess.Write)
{
zipArchiveMode = ZipArchiveMode.Create;
}
else if (packageFileAccess == FileAccess.ReadWrite)
{
zipArchiveMode = ZipArchiveMode.Update;
}
zipArchive = new ZipArchive(s, zipArchiveMode, true, Text.Encoding.UTF8);
_zipStreamManager = new ZipStreamManager(zipArchive, packageFileMode, packageFileAccess);
contentTypeHelper = new ContentTypeHelper(zipArchive, packageFileMode, packageFileAccess, _zipStreamManager);
}
catch (InvalidDataException)
{
throw new FileFormatException(SR.FileContainsCorruptedData);
}
catch
{
zipArchive?.Dispose();
throw;
}
_containerStream = s;
_shouldCloseContainerStream = false;
_zipArchive = zipArchive;
_contentTypeHelper = contentTypeHelper;
}
private void ResolveDependencies()
{
this._fieldHelper = AppContainer.Current.Resolve<FieldHelper>();
this._listHelper = AppContainer.Current.Resolve<ListHelper>();
this._contentTypeHelper = AppContainer.Current.Resolve<ContentTypeHelper>();
}
