public EntitieBase GetBaseById(int idBase)
{
EntitieBase _base = null;
DataTable dt = ManagerDatabase.Instance.ExecuteQuery("SELECT * FROM base WHERE ID_Base = " + idBase);
if (dt.Rows.Count > 0)
{
_base = new EntitieBase();
}
return(_base);
}
// |==============================METODOS Y FUNCIONES==============================|
public List <EntitieBase> GetBase()
{
List <EntitieBase> _base = new List <EntitieBase>();
DataTable dt = ManagerDatabase.Instance.ExecuteQuery("SELECT * FROM base");
for (int i = 0; i < dt.Rows.Count; i++)
{
EntitieBase b = new EntitieBase();
_base.Add(b);
}
return(_base);
}
public void ModificarBase(int idBase, EntitieBase _base)
{
ManagerDatabase.Instance.Execute("UPDATE Base SET Nombre = '" + _base + "' " +
"WHERE ID_Base= " + idBase);
}
public void CrearBase(EntitieBase _base)
{
ManagerDatabase.Instance.Execute("INSERT INTO Base(Nombre) VALUES('" + _base + "')");
}
