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); } }