public static bool sqlDelete(Rangos rango) { String sql = String.Format("DELETE FROM rangos WHERE idrangos = '{0}'" , rango.IdRangos ); return BD.getInstance().sqlEjecuta(sql); }
// ============= custom ============ // public static bool existsName(Rangos rango) { String sql = String.Format("SELECT * FROM rangos WHERE nombre = '{0}'", rango.Nombre); DataTable dt = BD.getInstance().sqlSelect(sql); if (dt.Rows.Count == 0) return false; return true; }
public static bool sqlLeer(Rangos rango) { String sql = String.Format("SELECT * FROM rangos WHERE idRangos = '{0}'" , rango.IdRangos); DataTable dt = BD.getInstance().sqlSelect(sql); if (dt.Rows.Count == 0) return false; rango.Nombre = dt.Rows[0]["nombre"].ToString(); rango.Text = dt.Rows[0]["text"].ToString(); return true; }
public static Boolean sqlInsert(Rangos rango) { if (!existsName(rango)) { String sql = String.Format("INSERT INTO rangos (nombre, text) VALUES ('{0}','{1}')" , rango.Nombre , rango.Text ); return BD.getInstance().sqlEjecuta(sql); } return false; }
public static bool sqlUpdate(Rangos rango) { if (!existsName(rango)) { String sql = String.Format("UPDATE rangos SET nombre = '{1}' , text = '{2}' WHERE idrangos = '{0}'" , rango.IdRangos , rango.Nombre , rango.Text ); return BD.getInstance().sqlEjecuta(sql); } return false; }