public void RegisterCompany(string name, string city, string address, string phone, string email) { using (var db = new TransportSystemDB()) { Company company = new Company() { Name = name, City = city, Address = address, PhoneNumber = phone, Email = email }; db.Companies.AddObject(company); db.SaveChanges(); } }
public bool ExistsCompany(string companyName) { using (var db = new TransportSystemDB()) { var company = from c in db.Companies where c.Name.Equals(companyName) select c; return new LinkedList<Company>(company).Count > 0; } }
public IEnumerable<string> GetCompanyNames() { IEnumerable<string> result = null; using (var db = new TransportSystemDB()) { var query = from c in db.Companies select c.Name; result = new LinkedList<string>(query); } return result; }
public void DeleteCompany(string companyName) { using (var db = new TransportSystemDB()) { var toBeDeletedCompany = from c in db.Companies where c.Name.Equals(companyName) select c; db.DeleteObject(toBeDeletedCompany.First()); db.SaveChanges(); } }
public void EditCompany(string company, string attribute, string value) { using (var db = new TransportSystemDB()) { var query = from c in db.Companies where c.Name.Equals(company) select c; Company editedCompany = query.First(); EditCompanyAttribute(attribute, editedCompany, value); db.Refresh(System.Data.Objects.RefreshMode.ClientWins, editedCompany); db.SaveChanges(); } }
public void RegisterTravel(string company, string startCity, DateTime startTime, string stop, string endCity, DateTime endTime, int ticketPrice) { using (var db = new TransportSystemDB()) { Travel travel = new Travel() { Company = company, StartCity = startCity , StartTime = startTime, EndCity = endCity, EndTime = endTime, TicketPrice = ticketPrice }; Stop intermediaryStop = new Stop() { stop1 = stop, id = travel.id }; db.Stops.AddObject(intermediaryStop); db.Travels.AddObject(travel); db.SaveChanges(); } }
public IEnumerable<TravelDAO> GetAllTravels() { LinkedList<TravelDAO> result = new LinkedList<TravelDAO>(); using (var db = new TransportSystemDB()) { var travels = from c in db.Travels select c; var stops = from c in db.Stops select c; var joinedTravels = travels.Join(stops, s => s.id, w => w.id, (s,w) => s); foreach (var travel in joinedTravels) { result.AddLast(new TravelDAO(travel.Company, travel.StartCity, travel.StartTime, new LinkedList<Stop>(travel.Stops), travel.EndCity, travel.EndTime, travel.TicketPrice)); } } return result; }