public void DeleteRealtor(int ID)
{
using (var database = new EstateBrokerContext())
{
database.Realtors.Remove(database.Realtors.Find(ID));
database.SaveChanges();
}
}
public void UpdateRealtor(int ID, string name, string phoneNR)
{
using (var database = new EstateBrokerContext())
{
Realtor realtor = database.Realtors.Find(ID);
realtor.Name = name;
realtor.PhoneNR = phoneNR;
database.SaveChanges();
}
}
public void CreateRealtor(string name, string phoneNR)
{
var database = new EstateBrokerContext();
var realtor = new Realtor()
{
Name = name,
PhoneNR = phoneNR
};
database.Realtors.Add(realtor);
database.SaveChanges();
}
public int CreateCase(DateTime creationDate, double price, int realtorID)
{
using (var database = new EstateBrokerContext())
{
var workingCase = new Case()
{
CreationDate = creationDate,
Price = price,
RealtorID = realtorID
};
database.Cases.Add(workingCase);
database.SaveChanges();
return(workingCase.CaseID);
}
}
public bool UpdateCase(int ID, DateTime creationDate, DateTime?closedDate, double price, int realtorID)
{
try
{
using (var database = new EstateBrokerContext())
{
Database.Case workingCase = database.Cases.Find(ID);
workingCase.CreationDate = creationDate;
workingCase.ClosedDate = closedDate;
workingCase.Price = price;
workingCase.RealtorID = realtorID;
database.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public List <Entities.Case> ReadCasesInPostalCode(int postalCode)
{
using (var database = new EstateBrokerContext())
{
List <Entities.Case> cases = new List <Entities.Case>();
List <Database.Property> properties = new List <Database.Property>();
if (database.Properties.Any(s => s.PostalCode == postalCode) == true)
{
properties = database.Properties.Where(s => s.PostalCode == postalCode).ToList();
}
foreach (var item in properties)
{
cases.Add((Entities.Case)CaseFactory.CreateCase(database.Cases.Find(item.CaseID)));
}
database.SaveChanges();
return(cases);
}
}