public UserSyncService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <UserSyncTable>();
_sqlConnection.CreateTable <ContentSyncData>();
}
public StudentCommonDataService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <AllComanDataModel>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public ContentItemTalliesScoresService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ContentItemTallyScore>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public ContentGroupService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
_sqlConnection.CreateTable <ContentGroup>();
}
public ContentCategoryItemsService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
_sqlConnection.CreateTable <ContentCategoryItem>();
}
public ContentRubricPointsService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ContentRubricPoint>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public ContentBasalCeilingsService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ContentBasalCeilings>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public ContentItemAttributesService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ContentItemAttribute>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public PermissionService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Permissions>();
_sqlAsyncConnection = _dbconnection.GetAsyncConnection();
}
public IEnumerable <UserInfo> FindAll()
{
using (var conn = _dBConnection.GetConnection())
{
try
{
conn.Open();
return(conn.Query <UserInfo>(
"SELECT [LocalID],[UserID],[OpenID],[WinCase],[TotalCase] FROM [UserInfo]"));
}
catch (Exception ex)
{
throw ex;
}
}
}
public ProductResearchCodeValuesService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ProductResearchCodeValues>();
}
public StudentFundingSourceService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <StudentFundingSources>();
}
public OrgRecordFormService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <OrganizationRecordForms>();
}
public AssessmentsService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Assessment>();
}
public ClinicalTestFormService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <StudentTestFormOverview>();
}
public StudentTestFormsService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <StudentTestForms>();
}
public ProgramNoteService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <ProgramNoteModel>();
}
public ExaminerService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <SearchStaffResponse>();
}
public LocationService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Location>();
}
public ProductService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Product>();
}
public UsersPermissionService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <PermissionsOnUsers>();
}
public UsersService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Users>();
}
public MembershipService()
{
_dbconnection = DependencyService.Get <IDBConnection>();
_sqlConnection = _dbconnection.GetConnection();
_sqlConnection.CreateTable <Membership>();
}
