//@*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();
}
