public void AddDetail(ExamFileDetail detail)
{
detail.SetHeader(this);
detail.UPLOAD_GROUP_NO = this.UPLOAD_GROUP_NO;
detail.AssociateName = this.ASSOCIATE_NAME;
detail.AssociateCode = this.ASSOCIATE_CODE;
detail.ProvinceCode = this.PROVINCE_CODE;
detail.TestingDate = this.TESTING_DATE;
detail.LicenseTypeCode = this.LICENSE_TYPE_CODE;
detail.TimeCode = this.EXAM_TIME_CODE;
VW_IAS_COM_CODE ent = this.CTX.VW_IAS_COM_CODE.SingleOrDefault(s => s.ID == "01");
detail.InsurCompName = ent.NAME;
string examResult = detail.EXAM_RESULT;
if ("P_F".Contains(examResult))
{
detail.EXAM_RESULT = examResult;
}
else if (examResult == "M")
{
detail.ABSENT_EXAM = examResult;
}
string title = detail.TITLE == "น.ส." ? "นางสาว" : detail.TITLE;
//ตรวจสอบคำนำหน้าชื่อ
VW_IAS_TITLE_NAME entTitle = this.CTX.VW_IAS_TITLE_NAME.ToList().FirstOrDefault(s => s.NAME == title);
if (entTitle != null)
{
detail.PRE_NAME_CODE = entTitle.ID.ToString();
}
else
{
detail.ERROR_MSG = Resources.errorExamFileHeader_001;
}
IEnumerable <BusinessRule> rules = detail.GetBrokenRules();
if (rules != null && rules.Count() > 0)
{
StringBuilder errmsg = new StringBuilder("");
foreach (BusinessRule rule in rules)
{
errmsg.AppendLine(String.Format("- {0} <br />", rule.Rule));
}
detail.ERROR_MSG = errmsg.ToString();
}
_examFileDetails.Add(detail);
}
public static DTO.ResponseService <ExamFileHeader> ConcreateApplicantFileRequest(IAS.DAL.IASPersonEntities ctx, DTO.ApplicantUploadRequest request)
{
DTO.ResponseService <ExamFileHeader> response = new DTO.ResponseService <ExamFileHeader>();
ExamFileHeader header = CreateExamFileHeader(ctx, request);
Int32 row = 0;
foreach (String record in request.UploadData.Body)
{
row++;
ExamFileDetail detail = CreateExamFileDetail(ctx, record, row);
header.AddDetail(detail);
}
response.DataResponse = header;
return(response);
}
private static ExamFileDetail CreateExamFileDetail(IAS.DAL.IASPersonEntities ctx, String rawData, Int32 rownum)
{
String[] data = rawData.Split('|');
ExamFileDetail detail = new ExamFileDetail(ctx)
{
SEQ_NO = rownum.ToString("0000"),
SEAT_NO = data.GetIndexOf(1),
ID_CARD_NO = data.GetIndexOf(2),
TITLE = data.GetIndexOf(3),
NAMES = data.GetIndexOf(4),
LAST_NAME = data.GetIndexOf(5),
ADDRESS1 = data.GetIndexOf(6),
ADDRESS2 = data.GetIndexOf(7),
AREA_CODE = data.GetIndexOf(8),
BIRTH_DATE = data.GetIndexOf(9).String_dd_MM_yyyy_ToDate('/', true),
SEX = data.GetIndexOf(10),
EDUCATION_CODE = data.GetIndexOf(11),
COMP_CODE = data.GetIndexOf(12),
APPROVE_DATE = data.GetIndexOf(13).String_dd_MM_yyyy_ToDate('/', true),
EXAM_RESULT = data.GetIndexOf(14),
SCORE_1 = data.GetIndexOf(15),
SCORE_2 = data.GetIndexOf(16),
SCORE_3 = data.GetIndexOf(17),
SCORE_4 = data.GetIndexOf(18),
SCORE_5 = data.GetIndexOf(19),
SCORE_6 = data.GetIndexOf(20),
SCORE_7 = data.GetIndexOf(21),
SCORE_8 = data.GetIndexOf(22),
SCORE_9 = data.GetIndexOf(23),
SCORE_10 = data.GetIndexOf(24),
SCORE_11 = data.GetIndexOf(25),
SCORE_12 = data.GetIndexOf(26),
SCORE_13 = data.GetIndexOf(27),
SCORE_14 = data.GetIndexOf(28),
SCORE_15 = data.GetIndexOf(29),
SCORE_16 = data.GetIndexOf(30),
};
return(detail);
}
public void AddDetail(AG_IAS_APPLICANT_SCORE_D_TEMP detial_tmp)
{
ExamFileDetail detail = detial_tmp as ExamFileDetail;
detail.SetHeader(this);
detail.UPLOAD_GROUP_NO = this.UPLOAD_GROUP_NO;
detail.GetBrokenRules();
IEnumerable <BusinessRule> rules = detail.GetBrokenRules();
if (rules != null && rules.Count() > 0)
{
StringBuilder errmsg = new StringBuilder("");
foreach (BusinessRule rule in rules)
{
errmsg.AppendLine(String.Format("- {0} <br />", rule.Rule));
}
detail.ERROR_MSG = errmsg.ToString();
}
_examFileDetails.Add(detail);
}
