private void PhoneNo_Button_Click(object sender, EventArgs e)
{
DafestyEntities ctx = new DafestyEntities();
var q = from x in ctx.Customers
where x.PhoneNumber == PhoneNo_TextBox.Text
select new { x.CustomerID, x.CustomerName, x.MemberCategory, x.PhoneNumber };
CustGridView.DataSource = q.ToList();
}
public RentalForm()
{
InitializeComponent();
DafestyEntities ctx = new DafestyEntities();
var t = ctx.IssueTrans.OrderByDescending(y => y.TransactionID).First();
TransId_Label.Text = (t.TransactionID + 1).ToString();
}
private void CustCheck_Button_Click(object sender, EventArgs e)
{
DafestyEntities ctx = new DafestyEntities();
var q = from x in ctx.IssueTrans
select x.CustomerID;
bool present = false;
foreach (var qry in q)
{
if (CustId_TextBox.Text == qry)
{
present = true;
var r = ctx.Customers.Where(z => z.CustomerID == qry).First();
CustName_TextBox.Text = r.CustomerName.ToString();
}
}
if (present == false)
{
CustName_TextBox.Text = "No customer found";
}
}
private void MovieCheck_Button_Click(object sender, EventArgs e)
{
DafestyEntities ctx = new DafestyEntities();
var q = from x in ctx.IssueTrans
select x.VideoCode;
bool present = false;
foreach (var qry in q)
{
if (MovieId_TextBox.Text == qry.ToString())
{
present = true;
var r = ctx.Movies.Where(z => z.VideoCode == qry).First();
MovieName_TextBox.Text = r.MovieTitle.ToString();
StockLeft_TextBox.Text = r.TotalStock.ToString();
}
}
if (present == false)
{
MovieName_TextBox.Text = "No movie found";
StockLeft_TextBox.Text = "NULL";
}
}