public IQueryable <SiteSettingsViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SiteSettingsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
AboutUs = x.AboutUs,
OurGoals = x.OurGoals,
Principle = x.Principle,
Logo = x.Logo,
Map = x.Map,
Phone = x.Phone,
Adress = x.Adress,
Email = x.Email,
Fax = x.Fax,
Facebook = x.Facebook,
Twitter = x.Twitter,
Instagram = x.Twitter,
Youtube = x.Youtube,
Slider1 = x.Slider1,
Slider2 = x.Slider2,
Slider3 = x.Slider3,
Slider4 = x.Slider4,
}));
}
public IQueryable <SermonViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SermonViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Title = x.Title,
Content = x.Content,
Image = x.Image,
}));
}
public IQueryable <PublicationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new PublicationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Name = x.Name,
Description = x.Description,
Image = x.Image,
}));
}
public IQueryable <RelatedOrganizationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new RelatedOrganizationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Name = x.Name,
Adress = x.Adress,
Website = x.Website,
}));
}
public IQueryable <BoardViewModel> GetAllDirector()
{
return(_repository.GetList()
.Select(x => new BoardViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
NameSurname = x.NameSurname,
BoardType = x.BoardType,
Degree = x.Degree,
Image = x.Image,
Count = x.Count
}).Where(x => x.BoardType == (BoardType)1));
}
public IQueryable <VideoViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new VideoViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Title = x.Title,
Thumbnail = x.Thumbnail,
Url = x.Url
}));
}
public IQueryable <GeneralDonationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new GeneralDonationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
Email = x.Email,
City = x.City,
Adress = x.Adress,
PhoneNumber = x.PhoneNumber,
ZipCode = x.ZipCode,
Description = x.Description,
DonationAmount = x.DonationAmount
}));
}
public IQueryable <NewsCategoryViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new NewsCategoryViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Category = x.CategoryName
}));
}
public IQueryable <SacrificePriceViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SacrificePriceViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Price = x.Price
}));
}
public IQueryable <SubscriberViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SubscriberViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Email = x.Email
}));
}
public IQueryable <SMSTemplatesViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SMSTemplatesViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Subject = x.Subject,
Message = x.Message
}));
}
public IQueryable <AssociationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new AssociationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Count = x.Count,
Adress = x.Adress,
Image = x.Image,
}));
}
public IQueryable <SisterOrganizationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SisterOrganizationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
EstablishmentYear = x.EstablishmentYear,
Adress = x.Adress,
Website = x.Website,
}));
}
public IQueryable <UsersViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new UsersViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Degree = x.Degree,
Email = x.Email,
NameSurname = x.NameSurname,
Password = x.Password,
UserType = x.UserType
}));
}
public IQueryable <ContactRequestsViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new ContactRequestsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Email = x.Email,
Message = x.Message,
NameSurname = x.NameSurname,
Subject = x.Subject
}));
}
public IQueryable <EmailHistoryViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new EmailHistoryViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
SiteLanguage = x.SiteLanguage,
Subject = x.Subject,
ReceiverMail = x.ReceiverMail,
Message = x.Message
}));
}
public IQueryable <RansomDonationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new RansomDonationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
Email = x.Email,
City = x.City,
Adress = x.Adress,
PhoneNumber = x.PhoneNumber,
ZipCode = x.ZipCode,
AdditionalInfo = x.AdditionalInfo,
RansomAmount = x.RansomAmount
}));
}
public IQueryable <SacrificeDonationViewModel> GetAll()
{
return(_repository.GetList()
.Select(x => new SacrificeDonationViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
Email = x.Email,
City = x.City,
Adress = x.Adress,
PhoneNumber = x.PhoneNumber,
ZipCode = x.ZipCode,
Other = x.Other,
SacrificeCount = x.SacrificeCount,
SacrificeType = x.SacrificeType,
Total = x.Total
}));
}
public IQueryable <AllDonationsViewModel> GetAllDonations()
{
return(_repository.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Genel Bağış",
Phone = x.PhoneNumber,
Price = x.DonationAmount
}).Union(
_repository2.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Kurban",
Phone = x.PhoneNumber,
Price = x.Total
})
.Union(
_repository3.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Fitre",
Phone = x.PhoneNumber,
Price = x.FitreAmount
})
.Union(
_repository4.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Fidye",
Phone = x.PhoneNumber,
Price = x.RansomAmount
})
.Union(
_repository5.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Zekat",
Phone = x.PhoneNumber,
Price = x.AlmsAmount
})
.Union(
_repository6.GetList()
.Select(x => new AllDonationsViewModel
{
Id = x.Id,
Status = x.Status,
DateOfUpdate = x.DateOfUpdate,
CreationDate = x.CreationDate,
IsItDeleted = x.IsItDeleted,
Name = x.Name,
Surname = x.Surname,
DonationType = "Camilere Yardım",
Phone = x.PhoneNumber,
Price = x.DonationAmount
})))))).OrderByDescending(x => x.CreationDate));
}