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