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); }