/** * Método que permite adicionar um novo pedido de transferencia * de documento a um determinado Register */ public void putTransferRequest(TransferRequest tr) { MySqlConnection connection = new MySqlConnection(this.connectionstring); connection.Open(); DataTable dt = new DataTable(); StringBuilder sb = new StringBuilder(); sb.Append("insert into transferrequests (addrNewProp,addrRequester,hashDocument) values ('"); sb.Append(tr.getaddrNewProp()); sb.Append("','"); sb.Append(tr.getaddrRequester()); sb.Append("','"); sb.Append(tr.getHashDoc()); sb.Append("')"); MySqlDataAdapter msda = new MySqlDataAdapter(sb.ToString(), connection); msda.Fill(dt); connection.Close(); }
/** * Metodo que serve para apagar um determinado pedido de transferencia de propriedade */ public void deleteTransferRequest(TransferRequest tr) { // delete from transferrequests where addrNewProp = '' and addrRequester='' and hashDocument=''; MySqlConnection connection = new MySqlConnection(this.connectionstring); connection.Open(); DataTable dt = new DataTable(); StringBuilder sb = new StringBuilder(); sb.Append("delete from transferrequests where addrNewProp='"); sb.Append(tr.getaddrNewProp()); sb.Append("' and addrRequester='"); sb.Append(tr.getaddrRequester()); sb.Append("' and hashDocument='"); sb.Append(tr.getHashDoc()); sb.Append("'"); MySqlDataAdapter msda = new MySqlDataAdapter(sb.ToString(), connection); msda.Fill(dt); connection.Close(); }
/** * Metodo que serve para verificar se um pedido de transferencia ja pertence a DB */ public bool containsTransferRequest(TransferRequest tr) { MySqlConnection connection = new MySqlConnection(this.connectionstring); connection.Open(); DataTable dt = new DataTable(); StringBuilder sb = new StringBuilder(); sb.Append("select * from transferrequests where addrNewProp='"); sb.Append(tr.getaddrNewProp()); sb.Append("' and addrRequester='"); sb.Append(tr.getaddrRequester()); sb.Append("' and hashDocument='"); sb.Append(tr.getHashDoc()); sb.Append("'"); MySqlDataAdapter msda = new MySqlDataAdapter(sb.ToString(), connection); msda.Fill(dt); connection.Close(); return(dt.Rows.Count == 1); }