public bool SetActiveCard(InputCard pCard)
{
var sql = @"DELETE FROM dbo.BOT_Main_card WHERE CodeClient IN (
SELECT c.CodeClient FROM dbo.client c WHERE c.MainPhone=@ShortPhone OR c.Phone=@ShortPhone or c.MainPhone=@phone or c.Phone=@phone);
INSERT INTO dbo.BOT_Main_card (CodeClient) SELECT c.CodeClient FROM dbo.client c WHERE c.BarCode=@code;";
connection.Execute(sql, pCard);
return(connection.Execute(sql, pCard) > 0);
}
public StatusData SetActiveCard(InputCard pCard)
{
msSQL.SetActiveCard(pCard);
return(new StatusData());
}