public int SaveUpdateBookingCust(PlaneBook planeBook)
{
try
{
return(_planeBookRepo.SaveUpdateBookingCust(planeBook));
}
catch (Exception ex)
{
throw;
}
}
public int SaveUpdateBookingCust(PlaneBook planeBook)
{
DataTable dataTable = CheckBookStatus(planeBook.PlaneId, planeBook.Departure);
if (dataTable.Rows.Count > 0)
{
return(0);
}
else
{
if (planeBook.Id > 0)
{
string sqlQuery2 = "Update PlaneBook set PlaneId = @PlaneId, BookedBy = @BookedBy, CustomerId = @CustomerId, Departure = @Departure, Arrival = @Arrival where Id = @Id";
SqlParameter[] param2 = new SqlParameter[]
{
new SqlParameter("@Id", planeBook.Id),
new SqlParameter("@BookedBy", planeBook.BookedBy),
new SqlParameter("@PlaneId", planeBook.PlaneId),
new SqlParameter("@CustomerId", planeBook.CustomerId),
new SqlParameter("@Departure", planeBook.Departure),
new SqlParameter("@Arrival", planeBook.Arrival)
};
return(_dBO.IUD(sqlQuery2, param2, CommandType.Text));
}
else
{
string sqlQuery = "Insert into PlaneBook(BookedBy, PlaneId, CustomerId, Departure, Arrival) values(@BookedBy, @PlaneId, @CustomerId, @Departure, @Arrival)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@BookedBy", planeBook.BookedBy),
new SqlParameter("@PlaneId", planeBook.PlaneId),
new SqlParameter("@CustomerId", planeBook.CustomerId),
new SqlParameter("@Departure", planeBook.Departure),
new SqlParameter("@Arrival", planeBook.Arrival)
};
return(_dBO.IUD(sqlQuery, param, CommandType.Text));
}
}
}
private void btnSavePlaneBooking_Click(object sender, EventArgs e)
{
try
{
int custId = 0, cargoId = 0;
string bookedBy = txtBookedBy.Text.Trim();
int.TryParse(ddlPlaneName.SelectedValue.ToString(), out int planeId);
DateTime departure = dtPDeparture.Value;
DateTime arrival = dtPArrival.Value;
if (ddlPlaneType.Text == "Cargo")
{
int.TryParse(ddlCargoItem.SelectedValue.ToString(), out cargoId);
if (bookedBy == "" && planeId == 0 && cargoId == 0)
{
MessageBox.Show("Enter booked by and select plane and cargo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (bookedBy == "")
{
MessageBox.Show("Booked by field is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (planeId == 0)
{
MessageBox.Show("Select a plane", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (cargoId == 0)
{
MessageBox.Show("Select a cargo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PlaneBook planeBook = new PlaneBook
{
BookedBy = bookedBy,
PlaneId = planeId,
CargoId = cargoId,
Departure = departure
};
if (btnSavePlaneBooking.Text == "Save")
{
int bookSucc = _planeBookService.SaveUpdateBookingCargo(planeBook);
if (bookSucc > 0)
{
MessageBox.Show("Plane booked successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadAllBookingsCurrentDate();
BookingClearance();
}
else if (bookSucc == 0)
{
MessageBox.Show("Plane already booked for this time", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
planeBook.Id = bookId;
int bookSucc = _planeBookService.SaveUpdateBookingCargo(planeBook);
if (bookSucc > 0)
{
MessageBox.Show("Plane booking updated successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadAllBookingsCurrentDate();
BookingClearance();
}
else if (bookSucc == 0)
{
MessageBox.Show("Plane already booked for this time", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
else
{
int.TryParse(ddlCustName.SelectedValue.ToString(), out custId);
if (bookedBy == "" && planeId == 0 && custId == 0)
{
MessageBox.Show("Select plane and customer", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (bookedBy == "")
{
MessageBox.Show("Booked by field is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (planeId == 0)
{
MessageBox.Show("Select a plane", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (custId == 0)
{
MessageBox.Show("Select a customer", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PlaneBook planeBook = new PlaneBook
{
BookedBy = bookedBy,
PlaneId = planeId,
CustomerId = custId,
Departure = departure,
Arrival = arrival
};
if (btnSavePlaneBooking.Text == "Save")
{
int bookSucc = _planeBookService.SaveUpdateBookingCust(planeBook);
if (bookSucc > 0)
{
MessageBox.Show("Plane booked successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BookingClearance();
LoadAllBookingsCurrentDate();
}
else if (bookSucc == 0)
{
MessageBox.Show("Plane already booked for this time", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
planeBook.Id = bookId;
int bookSucc = _planeBookService.SaveUpdateBookingCust(planeBook);
if (bookSucc > 0)
{
MessageBox.Show("Plane booking updated successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BookingClearance();
LoadAllBookingsCurrentDate();
}
else if (bookSucc == 0)
{
MessageBox.Show("Plane already booked for this time", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
catch (Exception)
{
throw;
}
}
