public static List <License_Data.USP_GetcertificationsResult> Getcertifications(string pid)
 {
     using (License_Data.License_ConnectionDataContext ldb = new License_Data.License_ConnectionDataContext())
     {
         return(ldb.USP_Getcertifications(pid).ToList());
     }
 }
 public static List <License_Data.USP_Getcertifications_substancesResult> Getcontrolledsubstances(string pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getcertifications_substances(pid).ToList());
     }
 }
 public static List <License_Data.USP_Getcertifications_MailorderResult> GetMailOrders(string pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getcertifications_Mailorder(pid).ToList());
     }
 }
 public static List <License_Data.USP_GetotherstatelicenseResult> Getotherstatelic(string pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getotherstatelicense(pid).ToList());
     }
 }
 public static List <License_Data.USP_GetcontactsResult> GetContacts(int objid, int pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getcontacts(objid, pid).ToList());
     }
 }
 public static List <License_Data.USP_GetpharmacyempResult> GetHasPharmacy(int pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getpharmacyemp(pid).ToList());
     }
 }
 public static List <License_Data.USP_GetexamdetailsResult> GetExamDetails(string pid)
 {
     using (License_Data.License_ConnectionDataContext db = new License_Data.License_ConnectionDataContext())
     {
         return(db.USP_Getexamdetails(pid).ToList());
     }
 }
 public static List <License_Data.USP_Get_LicrenewalsResult> Getlicrenewals(string licid)
 {
     using (License_Data.License_ConnectionDataContext ldb = new License_Data.License_ConnectionDataContext())
     {
         return(ldb.USP_Get_Licrenewals(licid).ToList());
     }
 }