private void addbtn_Click(object sender, EventArgs e)
{
BusReservationEntities db = new BusReservationEntities();
Customer customers = new Customer
{
Name = nametxt.Text,
FatherName = fnametxt.Text,
DateOfBirth = birthdate.Value,
Email = emailtext.Text,
PhoneNo = phonetxt.Text,
Address = addresstext.Text
};
if (passText.Text == passConfText.Text)
{
db.Customers.Add(customers);
db.SaveChanges();
db.Logins.Add(new Login
{
custId = customers.Id,
username = nametxt.Text,
password = passText.Text
});
db.SaveChanges();
MessageBox.Show("Customer is added");
this.Hide();
}
else
{
MessageBox.Show("Password is not match with Confrim password");
}
}
public IHttpActionResult PutUserDetails(string id, UserDetail UserDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != UserDetail.UID.ToString())
{
return(BadRequest());
}
db.Entry(UserDetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void BookBtn_Click(object sender, EventArgs e)
{
var bookData = db.TicketDetails.Where(a => a.custId == user.custId).FirstOrDefault();
if (bookData == null)
{
try
{
db.TicketDetails.Add(new TicketDetail
{
BusId = busUser.id,
custId = user.custId,
dateOfTicket = dateOfJurDt.Value,
seatNo = SelectSeat.seats
});
db.SaveChanges();
this.bookedSeat(this.selectedSeats);
MessageBox.Show(SelectSeat.seats + " Seats are booked");
new TicketInfo(user).Show();
}
catch (Exception)
{
MessageBox.Show("Please select seats First");
}
}
else
{
MessageBox.Show("You Allredy Booked a seat");
}
}
public IHttpActionResult PutPassengerDetail(int id, PassengerDetail passengerDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != passengerDetail.PNR)
{
return(BadRequest());
}
db.Entry(passengerDetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PassengerDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutTicket(int id, Ticket ticket)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != ticket.TicketID)
{
return(BadRequest());
}
db.Entry(ticket).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TicketExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostUserDetail(UserDetail UserDetail, GuestUserDetail GuestUserDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.proc_UserRegistration(GuestUserDetail.FirstName, GuestUserDetail.Lastname, GuestUserDetail.EmailId, GuestUserDetail.PhoneNumber,
UserDetail.Password, UserDetail.Gender, UserDetail.DOB, UserDetail.Address, UserDetail.State, UserDetail.City, UserDetail.Pincode);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = UserDetail.UID }, UserDetail));
}
public IHttpActionResult PutJourneyRoute(int id, JourneyRoute journeyRoute)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != journeyRoute.RouteID)
{
return(BadRequest());
}
db.Entry(journeyRoute).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!JourneyRouteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Put(int id, UserDetail changepassword)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//if (id != changepassword.UID)
//{
// return BadRequest();
//}
//db.Entry(changepassword).State = EntityState.Modified;
using (var a = new BusReservationEntities())
{
var user = a.UserDetails.Where(m => m.UID == id).FirstOrDefault <UserDetail>();
if (user != null)
{
if (changepassword.Password != null)
{
user.Password = changepassword.Password;
}
a.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok("updated password"));
}
private void SaveBtn_Click(object sender, EventArgs e)
{
this.custUser.Email = emailTxt.Text;
db.SaveChanges();
MessageBox.Show("Changings has been saved");
new CustomerMenu(user).Show();
this.Hide();
}
public IHttpActionResult PostGuestUserDetail(GuestUserDetail guestUserDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.proc_InsertGuestUserDetail(guestUserDetail.FirstName, guestUserDetail.Lastname, guestUserDetail.EmailId, guestUserDetail.PhoneNumber);
//db.tblUsers.Add(tblUser);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = guestUserDetail.GID }, guestUserDetail));
}
private void Button1_Click(object sender, EventArgs e)
{
if (ticket != null && seats != null)
{
db.TicketDetails.Remove(ticket);
for (int i = 0; i < seats.Count(); i++)
{
db.SeatInfoes.Remove(seats[i]);
}
db.SaveChanges();
MessageBox.Show("Ticket has been removed");
this.Hide();
}
}
private void updatebtn_Click(object sender, EventArgs e)
{
db = new BusReservationEntities();
Customer customers = db.Customers.Where(a => a.Id == id).FirstOrDefault();
customers.Name = nametxt.Text;
customers.FatherName = fnametxt.Text;
customers.Email = emailtext.Text;
customers.DateOfBirth = birthdate.Value;
customers.PhoneNo = phonetxt.Text;
customers.Address = addresstext.Text;
db.SaveChanges();
MessageBox.Show("Record Updated");
}
public IHttpActionResult PostRegistrationDetails(RegistrationDetails registrationDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.proc_Register(registrationDetails.FirstName, registrationDetails.Lastname, registrationDetails.EmailId, registrationDetails.PhoneNumber,
registrationDetails.Password, registrationDetails.Gender, registrationDetails.DOB, registrationDetails.Address, registrationDetails.State,
registrationDetails.City, registrationDetails.Pincode, registrationDetails.SecurityQuestion
);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = registrationDetails.UID }, registrationDetails));
}
public void DeleteFromBusInfo(int id)
{
var busDate = db.BusInfoes.Where(c => c.id == id).FirstOrDefault();
if (busDate != null)
{
try
{
db.BusInfoes.Remove(busDate);
db.SaveChanges();
}
catch (Exception) { }
}
}
public IHttpActionResult Put(int id, Ticket valuechange)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ue = new BusReservationEntities())
{
var existingdetails = ue.Tickets.Where(p => p.BookingUserID == id).FirstOrDefault <Ticket>();
if (existingdetails != null)
{
existingdetails.TicketBookingStatus = 0;
ue.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public object PostGuestUserDetail(GuestUserDetail guestUserDetail)
{
List <proc_GuestUserDetail_Result> list = new List <proc_GuestUserDetail_Result>();
foreach (var item in db.proc_GuestUserDetail())
{
list.Add(item);
}
foreach (var item in list)
{
if (item.EmailId == guestUserDetail.EmailId)
{
return("false");
}
}
var guest = db.postGuestUserDetails(guestUserDetail.FirstName, guestUserDetail.Lastname, guestUserDetail.EmailId, guestUserDetail.PhoneNumber);
//db.tblUsers.Add(tblUser);
db.SaveChanges();
return(guest);
}
public IHttpActionResult PutUser(int id, EditUser valuechange)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ue = new BusReservationEntities())
{
var existingdetails = ue.UserDetails.Where(p => p.UID == id).FirstOrDefault <UserDetail>();
if (existingdetails != null)
{
if (valuechange.PhoneNumber != null)
{
existingdetails.PhoneNumber = valuechange.PhoneNumber;
}
if (valuechange.Address != null)
{
existingdetails.Address = valuechange.Address;
}
if (valuechange.EmailId != null)
{
existingdetails.GuestUserDetail.EmailId = valuechange.EmailId;
}
if (valuechange.Password != null)
{
existingdetails.Password = valuechange.Password;
}
if (valuechange.Address == null)
{
existingdetails.Address = existingdetails.Address;
}
ue.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}