//method that adds the lease informaton to the lease table //once the customer selects it public static void AddLease(Lease lease) { var db = new MarinaEntities(); db.Leases.Add(lease); //add customer to the database db.SaveChanges(); // save changes }
//method for adding new customer to the database //takes the new customer object as input public static void AddCust(Customer cust) { var db = new MarinaEntities(); db.Customers.Add(cust); //add customer to the database db.SaveChanges(); // save changes }
//get all the docks from the database for the drop down list public IList GetDocks() { var db = new MarinaEntities(); var docks = db.Docks.Select(d => new { ID = d.ID, Name = d.Name }).ToList(); return(docks); }
//method to get a list of available slips for the dropdown list public IList GetSlipsAvailable(int selected) { using (var context = new MarinaEntities()) { var availableSlips = context.Slips.Where(s => s.Leases.Count == 0 && s.DockID == selected) //.Select(s => s).ToList(); .OrderBy(d => d.ID) .Select(d => new { d.ID }).ToList(); return(availableSlips); } }
//method to get the data from leases for a particular customer public IList GetSlipsGridviewCustomer(int selected) { using (var context = new MarinaEntities()) { //var customerSlips = context.Leases.Where(s => s.CustomerID == selected) // .Select(s => s).ToList(); var customerSlips = context.Leases.Where(s => s.CustomerID == selected) .OrderBy(d => d.SlipID) .Select(d => new { d.SlipID }).ToList(); return(customerSlips); } }
//this method will check if the user already exist in the database public static CustomerDTO Authenticate(string firstname, string lastname) { CustomerDTO dto = null; var db = new MarinaEntities(); //call to the database using the lambda expression var auth = db.Customers. SingleOrDefault(a => a.FirstName == firstname && a.LastName == lastname); if (auth != null) //if the customer is found { dto = new CustomerDTO // create a new DTO { ID = auth.ID, FullName = $"{auth.FirstName} {auth.LastName}" }; } return(dto); }