protected void GridViewSlip_Available() { GridViewRow dock = GridViewDock0.SelectedRow; LblSelectedDock.Text = dock.Cells[1].Text; List <Slip> slip_CurrentDock = SlipDB.GetSlips(Convert.ToInt32(dock.Cells[0].Text)); List <Lease> lease_CurrentLeased = LeaseDB.GetLeases(); List <Slip> slip_Available = new List <Slip>(); bool aFlag = true; foreach (var i in slip_CurrentDock) { aFlag = true; foreach (var j in lease_CurrentLeased) { if (i.ID == j.SlipID) { aFlag = false; break; } } if (aFlag) { slip_Available.Add(i); } } GridViewSlip0.DataSource = slip_Available; GridViewSlip0.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int customerID; try { /* * GridViewDock0.DataSource = DockDB.GetDocks(); * GridViewDock0.DataBind(); * 20190517 commented because these are setting up on page */ GridViewSlip_Available(); if (HttpContext.Current.Session["ID"] != null) { customerID = Convert.ToInt32(HttpContext.Current.Session["ID"]); LblCustomerName.Text = CustomerDB.GetCustomer(customerID).FirstName + " " + CustomerDB.GetCustomer(customerID).LastName; GridViewCurrentLease.DataSource = LeaseDB.GetLeasesByCustomerID(customerID); GridViewCurrentLease.DataBind(); } } catch (Exception ex) { LblDockWarning.Visible = true; LblDockWarning.Text = "Dock" + " " + ex.Message; // more ... } }
/// <summary> /// Processes all click events within slip grid view /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void slipsGridView_RowCommand(object sender, GridViewCommandEventArgs e) { try { // For lease click (assigned to new button) if (e.CommandName == "New") { if (customerId < 0) // If customer id is invalid dont run method { return; } // Get slip id from active row int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = slipsGridView.Rows[index]; int slipId = Convert.ToInt32(row.Cells[0].Text); // Lease slip in DB LeaseDB.LeaseSlip(customerId, slipId); // Refresh grid views leasedSlipsGridView.DataBind(); slipsGridView.DataBind(); } } catch (Exception) { errorLabel2.Visible = true; } }
/// <summary> /// Performs a insert operation to the lease table in the DB with the provided slip /// </summary> /// <param name="slip"></param> private void InsertNewLeaseDB(Slip slip) { //get the customer id for the logged in user from the DB Customer customer = CustomerDB.GetCustomer(Session["UserName"].ToString()); // e.Row.Cells[colIndex].BackColor = Color.FromName("#ffeb9c"); LeaseDB.InsertLease(slip, customer); //refresh gridviews RefreshDataBindings(); }
protected void Button1_Click(object sender, EventArgs e) { if (HttpContext.Current.Session["ID"] != null) { GridViewRow dock = GridViewSlip0.SelectedRow; LeaseDB.AddLease(Convert.ToInt32(dock.Cells[0].Text), Convert.ToInt32(HttpContext.Current.Session["ID"])); GridViewCurrentLease.DataSource = LeaseDB.GetLeasesByCustomerID( Convert.ToInt32(HttpContext.Current.Session["ID"])); GridViewCurrentLease.DataBind(); GridViewSlip_Available(); } else { LblPromptSignIn.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Session["ID"] != null) { int id = Convert.ToInt32(HttpContext.Current.Session["ID"]); Customer customer = new Customer(); customer = CustomerDB.GetCustomer(id); Label1.Text = customer.ID.ToString(); Label2.Text = customer.FirstName + " " + customer.LastName; Label4.Text = customer.Phone; Label5.Text = customer.City; Label6.Text = customer.FirstName + " " + customer.LastName; int customerID = Convert.ToInt32(HttpContext.Current.Session["ID"]); GridViewCurrentLease.DataSource = LeaseDB.GetLeasesByCustomerID(customerID); GridViewCurrentLease.DataBind(); } }