public async Task Remover(IEnumerable <Guid> listaIds)
{
var sql = @"DELETE FROM ProvisaoCobertura
WHERE Id IN @Ids
AND Id NOT IN (SELECT ProvisaoCoberturaId FROM MovimentoProvisaoPremio WHERE ProvisaoCoberturaId in @Ids)";
await CreateCommand.ExecuteAsync(sql, new { Ids = listaIds });
}
public async Task Remover(Guid identificador)
{
var sql = @"DELETE C
FROM Evento E
INNER JOIN CoberturaContratada C ON C.EventoId = E.Id
WHERE E.Identificador = @Id";
await CreateCommand.ExecuteAsync(sql, new { Id = identificador });
}
public async Task Remover(Guid identificador)
{
var sql = @"DELETE P
FROM Evento E
INNER JOIN Premio P ON P.EventoId = E.Id
WHERE E.Identificador = @Identificador";
await CreateCommand.ExecuteAsync(sql, new { Identificador = identificador });
}
private static void Main(string[] args)
{
iaso_v001Context context = new iaso_v001Context();
ICommandRepository <Guid, Board> boardCommandRepo = new CommandRepository <Guid, Board>(context);
IQueryRepository <Guid, Board> boardQueryRepo = new QueryRepository <Guid, Board>(context);
IParameterisedQuery <int, Board> pQuery = new PQ();
var b = pQuery.GetParameter();
var boardList = boardQueryRepo.Items.ToList();
foreach (var t in boardList.ToList())
{
Console.WriteLine(string.Format("{0} >>>> {1}", t.Id, t.Name));
}
var board = new Board
{
Id = 1,
Name = "No Base 21/03",
BoardTypeId = 1,
CreateDate = DateTime.Now,
CreatedById = 1
};
ISaveCommand <Board> createCom = new CreateCommand <Guid, Board>()
{
Entity = board,
Repository = new CommandRepository <Guid, Board>(context)
};
var task = Task.Run(() => createCom.ExecuteAsync());
task.Wait();
try
{
IDeleteCommand <int> deleteCommand = new DeleteCommand <int, Board>()
{
Repository = new CommandRepository <int, Board>(context)
};
deleteCommand.Id = 1;
var tk = Task.Run(() => deleteCommand.ExecuteAsync());
tk.Wait();
}
catch (Exception ex)
{
}
Console.ReadKey();
}
public async Task AtualizarCoberturaRegimeFinanceiro(long itemCertificadoApolice, TipoRegimeFinanceiroEnum regimeFinanceiro)
{
var sql = @"UPDATE CoberturaContratada
SET RegimeFinanceiroId = @RegimeFinanceiroId
WHERE ItemCertificadoApoliceId = @ItemCertificadoApoliceId";
await CreateCommand.ExecuteAsync(sql, new
{
RegimeFinanceiroId = (int)regimeFinanceiro,
ItemCertificadoApoliceId = itemCertificadoApolice
});
}
public async Task Remover(Guid identificador)
{
var sql = @"DELETE H
FROM Evento E,
CoberturaContratada C,
HistoricoCoberturaContratada H
WHERE E.Identificador = @Id
AND ((H.CoberturaContratadaId = C.Id AND H.EventoId IS NULL AND C.EventoId = E.Id)
OR (H.EventoId IS NOT NULL AND H.EventoId = E.Id))" ;
await CreateCommand.ExecuteAsync(sql, new { Id = identificador });
}
private static void Main(string[] args)
{
iaso_v001Entities context = new iaso_v001Entities();
ICommandRepository <Guid, Board> boardCommandRepo = new CommandRepository <Guid, Board>(context);
IQueryRepository <Guid, Board> boardQueryRepo = new QueryRepository <Guid, Board>(context);
//IParameterisedQuery<int, Board> pQuery = new PQ();
//var b = pQuery.GetParameter();
//var boardList = boardQueryRepo.Items.ToList();
//foreach (var b in boardList.ToList())
//{
// Console.WriteLine(string.Format("{0} >>>> {1}", b.Id, b.Name));
//}
var board = new Board
{
Id = Guid.NewGuid(),
Name = "No Base 21/03",
BoardTypeId = new Guid("6F2BF38C-44D1-E611-A83D-D067E5F29371"),
CreatedDateTime = DateTime.Now,
CreatedBy_Id = new Guid("0191FBDF-40D1-E611-A83D-D067E5F29371")
};
ISaveCommand <Board> createCom = new CreateCommand <Guid, Board>()
{
Entity = board,
Repository = new CommandRepository <Guid, Board>(context)
};
var task = Task.Run(() => createCom.ExecuteAsync());
task.Wait();
Console.ReadKey();
}
public async Task Remover(Guid identificador)
{
var sql = @"DELETE FROM Evento WHERE Identificador = @Identificador";
await CreateCommand.ExecuteAsync(sql, new { Identificador = identificador });
}
public async Task <IActionResult> Create([FromBody] Country country)
{
var result = await CreateCommand.ExecuteAsync(new CreateCommand <Country>(country));
return(CommandTranslator.Translate(result));
}
public async Task <IActionResult> Create([FromBody] Bag bag)
{
var result = await CreateCommand.ExecuteAsync(new CreateBagCommand(bag));
return(CommandTranslator.Translate(result));
}
public async Task <IActionResult> Create([FromBody] Brand brand)
{
var result = await CreateCommand.ExecuteAsync(new CreateCommand <Brand>(brand));
return(CommandTranslator.Translate(result));
}
