예제 #1
0
 public static views.vwClaimBenefits getClaimBenefitByUID(Guid cblUID)
 {
     views.vwClaimBenefits cblRec = new views.vwClaimBenefits();
     using (SQLiteConnection conn = new SQLiteConnection(Database.DatabasePath))
     {
         string getCBLrec = "SELECT * FROM vwClaimBenefits WHERE id='" + cblUID.ToString() + "';";
         cblRec = conn.Query <views.vwClaimBenefits>(getCBLrec).FirstOrDefault();
     }
     return(cblRec);
 }
예제 #2
0
 public static views.vwClaimBenefits getClaimBenefitByProductClaimantClaimType(Guid productUID, string claimantType, Guid claimTypeUID)
 {
     views.vwProductClaimType pctRec = new views.vwProductClaimType();
     views.vwClaimBenefits    cblRec = new views.vwClaimBenefits();
     using (SQLiteConnection conn = new SQLiteConnection(Database.DatabasePath))
     {
         // query to get productclaimtype
         string getPCT = "SELECT * FROM vwProductClaimType WHERE productUID='" + productUID.ToString() + "' and claimantType='" + claimantType + "' and claimTypeUID='" + claimTypeUID.ToString() + "';";
         pctRec = conn.Query <views.vwProductClaimType>(getPCT).FirstOrDefault();
         if (pctRec == null)
         {
             return(cblRec);
         }
         string getCBLrec = "SELECT * FROM vwClaimBenefits WHERE productClaimTypeUID='" + pctRec.id.ToString() + "';";
         cblRec = conn.Query <views.vwClaimBenefits>(getCBLrec).FirstOrDefault();
     }
     return(cblRec);
 }