public ActionResult IntroUpdate(string id)
{
try
{
model.Create(id);
return(Json(new { success = true, date = DateTimeUtils.ConvertDateTimeToString(DateTime.Now, "dd/MM/yyyy", "th") }));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
}
public RptCovid19ExViewModel Find(string id)
{
RptCovid19ExViewModel result = new RptCovid19ExViewModel();
var emp = context.EMPLOYEE.Where(o => o.PERSON_ID == id).FirstOrDefault();
result.PERSON_ID = id;
result.FULLNAME = emp != null ? emp.FULLNAME : "-";
result.ORGANIZATION = emp != null ? emp.ORGDESC : "-";
int[] myArr = new int[0];
var country = context.LUT_COVID_COUNTRY;
var countryList = new List <string>();
var countryList2 = new List <string>();
var displayCountry = context.LUT_COVID_COUNTRY.Where(o => o.DISPLAY_FLAG == true);
var query = context.RPT_COVID19EX.Where(o => o.PERSON_ID == id && o.REPORTER == 1).OrderByDescending(o => o.CREATED_DT).FirstOrDefault();
if (query != null)
{
if (query.REPORTER.HasValue)
{
Array.Resize(ref myArr, myArr.Length + 1);
myArr[myArr.Length - 1] = query.REPORTER.Value;
}
if (query.RPT_COVID19EX_COUNTRY != null && query.RPT_COVID19EX_COUNTRY.Count() > 0)
{
int i = 0;
result.COUNTRY = new int[query.RPT_COVID19EX_COUNTRY.Count()];
foreach (var item in query.RPT_COVID19EX_COUNTRY)
{
bool isDisplay = displayCountry.Where(o => o.ID == item.COUNTRY_ID).Count() > 0;
if (isDisplay)
{
result.COUNTRY[i] = item.COUNTRY_ID.Value;
}
else
{
result.COUNTRY[i] = 999;
result.COUNTRY_ID = item.COUNTRY_ID;
}
var c = country.Find(item.COUNTRY_ID).COUNTRY_NAMT;
countryList.Add(c);
i++;
}
}
result.ID = query.ID;
result.TRAVEL_REASON = query.TRAVEL_REASON;
result.ARRIVAL_DT = query.ARRIVAL_DT;
result.ARRIVAL_FLIGHT = query.ARRIVAL_FLIGHT;
result.DEPARTURE_DT = query.DEPARTURE_DT;
result.DEPARTURE_FLIGHT = query.DEPARTURE_FLIGHT;
result.TRAVEL_REASON_TXT = context.LUT_COVID_CAUSE.Find(query.TRAVEL_REASON) != null?context.LUT_COVID_CAUSE.Find(query.TRAVEL_REASON).DESCR : string.Empty;
result.ARRIVAL_DT_TXT = DateTimeUtils.ConvertDateTimeToString(query.ARRIVAL_DT, "d MMM yyyy", "th");
result.DEPARTURE_DT_TXT = DateTimeUtils.ConvertDateTimeToString(query.DEPARTURE_DT, "d MMM yyyy", "th");
result.COUNTRY_TXT = string.Join(",", countryList);
result.HISTORY = context.RPT_COVID19EX.Where(o => o.PERSON_ID == id && o.REPORTER == 1).OrderBy(o => o.CREATED_DT).ToList().Select(o => new RptCovid19ExViewModel()
{
REPORT_DT_TXT = DateTimeUtils.ConvertDateTimeToString(o.REPORT_DT, "d MMM yyyy", "th"),
HAS_FLU = o.HAS_FLU,
SYMTOMS_TXT = string.Join(",", o.RPT_COVID19EX_SYMTOMS.Join(context.LUT_COVID_SYMTOM, c => c.SYMTOMS_ID, lc => lc.ID, (c, lb) => new { lb }).Select(x => x.lb.SYMTOM).ToList())
}).ToList();
}
var query2 = context.RPT_COVID19EX.Where(o => o.PERSON_ID == id && o.REPORTER == 2).OrderByDescending(o => o.CREATED_DT).FirstOrDefault();
if (query2 != null)
{
if (query2.REPORTER.HasValue)
{
Array.Resize(ref myArr, myArr.Length + 1);
myArr[myArr.Length - 1] = query2.REPORTER.Value;
}
if (query2.RPT_COVID19EX_COUNTRY != null && query2.RPT_COVID19EX_COUNTRY.Count() > 0)
{
int i = 0;
result.COUNTRY2 = new int[query2.RPT_COVID19EX_COUNTRY.Count()];
foreach (var item in query2.RPT_COVID19EX_COUNTRY)
{
bool isDisplay = displayCountry.Where(o => o.ID == item.COUNTRY_ID).Count() > 0;
if (isDisplay)
{
result.COUNTRY2[i] = item.COUNTRY_ID.Value;
}
else
{
result.COUNTRY2[i] = 999;
result.COUNTRY_ID2 = item.COUNTRY_ID;
}
var c = country.Find(item.COUNTRY_ID).COUNTRY_NAMT;
countryList2.Add(c);
i++;
}
}
result.TRAVEL_REASON2 = query2.TRAVEL_REASON;
result.ARRIVAL_DT2 = query2.ARRIVAL_DT;
result.ARRIVAL_FLIGHT2 = query2.ARRIVAL_FLIGHT;
result.DEPARTURE_DT2 = query2.DEPARTURE_DT;
result.DEPARTURE_FLIGHT2 = query2.DEPARTURE_FLIGHT;
result.COMPANION_NAME1 = query2.COMPANION_NAME1;
result.COMPANION_NAME2 = query2.COMPANION_NAME2;
result.COMPANION_NAME3 = query2.COMPANION_NAME3;
result.COMPANION_RELATION1 = query2.COMPANION_RELATION1;
result.COMPANION_RELATION2 = query2.COMPANION_RELATION2;
result.COMPANION_RELATION3 = query2.COMPANION_RELATION3;
result.TRAVEL_REASON_TXT2 = context.LUT_COVID_CAUSE.Find(query2.TRAVEL_REASON).DESCR;
result.ARRIVAL_DT_TXT2 = DateTimeUtils.ConvertDateTimeToString(query2.ARRIVAL_DT, "d MMM yyyy", "th");
result.DEPARTURE_DT_TXT2 = DateTimeUtils.ConvertDateTimeToString(query2.DEPARTURE_DT, "d MMM yyyy", "th");
result.COUNTRY_TXT2 = string.Join(",", countryList2);
result.HISTORY2 = context.RPT_COVID19EX.Where(o => o.PERSON_ID == id && o.REPORTER == 2).OrderBy(o => o.CREATED_DT).ToList().Select(o => new RptCovid19ExViewModel()
{
REPORT_DT_TXT = DateTimeUtils.ConvertDateTimeToString(o.REPORT_DT, "d MMM yyyy", "th"),
HAS_FLU = o.HAS_FLU,
SYMTOMS_TXT = string.Join(",", o.RPT_COVID19EX_SYMTOMS.Join(context.LUT_COVID_SYMTOM, c => c.SYMTOMS_ID, lc => lc.ID, (c, lb) => new { lb }).Select(x => x.lb.SYMTOM).ToList())
}).ToList();
}
result.REPORTERS = new int[myArr.Length];
result.REPORTERS = myArr;
return(result);
}
public ActionResult Form(RptCovid19ExViewModel ViewModel)
{
try
{
model.Create(ViewModel);
return(Json(new { success = true, covidID = ViewModel.PERSON_ID, date = DateTimeUtils.ConvertDateTimeToString(DateTime.Now, "dd/MM/yyyy", "th") }));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
}
