//@*coded by Larisa Steig*@ public static Customers Find(int id) { var context = new TravelExperts_Group3Context(); var owner = context.Customers.Find(id); return(owner); }
public static List <Customers> GetCustomer() { var context = new TravelExperts_Group3Context(); var customers = context.Customers.ToList(); return(customers); }
{ //@*coded by Larisa Steig*@ public static Agents Authenticate(string username, string password) { var db = new TravelExperts_Group3Context(); var customer = db.Agents.SingleOrDefault(m => m.AgtEmail == username && m.AgtPassword == password); return(customer); }
{ //@*coded by Larisa Steig*@// public static List <Packages> GetAll() { var context = new TravelExperts_Group3Context(); var packages = context.Packages.ToList(); return(packages); }
public static void Add(Bookings booking) { var context = new TravelExperts_Group3Context(); context.Bookings.Add(booking); context.SaveChanges(); }
public static Packages Find(int id) { var context = new TravelExperts_Group3Context(); var trip = context.Packages.Find(id); return(trip); }
public static void Add(Packages package) { var context = new TravelExperts_Group3Context(); context.Packages.Add(package); context.SaveChanges(); }
public static Packages GetPackagesById(int id) { var context = new TravelExperts_Group3Context(); var package = context.Packages.Find(id); return(package); }
public static Customers Authenticate(string username, string password) { var db = new TravelExperts_Group3Context(); var customer = db.Customers.SingleOrDefault(m => m.CustUserName == username && m.CustPassword == password); return(customer); }
//@*coded by Larisa Steig*@ public static Customers FindCustomerId(string name) { var context = new TravelExperts_Group3Context(); var customer = (from m in context.Customers where m.CustUserName == name select m).Single(); return(customer); }
public static void update(Packages package) { var context = new TravelExperts_Group3Context(); var originalTrip = context.Packages.Find(package.PackageId); originalTrip.PkgName = package.PkgName; originalTrip.PkgDesc = package.PkgDesc; context.SaveChanges(); }
//retrieves booking information for a customer public static List <int> GetBookingByCustomer(int CustomerId) { var context = new TravelExperts_Group3Context(); List <int> pID = (from b in context.Bookings where b.CustomerId == CustomerId select Convert.ToInt32(b.PackageId)).ToList(); return(pID); // returns package ids selected by customer }
public static bool checkCustomerExist(string username) { var db = new TravelExperts_Group3Context(); var exists = db.Customers.Any(x => x.CustUserName == username); if (!exists) { return(true); } else { return(false); } }
//@*coded by Larisa Steig*@ public static void update(Customers user) { var context = new TravelExperts_Group3Context(); var originalCustomer = context.Customers.Find(user.CustomerId); originalCustomer.CustFirstName = user.CustFirstName; originalCustomer.CustLastName = user.CustLastName; originalCustomer.CustAddress = user.CustAddress; originalCustomer.CustCity = user.CustCity; originalCustomer.CustCountry = user.CustCountry; originalCustomer.CustEmail = user.CustEmail; originalCustomer.CustBusPhone = user.CustBusPhone; originalCustomer.CustHomePhone = user.CustHomePhone; originalCustomer.CustProv = user.CustProv; originalCustomer.CustPostal = user.CustPostal; context.SaveChanges(); }