public IEnumerable <City> GetAll()
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Cities
select t);
return(obj.Select(a => new City()
{
CityId = a.CityId,
CityName = a.CityName
}));
}
public IEnumerable <Classification> GetAll()
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Classifications
select t);
return(obj.Select(a => new Classification()
{
ClassificationId = a.ClassificationId,
ClassificationName = a.ClassificationName
}));
}
public IEnumerable <User> GetAll(bool isAdmin)
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Users
where t.IsAdmin == isAdmin
select t);
return(obj.Select(a => new User()
{
UserId = a.UserId,
Name = a.Name
}));
}
public IEnumerable <Region> GetAll(Guid?cityId = default(Guid?))
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Regions
where cityId.HasValue ? t.CityId == cityId.Value : 1 == 1
select t);
return(obj.Select(a => new Region()
{
RegionId = a.RegionId,
RegionName = a.RegionName,
City = new City()
{
CityId = a.City.CityId, CityName = a.City.CityName
}
}));
}
public User Authenticate(string userEmail)
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Users
where t.Email == userEmail
select t).FirstOrDefault();
User user = new User();
if (obj != null)
{
user.UserId = obj.UserId;
user.Name = obj.Name;
user.Password = obj.Password;
user.Email = obj.Email;
user.IsAdmin = obj.IsAdmin ?? false;
}
return(user);
}
public IEnumerable <Client> GetAll(string Name, string Gender, Guid?SelectedCityGUID,
Guid?SelectedRegionGUID, DateTime?LastPurchaseFrom, DateTime?LastPurchaseTo,
Guid?SelectedClassificationGUID, Guid?SelectedSellerGUID)
{
PraticalTestDbContext context = new PraticalTestDbContext();
var obj = (from t in context.Clients
select t);
if (!string.IsNullOrEmpty(Name))
{
obj = obj.Where(a => a.Name == Name);
}
if (!string.IsNullOrEmpty(Gender))
{
obj = obj.Where(a => a.Gender == Gender);
}
if (SelectedRegionGUID.HasValue && SelectedRegionGUID.Value != Guid.Empty)
{
obj = obj.Where(a => a.RegionId == SelectedRegionGUID);
}
if (LastPurchaseFrom.HasValue && LastPurchaseFrom != DateTime.MinValue)
{
obj = obj.Where(a => a.LastPurchase > LastPurchaseFrom);
}
if (LastPurchaseTo.HasValue && LastPurchaseTo != DateTime.MinValue)
{
obj = obj.Where(a => a.LastPurchase < LastPurchaseTo);
}
if (SelectedClassificationGUID.HasValue && SelectedClassificationGUID.Value != Guid.Empty)
{
obj = obj.Where(a => a.ClassificationId == SelectedClassificationGUID);
}
if (SelectedSellerGUID.HasValue && SelectedSellerGUID.Value != Guid.Empty)
{
obj = obj.Where(a => a.SellerId == SelectedSellerGUID);
}
return(obj.Select(a => new Client()
{
ClientId = a.ClientId,
Name = a.Name,
Phone = a.Phone,
Gender = a.Gender,
LastPurchase = a.LastPurchase,
Seller = new User()
{
UserId = a.Seller.UserId,
Name = a.Seller.Name
},
Region = new Region()
{
RegionId = a.Region.RegionId,
RegionName = a.Region.RegionName,
CityId = a.Region.CityId,
City = new City()
{
CityId = a.Region.City.CityId,
CityName = a.Region.City.CityName
}
},
Classification = new Classification()
{
ClassificationId = a.Classification.ClassificationId,
ClassificationName = a.Classification.ClassificationName
},
Address = a.Address,
Occupation = a.Occupation
}));
}
