public async Task <IActionResult> PutPackages(int id, Packages packages)
{
if (id != packages.PackageId)
{
return(BadRequest());
}
_context.Entry(packages).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PackagesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Edit(int id, [Bind("CustomerId,CustFirstName,CustLastName,CustAddress,CustCity,CustProv,CustPostal,CustCountry,CustHomePhone,CustBusPhone,CustEmail,AgentId,Username,Password")] Customers customers)
{
if (id != customers.CustomerId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(customers);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomersExists(customers.CustomerId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Profile)));
}
ViewData["AgentId"] = new SelectList(_context.Agents, "AgentId", "AgentId", customers.AgentId);
return(View(customers));
}
public async Task <IActionResult> Create([Bind("CustomerId,CustFirstName,CustLastName,CustAddress,CustCity,CustProv,CustPostal,CustCountry,CustHomePhone,CustBusPhone,CustEmail,AgentId,PasswordNotHashed,PasswordHashed,PasswordSalt")] Customers customers)
{
var customer = from b in _context.Customers
where b.CustEmail.Equals(customers.CustEmail)
select b;
if (customer.Count() > 0)
{
return(View("~/Views/Home/Index.cshtml"));
}
else
{
if (ModelState.IsValid)
{
_context.Add(customers);
Debug.WriteLine(_context.Customers);
await _context.SaveChangesAsync();
HttpContext.Session.SetString("userEmail", customers.CustEmail);
return(Redirect("~/"));
}
}
return(View(customers));
}
// Edits the customer given the old customer and new customer
public async Task <Customers> EditCustomer(Customers oldCustomer, CustomerForUpdateDto newCustomer)
{
// Gets old customer from db, ensures that customer has not been changed (for updatable properties)
var oldCustomerFromDB = await context.Customers
.Where(c =>
(c.CustomerId == oldCustomer.CustomerId) &&
(c.CustAddress == oldCustomer.CustAddress) &&
(c.CustCity == oldCustomer.CustCity) &&
(c.CustCountry == oldCustomer.CustCountry) &&
(c.CustFirstName == oldCustomer.CustFirstName) &&
(c.CustLastName == oldCustomer.CustLastName) &&
(c.CustPostal == oldCustomer.CustPostal) &&
(c.CustProv == oldCustomer.CustProv) &&
(c.CustHomePhone == oldCustomer.CustHomePhone) &&
(c.CustBusPhone == oldCustomer.CustBusPhone) &&
(c.CustEmail == oldCustomer.CustEmail)
).FirstOrDefaultAsync();
if (oldCustomerFromDB != null)
{
mapper.Map(newCustomer, oldCustomerFromDB); // Assigns new customer properties to old customer
await context.SaveChangesAsync(); // Saves changes
}
return(oldCustomerFromDB); // Returns updated customer from db
}
public async Task <IActionResult> PutSuppliers(int id, Suppliers suppliers)
{
if (id != suppliers.SupplierId)
{
return(BadRequest());
}
_context.Entry(suppliers).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SuppliersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Create([Bind("AgencyId,AgncyAddress,AgncyCity,AgncyProv,AgncyPostal,AgncyCountry,AgncyPhone,AgncyFax")] Agencies agencies)
{
if (ModelState.IsValid)
{
_context.Add(agencies);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(agencies));
}
public async Task <IActionResult> Create([Bind("PackageId,PkgName,PkgStartDate,PkgEndDate,PkgDesc,PkgBasePrice,PkgAgencyCommission")] Packages packages)
{
if (ModelState.IsValid)
{
_context.Add(packages);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(packages));
}
public async Task <IActionResult> Create([Bind("AgentId,AgtFirstName,AgtMiddleInitial,AgtLastName,AgtBusPhone,AgtEmail,AgtPosition,AgencyId")] Agents agents)
{
if (ModelState.IsValid)
{
_context.Add(agents);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(agents));
}
public async Task <IActionResult> Create([Bind("CustomerId,CustFirstName,CustLastName,CustAddress,CustCity,CustProv,CustPostal,CustCountry,CustHomePhone,CustBusPhone,CustEmail,Username,Password,ConfirmPassword,AgentId")] Customers customers)
{
if (ModelState.IsValid)
{
_context.Add(customers);
await _context.SaveChangesAsync();
return(RedirectToAction("Index", "Bookings"));
}
//ViewData["AgentId"] = new SelectList(_context.Agents, "AgentId", "AgentId", customers.AgentId);
return(View(customers));
}
public async Task <IActionResult> Create([Bind("BookingId,BookingDate,BookingNo,TravelerCount,CustomerId,TripTypeId,PackageId")] Bookings bookings)
{
if (ModelState.IsValid)
{
_context.Add(bookings);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CustomerId"] = new SelectList(_context.Customers, "CustomerId", "CustAddress", bookings.CustomerId);
ViewData["PackageId"] = new SelectList(_context.Packages, "PackageId", "PkgName", bookings.PackageId);
ViewData["TripTypeId"] = new SelectList(_context.TripTypes, "TripTypeId", "TripTypeId", bookings.TripTypeId);
return(View(bookings));
}
// Registers customer given customer model and password
public async Task <Customers> Register(Customers customer, string password)
{
byte[] passwordSalt; // stores password salt
byte[] passwordHash; // stores password hash
// Generates hash and salt from password
CreatePasswordHash(password, out passwordHash, out passwordSalt);
// Assigns password and salt to customer
customer.Password = Convert.ToBase64String(passwordHash);
customer.Salt = Convert.ToBase64String(passwordSalt);
// Adds customer and saves changes
await context.Customers.AddAsync(customer);
await context.SaveChangesAsync();
return(customer); // returns registered customer
}
////
/// <summary>
/// Add a new customer to database.
/// </summary>
/// <param name="newCust">Customers object need to be added.</param>
/// <returns>A bool indicate if added successfully.</returns>
public static async Task <bool> Add(Customers newCust)
{
bool isSucceed = false;
var context = new TravelExpertsContext();
context.Customers.Add(newCust);
try
{
int i = await context.SaveChangesAsync();
if (i > 0)
{
isSucceed = true;
}
}
catch (Exception e)
{
throw e;
}
return(isSucceed);
}
