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;
}
