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