private void button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(Seattxt.Text) <= 200)
{
if (AvailableSeat() == true)
{
Reservation reservation = new Reservation();
reservation.CustomerID = Convert.ToInt32(CustomerIDtxt.Text);
reservation.DateOfDeparture = dateTime.Value;
reservation.RouteID = Convert.ToInt32(Routetxt.Text);
reservation.SeatNr = Convert.ToInt32(Seattxt.Text);
db.Reservations.Add(reservation);
db.SaveChanges();
MessageBox.Show("Ticket Booked Successfully");
}
else
{
MessageBox.Show("Seat is already reserved");
}
}
else
{
MessageBox.Show("Seat number invalid");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
model.First_Name = textFName.Text.Trim();
model.Last_Name = textLName.Text.Trim();
model.Birthday = textBirthday.Text.Trim();
model.City = textCity.Text.Trim();
model.Phone = textPhone.Text.Trim();
model.E_mail = textMail.Text.Trim();
using (RailwayDbEntities db = new RailwayDbEntities())
{
if (model.CustomerID == 0)
{
db.Customers.Add(model);
}
else
{
db.Entry(model).State = EntityState.Modified;
}
db.SaveChanges();
}
Clear();
PopulateDataGrid();
MessageBox.Show("Submitted Succesfully !");
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete ?", "Delete Operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (RailwayDbEntities db = new RailwayDbEntities())
{
var entry = db.Entry(model);
if (entry.State == EntityState.Detached)
{
db.Customers.Attach(model);
}
db.Customers.Remove(model);
db.SaveChanges();
PopulateDataGrid();
Clear();
MessageBox.Show("Deleted Successfully !");
}
}
}
private void button2_Click(object sender, EventArgs e)
{
// common.Logger.OpenLogger();
//common.Logger.LogThisLine(MethodBase.GetCurrentMethod().Name);
Route rd = new Route();
rd.TrainCode = CodeText.Text;
rd.DepartureCity = departureText.Text;
rd.ArrivalCity = arrivalText.Text;
rd.DepartureTime = DepartTimeText.Text;
rd.ArrivalTime = ArrivTimeText.Text;
rd.Class = ClassText.Text;
rd.Seat = Convert.ToInt32(SeatText.Text);
rd.Price = Convert.ToDecimal(PriceText.Text);
db.Routes.Add(rd);
db.SaveChanges();
MessageBox.Show("New route added successfully !");
Clear();
// common.Logger.CloseLogger();
}