public bool deleteIVQRecord(IVQRecord IVQ) { SQL = "delete from invoice_queue "; SQL += " WHERE elt_account_number = " + elt_account_number + " and queue_id=" + IVQ.Queue_id; Cmd = new SqlCommand(SQL, Con); try { Con.Open(); Cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } Con.Close(); return(true); }
public bool updateIVQRecord(IVQRecord IVQ) { IVQ.replaceQuote(); SQL = "update invoice_queue set "; SQL += "invoiced= '" + IVQ.Invoiced + "' "; SQL += " WHERE elt_account_number = " + elt_account_number + " and queue_id=" + IVQ.Queue_id; Cmd = new SqlCommand(SQL, Con); try { Con.Open(); Cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } Con.Close(); return(true); }