/// <summary>
/// Input datas from confirmation by restaurant
/// - change value from false to true in RestoConfirmation
/// - change value of RestoConfirmationDate to DateTime.now
/// - input comments if completed
///
/// </summary>
/// <param name="reservation"></param>
/// <returns></returns>
public bool ConfirmReservationFromResto(Reservation reservation)
{
this.RefreshDataSet();
int nbrRowsUpdated = -1;
try
{
DataRow row = dp.ds.RESERVATION.Select(string.Format("RESERVATIONID = '{0}'", reservation.Id)).FirstOrDefault();
row["RESTOCONFIRMATION"] = true;
row["RESTOCONFIRMATIONDATE"] = DateTime.Now;
row["RESTOCOMMENTS"] = reservation.RestoComments;
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter daReservation = new Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter())
{
nbrRowsUpdated = daReservation.Update(row);
}
return(nbrRowsUpdated > 0);
}
catch (System.NullReferenceException)
{
return(false);
}
}
/// <summary>
/// Only used by backoffice to change all reservation's data except foreign keys (serviceId, customerId)
/// </summary>
/// <param name="reservation"></param>
/// <returns></returns>
public bool ModifyReservationsFromBackOffice(Reservation reservation)
{
this.RefreshDataSet();
int nbrRowsUpdated = -1;
try
{
DataRow row = dp.ds.RESERVATION.Select(string.Format("RESERVATIONID = '{0}'", reservation.Id)).FirstOrDefault();
row["RESERVATIONDATE"] = reservation.ReservationDate;
row["PLACEQUANTITY"] = reservation.PlaceQuantity;
row["SERVICE"] = reservation.Service;
row["RESTOCONFIRMATION"] = reservation.RestoConfirmation;
row["RESTOCONFIRMATIONDATE"] = (reservation.RestoConfirmation == true) ? DateTime.Now : DateTime.MaxValue;
row["RESTOCOMMENTS"] = reservation.RestoComments;
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter daReservation = new Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter())
{
nbrRowsUpdated = daReservation.Update(row);
}
return(nbrRowsUpdated > 0);
}
catch (System.NullReferenceException)
{
return(false);
}
}
/// <summary>
/// This method allow customer to modify number of places reserved
/// Other datas can't be modified
/// A reservation must be deleted and recreated in place to modify customer or service
/// </summary>
/// <param name="reservation"></param>
/// <returns>bool if creation succeed</returns>
public bool ModifyReservationFromCustomer(Reservation reservation)
{
this.RefreshDataSet();
int nbrRowsUpdated = -1;
try
{
DataRow row = dp.ds.RESERVATION.Select(string.Format("RESERVATIONID = '{0}'", reservation.Id)).FirstOrDefault();
//string test = row["RESERVATIONID"].ToString();
//string test1 = row["CUSTOMERID"].ToString();
//string test2 = row["SERVICEID"].ToString();
//string test3 = row["RESERVATIONDATE"].ToString();
row["RESERVATIONDATE"] = reservation.ReservationDate;
row["SERVICE"] = reservation.Service;
row["PLACEQUANTITY"] = reservation.PlaceQuantity;
row["RESTOCONFIRMATION"] = reservation.RestoConfirmation;
row["RESTOCONFIRMATIONDATE"] = reservation.RestoConfirmationDate;
row["RESTOCOMMENTS"] = reservation.RestoComments;
row["ENABLE"] = reservation.IsEnabled;
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter daReservation = new Model.DataSetRestoBookTableAdapters.RESERVATIONTableAdapter())
{
nbrRowsUpdated = daReservation.Update(row);
}
return(nbrRowsUpdated > 0);
}
catch (System.NullReferenceException)
{
return(false);
}
}