public int Edit(Gondolas gondola)
{
var connectionString = this.GetConnection();
var count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = @"UPDATE Gondolas
SET Nome = @Nome
,id_farmacia = @id_farmacia
,id_posicao = @id_posicao
,altura = @altura
,largura = @largura
WHERE id = " + gondola.Id;
count = con.Execute(query, gondola);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(count);
}
}
public int Add(Gondolas gondola)
{
var connectionString = this.GetConnection();
int count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = @"insert into Gondolas
(
nome
, id_farmacia
, id_posicao
, altura
, largura
)
values
(
@nome
, @id_farmacia
, @id_posicao
, @altura
, @largura
)
; SELECT CAST(SCOPE_IDENTITY() as INT); " ;
count = con.Execute(query, gondola);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(count);
}
}
public Gondolas Get(int id)
{
var connectionString = this.GetConnection();
Gondolas gondola = new Gondolas();
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "SELECT * FROM Gondolas WHERE id =" + id;
gondola = con.Query <Gondolas>(query).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(gondola);
}
}
