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 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"); }
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"); }