public int Salvar(ServicoDTO dto)
{
string script = @"INSERT INTO tb_servico(
id_cliente,
dt_servico,
id_orcamento,
ds_servico) VALUES(
@id_cliente,
@dt_servico,
@id_orcamento,
@ds_servico)";
List <MySqlParameter> parms = new List <MySqlParameter>();
parms.Add(new MySqlParameter("id_cliente", dto.ClienteId));
parms.Add(new MySqlParameter("dt_servico", dto.Data));
parms.Add(new MySqlParameter("id_orcamento", dto.OrcamentoId));
parms.Add(new MySqlParameter("ds_servico", dto.Descricao));
Database db = new Database();
return(db.ExecuteInsertScriptWithPk(script, parms));
}
public List <ServicoDTO> Listar()
{
string script = @"SELECT * FROM tb_servico";
List <MySqlParameter> parms = new List <MySqlParameter>();
Database db = new Database();
MySqlDataReader reader = db.ExecuteSelectScript(script, parms);
List <ServicoDTO> lista = new List <ServicoDTO>();
while (reader.Read())
{
ServicoDTO dto = new ServicoDTO();
dto.Id = reader.GetInt32("id_servico");
dto.ClienteId = reader.GetInt32("id_cliente");
dto.Data = reader.GetString("dt_servico");
dto.OrcamentoId = reader.GetInt32("id_orcamento");
dto.Descricao = reader.GetString("ds_servico");
lista.Add(dto);
}
reader.Close();
return(lista);
}
public int Salvar(ServicoDTO dto)
{
ServicoDatabase db = new ServicoDatabase();
return(db.Salvar(dto));
}
