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); } }