public void updateReservation(eReservation e)
{
tbl_Reservation temp = db.tbl_Reservations.Where(x => x.ReservationID == e.ReservationID).FirstOrDefault();
temp.ReservationDate = e.ReservationDate;
temp.CustomerID = e.CustomerID;
db.SubmitChanges();
}
public void insertReservation(eReservation e)
{
tbl_Reservation temp = new tbl_Reservation();
temp.ReservationDate = e.ReservationDate;
temp.CustomerID = e.CustomerID;
db.tbl_Reservations.InsertOnSubmit(temp);
db.SubmitChanges();
}
public List <eReservation> getAllReservation()
{
List <eReservation> ls = new List <eReservation>();
foreach (tbl_Reservation item in db.tbl_Reservations.ToList())
{
eReservation temp = new eReservation();
temp.ReservationID = item.ReservationID;
temp.CustomerID = Convert.ToInt32(item.CustomerID);
temp.ReservationDate = Convert.ToDateTime(item.ReservationDate);
ls.Add(temp);
}
return(ls);
}
public List <eReservation> getReservationByCustomerID(int cid)
{
List <eReservation> ls = new List <eReservation>();
var list = db.tbl_Reservations.Where(x => x.CustomerID == cid).ToList();
foreach (tbl_Reservation item in list)
{
eReservation temp = new eReservation();
temp.ReservationID = item.ReservationID;
temp.ReservationDate = Convert.ToDateTime(item.ReservationDate);
temp.CustomerID = Convert.ToInt32(item.CustomerID);
ls.Add(temp);
}
return(ls);
}
private void btnAdd_Click(object sender, EventArgs e)
{
eReservation er = new eReservation();
er.CustomerID = Convert.ToInt32(txtCustomerID.Text);
er.ReservationDate = Convert.ToDateTime(dtpReservation.Text);
rebll.insertReservation(er);
LoadDataGridView(dgvReservation, rebll.getAllReservation());
frmReservationTitle child = new frmReservationTitle();
child.Reservationid = Convert.ToInt32(rebll.maxReservationlID().ToString());
child.Show();
}
