public int Save(CanceledSchedual canceledSchedual)
{
const string sql = @"EXECUTE Flight.ProcAddCanceledSchedual @FlightNumber, @FlightDate, @DeparturAirport, @ArrivalAirport;";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("FlightNumber", canceledSchedual.Schedual.FlightNumber.ToString());
dbOperator.AddParameter("FlightDate", canceledSchedual.FlightDate);
dbOperator.AddParameter("DeparturAirport", canceledSchedual.Schedual.DepartureAirport);
dbOperator.AddParameter("ArrivalAirport", canceledSchedual.Schedual.ArrivalAirport);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public static bool AddCanceledFlightSchedual(CanceledSchedual flightSchedual)
{
var schedualRepository = Factory.CreateFlightSchedualRepository();
return(schedualRepository.Save(flightSchedual) == 0);
}
