public static List <object> GetDataSource(
string table,
DataTable dt
)
{
List <object> list = new List <object>();
if (table.Equals("TransProject"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
CUID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? Util.DoGetCUID(new string[] { dr["transProjectID"].ToString() }) : String.Empty),
project = new {
ID = (!String.IsNullOrEmpty(dr["projectID"].ToString()) ? dr["projectID"] : String.Empty),
category = new {
ID = (!String.IsNullOrEmpty(dr["projectCategoryID"].ToString()) ? dr["projectCategoryID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["projectCategoryNameTH"].ToString()) ? dr["projectCategoryNameTH"] : dr["projectCategoryNameEN"]),
en = (!String.IsNullOrEmpty(dr["projectCategoryNameEN"].ToString()) ? dr["projectCategoryNameEN"] : dr["projectCategoryNameTH"])
},
initial = (!String.IsNullOrEmpty(dr["projectCategoryInitial"].ToString()) ? dr["projectCategoryInitial"] : String.Empty)
},
logo = (!String.IsNullOrEmpty(dr["logo"].ToString()) ? dr["logo"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["projectNameTH"].ToString()) ? dr["projectNameTH"] : dr["projectNameEN"]),
en = (!String.IsNullOrEmpty(dr["projectNameEN"].ToString()) ? dr["projectNameEN"] : dr["projectNameTH"])
},
about = new {
th = (!String.IsNullOrEmpty(dr["aboutTH"].ToString()) ? dr["aboutTH"] : dr["aboutEN"]),
en = (!String.IsNullOrEmpty(dr["aboutEN"].ToString()) ? dr["aboutEN"] : dr["aboutTH"])
},
isExam = (!String.IsNullOrEmpty(dr["isExam"].ToString()) ? dr["isExam"] : String.Empty),
examType = (!String.IsNullOrEmpty(dr["examType"].ToString()) ? dr["examType"] : String.Empty),
isTeaching = (!String.IsNullOrEmpty(dr["isTeaching"].ToString()) ? dr["isTeaching"] : String.Empty)
},
description = new {
th = (!String.IsNullOrEmpty(dr["descriptionTH"].ToString()) ? dr["descriptionTH"] : dr["descriptionEN"]),
en = (!String.IsNullOrEmpty(dr["descriptionEN"].ToString()) ? dr["descriptionEN"] : dr["descriptionTH"])
},
examDate = new {
startDate = (!String.IsNullOrEmpty(dr["examStartDates"].ToString()) ? dr["examStartDates"] : String.Empty),
endDate = (!String.IsNullOrEmpty(dr["examEndDates"].ToString()) ? dr["examEndDates"] : String.Empty)
},
registrationDate = new {
startDate = (!String.IsNullOrEmpty(dr["regisStartDates"].ToString()) ? dr["regisStartDates"] : String.Empty),
endDate = (!String.IsNullOrEmpty(dr["regisEndDates"].ToString()) ? dr["regisEndDates"] : String.Empty)
},
lastPaymentDate = (!String.IsNullOrEmpty(dr["lastPaymentDates"].ToString()) ? dr["lastPaymentDates"] : String.Empty),
maximumSeat = (!String.IsNullOrEmpty(dr["maximumSeat"].ToString()) ? (int)dr["maximumSeat"] : 0),
seatReserved = dr["seatReserved"],
minimumFee = (!String.IsNullOrEmpty(dr["minimumFee"].ToString()) ? dr["minimumFee"] : String.Empty),
contactPerson = ContactPerson.GetDataSource(dr["contactPerson"].ToString()),
registrationStatus = (!String.IsNullOrEmpty(dr["registrationStatus"].ToString()) ? dr["registrationStatus"] : String.Empty),
userTypeSpecific = (!String.IsNullOrEmpty(dr["userTypeSpecific"].ToString()) ? JsonConvert.DeserializeObject <dynamic>(dr["userTypeSpecific"].ToString()) : String.Empty),
privilege = JsonConvert.DeserializeObject <dynamic>(dr["privilege"].ToString()),
sameProject = (!String.IsNullOrEmpty(dr["sameProject"].ToString()) ? dr["sameProject"].ToString() : null)
});
}
}
if (table.Equals("TransLocation"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transLocationID"].ToString()) ? dr["transLocationID"] : String.Empty),
transProjectID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
location = new {
ID = (!String.IsNullOrEmpty(dr["locationID"].ToString()) ? dr["locationID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["locationNameTH"].ToString()) ? dr["locationNameTH"] : dr["locationNameEN"]),
en = (!String.IsNullOrEmpty(dr["locationNameEN"].ToString()) ? dr["locationNameEN"] : dr["locationNameTH"])
},
building = new {
ID = (!String.IsNullOrEmpty(dr["buildingID"].ToString()) ? dr["buildingID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["buildingNameTH"].ToString()) ? dr["buildingNameTH"] : dr["buildingNameEN"]),
en = (!String.IsNullOrEmpty(dr["buildingNameEN"].ToString()) ? dr["buildingNameEN"] : dr["buildingNameTH"])
}
},
},
seatTotal = (!String.IsNullOrEmpty(dr["seatTotal"].ToString()) ? int.Parse(dr["seatTotal"].ToString()) : 0),
seatAvailable = (!String.IsNullOrEmpty(dr["seatAvailable"].ToString()) ? int.Parse(dr["seatAvailable"].ToString()) : 0)
});
}
}
if (table.Equals("TransFeeType"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transFeeTypeID"].ToString()) ? dr["transFeeTypeID"] : String.Empty),
transProjectID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
feeType = new {
ID = (!String.IsNullOrEmpty(dr["feeTypeID"].ToString()) ? dr["feeTypeID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["feeTypeNameTH"].ToString()) ? dr["feeTypeNameTH"] : dr["feeTypeNameEN"]),
en = (!String.IsNullOrEmpty(dr["feeTypeNameEN"].ToString()) ? dr["feeTypeNameEN"] : dr["feeTypeNameTH"])
},
amount = (!String.IsNullOrEmpty(dr["amount"].ToString()) ? float.Parse(dr["amount"].ToString()) : 0),
toggle = (!String.IsNullOrEmpty(dr["toggle"].ToString()) ? dr["toggle"] : String.Empty),
},
requiredStatus = (!String.IsNullOrEmpty(dr["requiredStatus"].ToString()) ? dr["requiredStatus"] : String.Empty),
isSelected = (!String.IsNullOrEmpty(dr["requiredStatus"].ToString()) ? (dr["requiredStatus"].Equals("Y") ? true : false) : false),
});
}
}
return(list);
}
public static List <object> GetDataSource(
string table,
DataTable dt
)
{
List <object> list = new List <object>();
if (table.Equals("TransRegistered"))
{
foreach (DataRow dr in dt.Rows)
{
DataTable dtCountry = Country.Get(dr["countryID"].ToString());
Object country = (dtCountry.Rows.Count > 0 ? Country.GetDataSource(dtCountry)[0] : new { });
DataTable dtProvince = Province.Get(dr["countryID"].ToString(), dr["provinceID"].ToString());
Object province = (dtProvince.Rows.Count > 0 ? Province.GetDataSource(dtProvince)[0] : new { });
DataTable dtDistrict = District.Get(dr["countryID"].ToString(), dr["provinceID"].ToString(), dr["districtID"].ToString());
Object district = (dtDistrict.Rows.Count > 0 ? District.GetDataSource(dtDistrict)[0] : new { });
DataTable dtSubdistrict = Subdistrict.Get(dr["countryID"].ToString(), dr["provinceID"].ToString(), dr["districtID"].ToString(), dr["subdistrictID"].ToString());
Object subdistrict = (dtSubdistrict.Rows.Count > 0 ? Subdistrict.GetDataSource(dtSubdistrict)[0] : new { });
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transRegisteredID"].ToString()) ? dr["transRegisteredID"] : String.Empty),
CUID = ((!String.IsNullOrEmpty(dr["transRegisteredID"].ToString()) && !String.IsNullOrEmpty(dr["transProjectID"].ToString())) ? Util.DoGetCUID(new string[] { dr["transRegisteredID"].ToString(), dr["transProjectID"].ToString() }) : String.Empty),
registeredDate = (!String.IsNullOrEmpty(dr["registeredDates"].ToString()) ? dr["registeredDates"] : String.Empty),
transProject = new {
ID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
project = new {
ID = (!String.IsNullOrEmpty(dr["projectID"].ToString()) ? dr["projectID"] : String.Empty),
category = new {
ID = (!String.IsNullOrEmpty(dr["projectCategoryID"].ToString()) ? dr["projectCategoryID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["projectCategoryNameTH"].ToString()) ? dr["projectCategoryNameTH"] : dr["projectCategoryNameEN"]),
en = (!String.IsNullOrEmpty(dr["projectCategoryNameEN"].ToString()) ? dr["projectCategoryNameEN"] : dr["projectCategoryNameTH"])
},
initial = (!String.IsNullOrEmpty(dr["projectCategoryInitial"].ToString()) ? dr["projectCategoryInitial"] : String.Empty)
},
logo = (!String.IsNullOrEmpty(dr["logo"].ToString()) ? dr["logo"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["projectNameTH"].ToString()) ? dr["projectNameTH"] : dr["projectNameEN"]),
en = (!String.IsNullOrEmpty(dr["projectNameEN"].ToString()) ? dr["projectNameEN"] : dr["projectNameTH"])
},
about = new {
th = (!String.IsNullOrEmpty(dr["aboutTH"].ToString()) ? dr["aboutTH"] : dr["aboutEN"]),
en = (!String.IsNullOrEmpty(dr["aboutEN"].ToString()) ? dr["aboutEN"] : dr["aboutTH"])
},
isExam = (!String.IsNullOrEmpty(dr["isExam"].ToString()) ? dr["isExam"] : String.Empty),
examType = (!String.IsNullOrEmpty(dr["examType"].ToString()) ? dr["examType"] : String.Empty),
isTeaching = (!String.IsNullOrEmpty(dr["isTeaching"].ToString()) ? dr["isTeaching"] : String.Empty)
},
description = new {
th = (!String.IsNullOrEmpty(dr["descriptionTH"].ToString()) ? dr["descriptionTH"] : dr["descriptionEN"]),
en = (!String.IsNullOrEmpty(dr["descriptionEN"].ToString()) ? dr["descriptionEN"] : dr["descriptionTH"])
},
examDate = new {
startDate = (!String.IsNullOrEmpty(dr["examStartDates"].ToString()) ? dr["examStartDates"] : String.Empty),
endDate = (!String.IsNullOrEmpty(dr["examEndDates"].ToString()) ? dr["examEndDates"] : String.Empty)
},
lastPaymentDate = (!String.IsNullOrEmpty(dr["lastPaymentDates"].ToString()) ? dr["lastPaymentDates"] : String.Empty),
paymentExpire = (!String.IsNullOrEmpty(dr["paymentExpire"].ToString()) ? dr["paymentExpire"] : String.Empty),
announceDate = (!String.IsNullOrEmpty(dr["announceDates"].ToString()) ? dr["announceDates"] : String.Empty),
contactPerson = ContactPerson.GetDataSource(dr["contactPerson"].ToString()),
userTypeSpecific = (!String.IsNullOrEmpty(dr["userTypeSpecific"].ToString()) ? JsonConvert.DeserializeObject <dynamic>(dr["userTypeSpecific"].ToString()) : String.Empty),
privilege = JsonConvert.DeserializeObject <dynamic>(dr["privilege"].ToString()),
sameProject = (!String.IsNullOrEmpty(dr["sameProject"].ToString()) ? dr["sameProject"].ToString() : null)
},
transLocation = new {
ID = (!String.IsNullOrEmpty(dr["transLocationID"].ToString()) ? dr["transLocationID"] : String.Empty),
location = new {
ID = (!String.IsNullOrEmpty(dr["locationID"].ToString()) ? dr["locationID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["locationNameTH"].ToString()) ? dr["locationNameTH"] : dr["locationNameEN"]),
en = (!String.IsNullOrEmpty(dr["locationNameEN"].ToString()) ? dr["locationNameEN"] : dr["locationNameTH"])
},
building = new {
ID = (!String.IsNullOrEmpty(dr["buildingID"].ToString()) ? dr["buildingID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["buildingNameTH"].ToString()) ? dr["buildingNameTH"] : dr["buildingNameEN"]),
en = (!String.IsNullOrEmpty(dr["buildingNameEN"].ToString()) ? dr["buildingNameEN"] : dr["buildingNameTH"])
}
}
}
},
transDeliAddress = new {
ID = (!String.IsNullOrEmpty(dr["transDeliAddressID"].ToString()) ? dr["transDeliAddressID"] : String.Empty),
address = (!String.IsNullOrEmpty(dr["address"].ToString()) ? dr["address"] : String.Empty),
country = country,
province = province,
district = district,
subdistrict = subdistrict,
postalCode = (!String.IsNullOrEmpty(dr["postalCode"].ToString()) ? dr["postalCode"] : String.Empty),
phoneNumber = (!String.IsNullOrEmpty(dr["phoneNumber"].ToString()) ? dr["phoneNumber"] : String.Empty)
},
invoice = new {
ID = (!String.IsNullOrEmpty(dr["invoiceID"].ToString()) ? dr["invoiceID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["invoiceNameTH"].ToString()) ? dr["invoiceNameTH"] : dr["invoiceNameEN"]),
en = (!String.IsNullOrEmpty(dr["invoiceNameEN"].ToString()) ? dr["invoiceNameEN"] : dr["invoiceNameTH"])
},
namePrintReceipt = (!String.IsNullOrEmpty(dr["invoiceNamePrintReceipt"].ToString()) ? dr["invoiceNamePrintReceipt"] : String.Empty),
billerID = (!String.IsNullOrEmpty(dr["billerID"].ToString()) ? dr["billerID"] : String.Empty),
merchantName = (!String.IsNullOrEmpty(dr["merchantName"].ToString()) ? dr["merchantName"] : String.Empty),
qrRef1 = (!String.IsNullOrEmpty(dr["qrRef_1"].ToString()) ? dr["qrRef_1"] : String.Empty),
qrRef2 = (!String.IsNullOrEmpty(dr["qrRef_2"].ToString()) ? dr["qrRef_2"] : String.Empty),
qrRef3 = (!String.IsNullOrEmpty(dr["qrRef_3"].ToString()) ? dr["qrRef_3"] : String.Empty),
qrImage = (!String.IsNullOrEmpty(dr["qrImage"].ToString()) ? dr["qrImage"] : String.Empty),
qrNewRef1 = (!String.IsNullOrEmpty(dr["qrNewRef_1"].ToString()) ? dr["qrNewRef_1"] : String.Empty),
bankRequest = (!String.IsNullOrEmpty(dr["bankRequest"].ToString()) ? dr["bankRequest"] : String.Empty),
bankTransID = (!String.IsNullOrEmpty(dr["bankTransID"].ToString()) ? dr["bankTransID"] : String.Empty),
payment = new {
amount = (!String.IsNullOrEmpty(dr["paidAmount"].ToString()) ? float.Parse(dr["paidAmount"].ToString()) : 0),
confirmDate = (!String.IsNullOrEmpty(dr["paymentConfirmDates"].ToString()) ? dr["paymentConfirmDates"] : String.Empty),
by = (!String.IsNullOrEmpty(dr["paidBy"].ToString()) ? dr["paidBy"] : String.Empty),
date = (!String.IsNullOrEmpty(dr["paidDates"].ToString()) ? dr["paidDates"] : String.Empty),
status = (!String.IsNullOrEmpty(dr["paidStatus"].ToString()) ? dr["paidStatus"] : "N")
},
privilege = new {
ID = (!String.IsNullOrEmpty(dr["privilegeID"].ToString()) ? dr["privilegeID"] : String.Empty),
promoCode = (!String.IsNullOrEmpty(dr["privilegePromoCode"].ToString()) ? dr["privilegePromoCode"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["privilegeNameTH"].ToString()) ? dr["privilegeNameTH"] : dr["privilegeNameEN"]),
en = (!String.IsNullOrEmpty(dr["privilegeNameEN"].ToString()) ? dr["privilegeNameEN"] : dr["privilegeNameTH"])
},
detail = new {
th = (!String.IsNullOrEmpty(dr["privilegeDetailTH"].ToString()) ? dr["privilegeDetailTH"] : dr["privilegeDetailEN"]),
en = (!String.IsNullOrEmpty(dr["privilegeDetailEN"].ToString()) ? dr["privilegeDetailEN"] : dr["privilegeDetailTH"])
},
discount = (!String.IsNullOrEmpty(dr["discount"].ToString()) ? float.Parse(dr["discount"].ToString()) : 0),
expiredDate = (!String.IsNullOrEmpty(dr["privilegeExpiredDates"].ToString()) ? dr["privilegeExpiredDates"] : String.Empty),
usagedDate = (!String.IsNullOrEmpty(dr["privilegeUsagedDates"].ToString()) ? dr["privilegeUsagedDates"] : String.Empty),
status = (!String.IsNullOrEmpty(dr["privilegeStatus"].ToString()) ? dr["privilegeStatus"] : String.Empty)
}
},
totalFeeAmount = (!String.IsNullOrEmpty(dr["totalFeeAmount"].ToString()) ? float.Parse(dr["totalFeeAmount"].ToString()) : 0),
seatNO = (!String.IsNullOrEmpty(dr["seatNO"].ToString()) ? dr["seatNO"] : String.Empty),
applicantNO = (!String.IsNullOrEmpty(dr["applicantNO"].ToString()) ? dr["applicantNO"] : String.Empty),
transScore = new {
eventCode = (!String.IsNullOrEmpty(dr["eventCode"].ToString()) ? dr["eventCode"] : String.Empty),
subject = (!String.IsNullOrEmpty(dr["subject"].ToString()) ? dr["subject"] : String.Empty),
applicantNo = (!String.IsNullOrEmpty(dr["applicantNO"].ToString()) ? dr["applicantNO"] : String.Empty),
adfsID = (!String.IsNullOrEmpty(dr["personID"].ToString()) ? dr["personID"] : String.Empty),
totalScore = (!String.IsNullOrEmpty(dr["totalScore"].ToString()) ? float.Parse(dr["totalScore"].ToString()).ToString("#.00") : null),
examResult = (!String.IsNullOrEmpty(dr["examResult"].ToString()) ? dr["examResult"] : String.Empty)
}
});
}
}
if (table.Equals("TransInvoiceFee"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
invoiceID = (!String.IsNullOrEmpty(dr["invoiceID"].ToString()) ? dr["invoiceID"] : String.Empty),
feeType = new {
ID = (!String.IsNullOrEmpty(dr["feeTypeID"].ToString()) ? dr["feeTypeID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["feeTypeNameTH"].ToString()) ? dr["feeTypeNameTH"] : dr["feeTypeNameEN"]),
en = (!String.IsNullOrEmpty(dr["feeTypeNameEN"].ToString()) ? dr["feeTypeNameEN"] : dr["feeTypeNameTH"])
},
amount = (!String.IsNullOrEmpty(dr["amount"].ToString()) ? float.Parse(dr["amount"].ToString()) : 0),
toggle = (!String.IsNullOrEmpty(dr["toggle"].ToString()) ? dr["toggle"] : String.Empty)
}
});
}
}
if (table.Equals("TransFeeType"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transFeeTypeID"].ToString()) ? dr["transFeeTypeID"] : String.Empty),
transProjectID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
feeType = new {
ID = (!String.IsNullOrEmpty(dr["feeTypeID"].ToString()) ? dr["feeTypeID"] : String.Empty),
name = new {
th = (!String.IsNullOrEmpty(dr["feeTypeNameTH"].ToString()) ? dr["feeTypeNameTH"] : dr["feeTypeNameEN"]),
en = (!String.IsNullOrEmpty(dr["feeTypeNameEN"].ToString()) ? dr["feeTypeNameEN"] : dr["feeTypeNameTH"])
},
amount = (!String.IsNullOrEmpty(dr["amount"].ToString()) ? float.Parse(dr["amount"].ToString()) : 0),
toggle = (!String.IsNullOrEmpty(dr["toggle"].ToString()) ? dr["toggle"] : String.Empty),
},
requiredStatus = (!String.IsNullOrEmpty(dr["requiredStatus"].ToString()) ? dr["requiredStatus"] : String.Empty),
isSelected = (!String.IsNullOrEmpty(dr["isSelected"].ToString()) ? (dr["isSelected"].Equals("Y") ? true : false) : false)
});
}
}
if (table.Equals("TransRegisteredWithTransProjectIDs"))
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new {
ID = (!String.IsNullOrEmpty(dr["transRegisteredID"].ToString()) ? dr["transRegisteredID"] : String.Empty),
registeredDate = (!String.IsNullOrEmpty(dr["registeredDates"].ToString()) ? dr["registeredDates"] : String.Empty),
transProject = new {
ID = (!String.IsNullOrEmpty(dr["transProjectID"].ToString()) ? dr["transProjectID"] : String.Empty),
project = new {
ID = (!String.IsNullOrEmpty(dr["projectID"].ToString()) ? dr["projectID"] : String.Empty),
category = new {
ID = (!String.IsNullOrEmpty(dr["projectCategoryID"].ToString()) ? dr["projectCategoryID"] : String.Empty),
}
}
}
});
}
}
return(list);
}
