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