public void deleteDataBase(int dataBaseId)
{
DatabaseParameter database = ConfigurationDB.DatabaseParameters.Where(param => param.DatabaseParametersId == dataBaseId).ToList()[0];
ConfigurationDB.DatabaseParameters.Remove(database);
ConfigurationDB.SaveChanges();
}
public void updateDatabase(int id, string ip, string name, string username, string password, int engineId, string port = null, string instance = null)
{
DatabaseParameter db = ConfigurationDB.DatabaseParameters.Where(param => param.DatabaseParametersId == id).ToList()[0];
db.Ip = ip;
db.Instance = instance;
db.Name = name;
db.Username = username;
db.Password = password;
db.Port = port;
db.EngineId = engineId;
ConfigurationDB.SaveChanges();
}
public void saveDatabase(string ip, string name, string username, string password, string engineId, string port = null, string instance = null)
{
DatabaseParameter db = new DatabaseParameter();
db.Ip = ip;
db.Instance = instance;
db.Name = name;
db.Username = username;
db.Password = password;
db.Port = port;
int intEngineId = Convert.ToInt32(engineId);
// Engine engine = SystemConfigurationDB.Engines.Where(param => param.EngineId == intEngineId).ToList()[0];
db.EngineId = intEngineId;
ConfigurationDB.DatabaseParameters.Add(db);
ConfigurationDB.SaveChanges();
}
public DatabaseParameter getDatabase(int id)
{
DatabaseParameter dataBase = ConfigurationDB.DatabaseParameters.Where(param => param.DatabaseParametersId == id).ToList()[0];
return(dataBase);
}
