public Boolean DeleteOnTable(String table, String cond) { Boolean flag = false; if (GlobalClass.branch != "001" && GlobalClass.DontSendToMain == false) { thisDatabase2 db2 = new thisDatabase2(); db2.DeleteOnTable(table, cond); } try { this.OpenConn(); string SQL = "DELETE FROM " + this.schema + "." + table + " WHERE " + cond + ";"; //MessageBox.Show(SQL); NpgsqlCommand command = new NpgsqlCommand(SQL, conn); Int32 rowsaffected = command.ExecuteNonQuery(); this.CloseConn(); flag = true; } catch (Exception) { flag = false; } return(flag); }
public Boolean UpdateOnTable(String table, String col_upd, String cond) { Boolean flag = false; if (GlobalClass.branch != "001" && GlobalClass.DontSendToMain == false) { thisDatabase2 db2 = new thisDatabase2(); db2.UpdateOnTable(table, col_upd, cond); } try { this.OpenConn(); if (cond != "") { cond = " WHERE " + cond + ""; } string SQL = "UPDATE " + this.schema + "." + table + " SET " + col_upd + "" + cond + ";"; //MessageBox.Show(SQL); NpgsqlCommand command = new NpgsqlCommand(SQL, conn); Int32 rowsaffected = command.ExecuteNonQuery(); this.CloseConn(); flag = true; } catch (Exception er) { flag = false; MessageBox.Show(er.Message); } return(flag); }