public int Add(AcoesMkt acoesMkt)
{
var connectionString = this.GetConnection();
int count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = @"insert into acoesMkt
(Nome
, id_associado
, id_farmacia
, id_gondola
, id_partes
, id_fornecedor
, id_status
, id_aprovador
, valor
, dataVenda
, dataAgendamento
, dataPagamento)
values
(
@Nome
, @id_associado
, @id_farmacia
, @id_gondola
, @id_partes
, @id_fornecedor
, @id_status
, @id_aprovador
, @valor
, @dataVenda
, @dataAgendamento
, @dataPagamento
); SELECT CAST(SCOPE_IDENTITY() as INT); " ;
count = con.Execute(query, acoesMkt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(count);
}
}
public int Edit(AcoesMkt acoesMkt)
{
var connectionString = this.GetConnection();
var count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = @"update acoesMkt
set Nome = @Nome
,id_associado =@id_associado
,id_farmacia = @id_farmacia
,id_gondola = @id_gondola
,id_partes = @id_partes
,id_fornecedor = @id_fornecedor
,id_status = @id_status
,id_aprovador = @id_aprovador
,valor = @valor
,dataVenda = @dataVenda
,dataAgendamento = @dataAgendamento
,dataPagamento = @dataPagamento
WHERE id = " + acoesMkt.Id;
count = con.Execute(query, acoesMkt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(count);
}
}
public AcoesMkt Get(int id)
{
var connectionString = this.GetConnection();
AcoesMkt acoesMkt = new AcoesMkt();
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "SELECT * FROM AcoesMkt WHERE id =" + id;
acoesMkt = con.Query <AcoesMkt>(query).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(acoesMkt);
}
}
