public bool InsertCollector_Container(Collectors_Containers ourCollector_Container)
{
using (IDbConnection conn = Connection)
{
conn.Open();
int rowsAffected = conn.Execute(@"INSERT INTO Collectors_Containers([CollectorId],[ContainerId])
values (@CollectorId, @ContainerId)",
new { ourCollector_Container.CollectorId, ourCollector_Container.ContainerId });
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
}
public bool UpdateByContainerId(Collectors_Containers ourCollector_Container)
{
using (IDbConnection conn = Connection)
{
conn.Open();
int rowsAffected = conn.Execute(@"UPDATE [Collectors_Containers] SET [CollectorId] = @CollectorId ,[ContainerId] = @ContainerId" +
"[LastStateid]=@LastStateid WHERE ContainerId = " + ourCollector_Container.ContainerId, ourCollector_Container);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
}
public bool UpdateByContainerId([FromBody] Collectors_Containers ourCollector_Container)
{
return(_Collectors_ContainerssRepo.UpdateByContainerId(ourCollector_Container));
}
public bool Create([FromBody] Collectors_Containers ourCollector_Container)
{
return(_Collectors_ContainerssRepo.InsertCollector_Container(ourCollector_Container));
}
