public async Task <IEnumerable <AnnualReportTableObject> > GetAnnualReportsAsync(string userId, bool isAdmin, string searchdata, int page, int pageSize, int sortKey, bool auth)
{
var items = EPlastDBContext.Set <AnnualReportTableObject>().FromSqlRaw(
"dbo.getCityAnnualReportsInfo @userId={0}, @AdminRole={1}, @searchData = {2}, @PageIndex ={3}, @PageSize={4}, @sort={5}, @auth={6}",
userId, isAdmin ? 1 : 0, searchdata, page, pageSize, sortKey, auth ? 1 : 0);
return(items);
}
public async Task <IEnumerable <RegionMembersInfoTableObject> > GetRegionMembersInfoAsync(int regionId, int year, bool?getGeneral,
int?page, int?pageSize)
{
var items = EPlastDBContext.Set <RegionMembersInfoTableObject>().FromSqlRaw(
"dbo.GetRegionMembersInfo @regionId={0}, @year={1}, @GetGeneral={2}, @PageIndex ={3}, @PageSize={4}",
regionId, year, getGeneral, page, pageSize);
return(items);
}
public async Task <Tuple <IEnumerable <UserTableObject>, int> > GetUserTableObjects(int pageNum, int pageSize, string tab, string regions, string cities, string clubs, string degrees, string searchData)
{
var items = EPlastDBContext.Set <UserTableObject>().FromSqlRaw("dbo.usp_GetUserInfo @PageIndex = {0}, @PageSize = {1}, @tab = {2}, @filterRegion = {3}, " +
"@filterCity = {4}, @filterClub = {5}, @filterDegree = {6}, @searchData = {7}", pageNum, pageSize, tab, regions, cities, clubs, degrees, searchData);
var num = items.Select(u => u.Count).ToList();
int rowCount = num[0];
return(new Tuple <IEnumerable <UserTableObject>, int>(items, rowCount));
}
public MethodicDocumentRepository(EPlastDBContext dbContext) : base(dbContext)
{
}
public EventCategoryRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public NotificationTypeRepository(EPlastDBContext dbContext) : base(dbContext)
{
}
public RepositoryWrapper(EPlastDBContext ePlastDBContext)
{
_dbContext = ePlastDBContext;
}
public UserRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public UserPrecautionRepository(EPlastDBContext dBContext)
: base(dBContext)
{
}
public RegionAdministrationRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public RegionAnnualReportRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public AdminTypeRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public ClubRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public EventAdminRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public NationalityRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public DocumentTemplateRepository(EPlastDBContext dbContext) : base(dbContext)
{
}
public UserMembershipDatesRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public ClubAnnualReportRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public IEnumerable <UserTableObject> GetUserTableObjects(int pageNum, int pageSize)
{
return(EPlastDBContext.Set <UserTableObject>().FromSqlRaw("dbo.usp_GetUserInfo @PageIndex = {0}, @PageSize = {1}", pageNum, pageSize));
}
public CityManagementsRepository(EPlastDBContext dBContext)
: base(dBContext)
{
}
public MembersStatisticsRepository(EPlastDBContext dBContext)
: base(dBContext)
{
}
public CityLegalStatusesRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public AnnualReportsRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public RepositoryBase(EPlastDBContext ePlastDBContext)
{
this.EPlastDBContext = ePlastDBContext;
}
public RegionRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public CityMembersRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public GoverningBodyDocumentsRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public EventTypeRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public EventStatusRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
public GallaryRepository(EPlastDBContext dbContext)
: base(dbContext)
{
}
