protected void LeaseBtn_Click(object sender, EventArgs e)
{
List <Slip> sls = new List <Slip>();
//Slip sl = new Slip();
Lease l = new Lease();
using (SlipDataContext dbContent = new SlipDataContext())
{
var selectedSlips = from ls in dbContent.Leases
join c in dbContent.Customers on ls.CustomerID equals c.ID
join s in dbContent.Slips on ls.SlipID equals s.ID
join d in dbContent.Docks on s.DockID equals d.ID
select new
{
s.ID,
s.Width,
s.Length,
d.Name,
c.LastName
};
LeaseStatusGridView.DataSource = selectedSlips;
LeaseStatusGridView.DataBind();
LeaseStatusLabel.Visible = true;
LeaseStatusGridView.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <Slip> sls = new List <Slip>();
//Slip sl = new Slip();
//Lease l = new Lease();
using (SlipDataContext dbContent = new SlipDataContext())
{
var selectedSlips = from sl in dbContent.Slips
join d in dbContent.Docks
on sl.DockID equals d.ID
join ls in dbContent.Leases
on sl.ID equals ls.SlipID
//join s in dbContent.Slips on ls.SlipID equals s.ID
//join d in dbContent.Docks on s.DockID equals d.ID
into empLeases
from cu in empLeases.DefaultIfEmpty()
select new
{
sl.ID,
sl.Width,
sl.Length,
d.Name,
Slip_Status = cu == null?"Available":("Occupy")
};
availableSlipsGridView.DataSource = selectedSlips;
availableSlipsGridView.DataBind();
}
}
private Slip GetSelectedSlip()
{
Slip s = new Slip();
GridViewRow gr = SlipGridView.SelectedRow;
int slipID = Convert.ToInt32(gr.Cells[1].Text);
using (SlipDataContext dbContext = new SlipDataContext())
{
s = (from p in dbContext.Slips
where p.ID == slipID
select p).Single();
}
return(s);
}