public bool Insert(ReservationCreationEntity r)
{
List <ParmStruct> parms = new List <ParmStruct>();
parms.Add(new ParmStruct("@ConfirmMsg", SqlDbType.NVarChar, 500, "", ParameterDirection.Output));
parms.Add(new ParmStruct("@CheckInDate", SqlDbType.DateTime2, 0, r.Reservation.CheckInDate, ParameterDirection.Input));
parms.Add(new ParmStruct("@CheckOutDate", SqlDbType.DateTime2, 0, r.Reservation.CheckOutDate, ParameterDirection.Input));
parms.Add(new ParmStruct("@NumOfAdults", SqlDbType.Int, 0, r.Reservation.NumOfAdults, ParameterDirection.Input));
parms.Add(new ParmStruct("@NumOfChildren", SqlDbType.Int, 0, r.Reservation.NumOfChildren, ParameterDirection.Input));
parms.Add(new ParmStruct("@RoomNumber", SqlDbType.Int, 0, r.Reservation.RoomNumber, ParameterDirection.Input));
parms.Add(new ParmStruct("@FirstName", SqlDbType.NVarChar, 30, r.Reservation.Guest.FirstName, ParameterDirection.Input));
parms.Add(new ParmStruct("@MiddleName", SqlDbType.NVarChar, 20, r.Reservation.Guest.MiddleName, ParameterDirection.Input));
parms.Add(new ParmStruct("@LastName", SqlDbType.NVarChar, 50, r.Reservation.Guest.LastName, ParameterDirection.Input));
parms.Add(new ParmStruct("@Street", SqlDbType.NVarChar, 50, r.Reservation.Guest.Street, ParameterDirection.Input));
parms.Add(new ParmStruct("@City", SqlDbType.NVarChar, 50, r.Reservation.Guest.City, ParameterDirection.Input));
parms.Add(new ParmStruct("@StateId", SqlDbType.Int, 0, r.Reservation.Guest.StateId, ParameterDirection.Input));
parms.Add(new ParmStruct("@CountryId", SqlDbType.Int, 0, r.Reservation.Guest.CountryId, ParameterDirection.Input));
parms.Add(new ParmStruct("@PostalCode", SqlDbType.NVarChar, 20, r.Reservation.Guest.PostalCode, ParameterDirection.Input));
parms.Add(new ParmStruct("@HomePhone", SqlDbType.NVarChar, 20, r.Reservation.Guest.HomePhone, ParameterDirection.Input));
parms.Add(new ParmStruct("@CellPhone", SqlDbType.NVarChar, 20, r.Reservation.Guest.CellPhone, ParameterDirection.Input));
parms.Add(new ParmStruct("@Email", SqlDbType.NVarChar, 20, r.Reservation.Guest.Email, ParameterDirection.Input));
parms.Add(new ParmStruct("@DateOfBirth", SqlDbType.NVarChar, 20, r.Reservation.Guest.DateOfBirth, ParameterDirection.Input));
parms.Add(new ParmStruct("@ClerkId", SqlDbType.Int, 00, r.Reservation.ClerkId, ParameterDirection.Input));
if (db.SendData("spInsertReservation", parms) > 0)
{
r.ConfirmMessage = parms[0].Value.ToString();
return(true);
}
return(false);
}
private void btnCreateReservation_Click(object sender, EventArgs e)
{
try
{
ReservationService service = new ReservationService();
ReservationCreationEntity reservation = new ReservationCreationEntity
{
Reservation = PopulateReservationObject()
};
if (service.AddReservation(reservation))
{
MessageBox.Show(reservation.ConfirmMessage, "Reservation Creation Completed");
ClearGuestForm();
ClearForm();
}
else
{
string errorMsg = "";
foreach(ValidationError error in reservation.Reservation.Errors)
{
errorMsg += error.Description + Environment.NewLine;
}
MessageBox.Show(errorMsg, "Missing Information", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool AddReservation(ReservationCreationEntity r)
{
if (Validate(r.Reservation, r.Reservation.Guest))
{
return(repo.Insert(r));
}
return(false);
}
