public static RealEstate GetById(int realtyId)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
return(context.RealEstate.FirstOrDefault(x => x.Id == realtyId));
}
}
public static IEnumerable <RealEstate> GetList(RealEstateFilter filter = null)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
if (filter == null)
{
return(context.RealEstate.ToList());
}
IQueryable <RealEstate> realtyQuery = context.RealEstate;
if (filter.RealEstateType.HasValue)
{
realtyQuery = realtyQuery.Where(x => x.Discriminator == filter.RealEstateType.ToString());
}
if (!string.IsNullOrWhiteSpace(filter.Address))
{
return(realtyQuery.ToArray().Where(x =>
LevenshteinHelper.LevenshteinDistance($"{x.City} {x.Street} {x.HouseNumber} {x.FlatNumber}", filter.Address)
<= LevenshteinHelper.ApplicationLevenshteinDistance ||
LevenshteinHelper.LevenshteinDistance(x.City + " " + x.Street, filter.Address)
<= LevenshteinHelper.ApplicationLevenshteinDistance ||
LevenshteinHelper.LevenshteinDistance(x.HouseNumber + " " + x.FlatNumber, filter.Address)
<= LevenshteinHelper.ApplicationLevenshteinMinDistance));
}
return(realtyQuery.ToList());
}
}
public static Client GetById(int clientId)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
return(context.Client.FirstOrDefault(x => x.Id == clientId));
}
}
public static void Create(RealEstate realEstate)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.RealEstate.Add(realEstate);
context.SaveChanges();
}
}
public static void Delete(RealEstate realEstate)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Entry(realEstate).State = EntityState.Deleted;
context.SaveChanges();
}
}
public static void Create(Client client)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Client.Add(client);
context.SaveChanges();
}
}
public static void Delete(Client client)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Entry(client).State = EntityState.Deleted;
context.SaveChanges();
}
}
public static void Update(RealEstate realEstate)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.RealEstate.Attach(realEstate);
context.Entry(realEstate).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void Update(Client client)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
context.Client.Attach(client);
context.Entry(client).State = EntityState.Modified;
context.SaveChanges();
}
}
public static IEnumerable <Realtor> GetList(string name = null)
{
using (AgencyDbEntities context = new AgencyDbEntities())
{
if (!string.IsNullOrEmpty(name))
{
return(context.Realtor.ToArray()
.Where(x => LevenshteinHelper.LevenshteinDistance
(x.LastName + " " + x.FirstName + " " + x.Patronymic, name)
<= LevenshteinHelper.ApplicationLevenshteinDistance ||
(x.LastName + " " + x.FirstName + " " + x.Patronymic).Contains(name))
.ToList());
}
return(context.Realtor.ToList());
}
}
