public static views.vwMafEnrollmentClosure getMAFByID(Guid id)
{
views.vwMafEnrollmentClosure maf = null;
using (SQLiteConnection conn = new SQLiteConnection(Database.DatabasePath))
{
string sql = "SELECT m.id, m.customerID, m.accountNo, m.productID, m.effectiveDate, " +
"m.closingDate, m.deceased, p.productName " +
"FROM vwMafEnrollmentClosure as m " +
"INNER JOIN vwProduct as p ON m.productID = p.productID " +
"WHERE m.id= '" + id.ToString() + "' ;";
maf = conn.Query <views.vwMafEnrollmentClosure>(sql).FirstOrDefault();
}
return(maf);
}
public claimDTO()
{
customer = new views.vwCustomer();
maf = new views.vwMafEnrollmentClosure();
claimant = new views.vwClaimant();
listCustomer = new List <views.vwCustomer>();
listMAF = new List <views.vwMafEnrollmentClosure>();
listClaimant = new List <views.vwClaimant>();
listClaimType = new List <views.vwClaimTypes>();
listSelectedClaimType = new List <views.vwClaimTypes>();
listSelectedCTCBL = new List <views.vwClaimBenefits>();
listSelectedDA = new List <views.vwDisbursementType>();
}
