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