public Boolean setinfo(string _tenban, string _tinhtrang, string _khuvuc) { string query = string.Format("INSERT INTO ban (tenban, tinhtrang, khuvuc) VALUES ('"+_tenban+"', "+_tinhtrang+", "+_khuvuc+")"); try{ con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return con.executeQuery(query); }
public Boolean updatetinhtranban(string _tinhtrang, string _maban) { string query = string.Format("UPDATE ban SET tinhtrang=" + _tinhtrang + " WHERE maban="+ _maban); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return con.executeQuery(query); }
public Boolean setinfo(string _tenban, string _tinhtrang, string _khuvuc) { string query = string.Format("INSERT INTO ban (tenban, tinhtrang, khuvuc) VALUES ('" + _tenban + "', " + _tinhtrang + ", " + _khuvuc + ")"); try{ con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeQuery(query)); }
public Boolean deletecthoadon(string _id) { string query = string.Format("delete from chitiethoadon where mahoadon = " + _id); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeQuery(query)); }
public Boolean inserthoadon(string _mahoadon, string _maban, string _tinhtrang, string _ngaylap) { string query = string.Format("INSERT INTO hoadon (mahoadon, maban, tinhtrang, ngaylap) VALUES ('" + _mahoadon + "', " + _maban + ", " + _tinhtrang + ", '" + _ngaylap + "')"); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeQuery(query)); }
public Boolean updatetinhtranban(string _tinhtrang, string _maban) { string query = string.Format("UPDATE ban SET tinhtrang=" + _tinhtrang + " WHERE maban=" + _maban); try { con = new DbConnection(); con.openConnection(); } catch (SqlException e) { } return(con.executeQuery(query)); }