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>(); }