TrainNotifier.Service.ScheduleRepository.DeleteSchedule C# (CSharp) Method

        public void DeleteSchedule(ScheduleTrain train)
        {
            const string sql = @"
                UPDATE [natrail].[dbo].[ScheduleTrain]
                SET [Deleted] = 1
                WHERE [TrainUid] = @TrainUid
                    AND [StartDate] = @StartDate
                    AND [STPIndicatorId] = @STPIndicator";

            ExecuteNonQuery(sql, new
            {
                train.TrainUid,
                train.StartDate,
                train.STPIndicator
            });
        }

 private static void AddSchedule(IEnumerable<TiplocCode> tiplocs, ScheduleRepository schedrep, dynamic rowData)
 {
     ScheduleTrain train = ScheduleTrainMapper.ParseJsonTrain(rowData.JsonScheduleV1, tiplocs);
     switch (train.TransactionType)
     {
         case TransactionType.Create:
             schedrep.InsertSchedule(train);
             Trace.TraceInformation("Inserted Train UID {0}, Indicator {1}", train.TrainUid, train.STPIndicator);
             break;
         case TransactionType.Delete:
             schedrep.DeleteSchedule(train);
             Trace.TraceInformation("Deleted Train UID {0}, Indicator {1}, Date {2:dd/MM/yyyy}", train.TrainUid, train.STPIndicator, train.StartDate);
             break;
     }
 }