protected void Page_Load(object sender, EventArgs e)
{
var db = new MarinaEntities();
uxCustomers.DataSource = db.Customers.ToList();
uxCustomers.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
// grab slipID from the slip ID column
var slipID = int.Parse(GridView1.SelectedRow.Cells[0].Text);
// grab userID from session
var userID = int.Parse(Session["CustomerID"].ToString());
// using entity framework
using (var context = new MarinaEntities())
{
// grab the selected slip from context, as well as user
var slip = (from s in context.Slips where s.ID == slipID select s).First();
var user = (from c in context.Customers where c.ID == userID select c).First();
// add new slip booking into leases table
context.Leases.Add(new Lease()
{
CustomerID = user.ID,
SlipID = slip.ID
});
context.SaveChanges();
}
Response.Redirect("Panel.aspx");
}
//Binding the dropdown with the grid
protected void cboDock_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new MarinaEntities();
int dockID = Convert.ToInt32(cboDock.SelectedValue);
grdSlip.DataSource = db.Slips.Where(s => s.DockID == dockID).ToList();
grdSlip.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var db = new MarinaEntities();
uxDocks.DataSource = db.Docks.ToList();
uxDocks.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = Convert.ToInt32(Session["CustomerID"]);
var db = new MarinaEntities();
var lease = db.Leases.Where(l => l.CustomerID == id).ToList();
grdLeased.DataSource = lease;
DataBind();
}
}
protected void grdSlip_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new MarinaEntities();
var lease = new Lease();
lease.CustomerID = Convert.ToInt32(Session["CustomerID"]);
lease.SlipID = Convert.ToInt32(grdSlip.SelectedRow.Cells[1].Text);
db.Leases.Add(lease);
db.SaveChanges();
Response.Redirect("~/MyLease");
}
protected void uxPurchase_Click(object sender, EventArgs e)
{
int customerID = Convert.ToInt32(Session["CustomerID"]);
int slipID = Convert.ToInt32(DropDownSlips.SelectedValue);
var db = new MarinaEntities();
var lease = new Lease {
SlipID = slipID, CustomerID = customerID
};
db.Leases.Add(lease);
db.SaveChanges();
uxLeaseHistory.DataSource = MarinaManager.GetLeasesByCustomerID(customerID);
uxLeaseHistory.DataBind();
}
protected void ddDocks_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new MarinaEntities();
var id = Convert.ToInt32(ddDocks.SelectedValue); // get Id from the drop down list
//search for dock with the selected id
Dock dock = DocksManager.Find(id);
Dock = dock;
var availableSlips = db.Slips.Where(s =>
s.Leases.Count == 0 && s.DockID == Dock.ID).ToList();
grdSlip.DataSource = availableSlips;
grdSlip.DataBind();
}
protected void btnLease_Click(object sender, EventArgs e)
{
int customerID = Convert.ToInt32(Session["CustomerID"]);
int slipID = Convert.ToInt32(dropDownSlips.SelectedValue);
var db = new MarinaEntities();
var auth = new Lease {
SlipID = slipID, CustomerID = customerID
};
db.Leases.Add(auth);
db.SaveChanges();
gridViewLease.DataSource = MainManager.GetLeaseByCustomerID(customerID);
gridViewLease.DataBind();
}
//Adding customer
protected void btnSubmit_Click(object sender, EventArgs e)
{
var customer = new Customer
{
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
City = txtCity.Text,
Phone = txtPhone.Text
};
var db = new MarinaEntities();
db.Customers.Add(customer);
db.SaveChanges();
Response.Redirect("~/Registration");
}
/// <summary>
/// Check if user is authenticated, if they aren't send to login, if they are then load
/// the available slips from the database.
/// </summary>
protected void Page_Load(object sender, EventArgs e)
{
// If user isn't authenticated, send to login screen
if (!Util.IsAuthenticated(Session))
{
Response.Redirect("Login.aspx");
}
// Using entity framework
using (var context = new MarinaEntities())
{
// grab slips and leases
var slips = context.Slips;
var leases = context.Leases;
// grab userID from session
var userID = int.Parse(Session["CustomerID"].ToString());
// get leased slips list
var leased = from slip
in slips
join lease
in leases
on slip.ID equals lease.SlipID
select slip;
var customerLeased = from lease
in leases
where lease.CustomerID == userID
select lease;
var customerLeasedSlips = from slip
in slips
join lease
in customerLeased
on slip.ID equals lease.SlipID
where lease.CustomerID == userID
select slip;
// set data source to slips except leased
GridView1.DataSource = slips.Except(leased).ToList();
GridView1.DataBind();
GridView2.DataSource = customerLeasedSlips.ToList();
GridView2.DataBind();
}
}
protected void Button_Submit_Click(object sender, EventArgs e)
{
Customer customer;
// Textbox inputs
var inputName = TextBox_Name.Text;
var inputPassword = Util.Encrypt(TextBox_Password.Text);
var inputLName = TextBox_LName.Text;
// Create new marina context
using (var context = new MarinaEntities())
{
// Query context to see is passwords match
var query = from c
in context.Customers
where c.Password == inputPassword && c.FirstName == inputName && c.LastName == inputLName
select c;
// First response is our guy
if (query != null && query.First() != null)
{
customer = query.First();
}
else
{
return;
}
// Reset form if failed
if (customer == null)
{
Button_Register_Click(sender, e);
}
// Authenticate user
Session["IsAuthenticated"] = true;
Session["CustomerID"] = customer.ID;
Session["CustomerName"] = customer.FirstName + " " + customer.LastName;
// Redirect to home
Response.Redirect("/Default.aspx");
}
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
// grab slipID from the slip ID column
var slipID = int.Parse(GridView2.SelectedRow.Cells[0].Text);
// grab userID from session
var userID = int.Parse(Session["CustomerID"].ToString());
// using entity framework
using (var context = new MarinaEntities())
{
// grab the selected slip from context, as well as user
var lease = (from l in context.Leases where l.CustomerID == userID select l).First();
var user = (from c in context.Customers where c.ID == userID select c).First();
context.Leases.Remove(lease);
context.SaveChanges();
}
Response.Redirect("Panel.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
var db = new MarinaEntities();
var user = MainManager.Authenticate(txtFirstName.Text, txtLastName.Text);
if (user == null)
{
var auth = new Customer
{
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
City = txtCity.Text,
Phone = txtPhone.Text
};
db.Customers.Add(auth);
}
db.SaveChanges();
FormsAuthentication.SignOut();
Response.Redirect("~/Login");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
var db = new MarinaEntities();
var customer = CustomersManager.Authenticate(uxFirstName.Text, uxLastName.Text);
if (customer == null) // if new customer, add the customer to the DB
{
Customer cust = new Customer
{
FirstName = uxFirstName.Text,
LastName = uxLastName.Text,
Phone = uxPhone.Text,
City = uxCity.Text
};
CustomersManager.Add(cust);
// Response.Redirect("~/");
}
//at this point, student is not null meaning we have a valid authentication
//so add student id to session
Session.Add("CustomerID", customer.ID);
// redirect - false means no persistent cookie
FormsAuthentication.RedirectFromLoginPage(customer.FullName, false);
Response.Redirect("~/MyLease");
}
