public bool InsertCollector_Trip(Collectors_Trips ourCollector_Trip)
{
using (IDbConnection conn = Connection)
{
conn.Open();
int rowsAffected = conn.Execute(@"INSERT INTO Collectors_Trips([CollectorId],[TripId])
values (@CollectorId, @TripId)",
new { ourCollector_Trip.CollectorId, ourCollector_Trip.TripId });
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
}
public bool UpdateByTripId(Collectors_Trips ourCollector_Trip)
{
using (IDbConnection conn = Connection)
{
conn.Open();
int rowsAffected = conn.Execute(@"UPDATE [Collectors_Trips] SET [CollectorId] = @CollectorId ,[TripId] = @TripId" +
" WHERE TripId = " + ourCollector_Trip.TripId, ourCollector_Trip);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
}
public bool UpdateByTripId([FromBody] Collectors_Trips ourCollector_Trip)
{
return(_Collectors_TripsRepo.UpdateByTripId(ourCollector_Trip));
}
public bool Create([FromBody] Collectors_Trips ourCollector_Trip)
{
return(_Collectors_TripsRepo.InsertCollector_Trip(ourCollector_Trip));
}
