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