public string UpdateBusiness(BusinessModel business) { Business biz = new Business() { ID = !String.IsNullOrEmpty(business.ID) ? business.ID : Guid.NewGuid().ToString(), Name = business.Name, BusinessType = (BusinessType)Enum.Parse(typeof(BusinessType), business.Type), }; List <Configuration> confs = new List <Configuration>(); foreach (var conf in business.Configurations) { confs.Add(new Configuration() { ID = !String.IsNullOrEmpty(conf.ID) ? conf.ID : Guid.NewGuid().ToString(), ConfigurationType = (ConfigurationType)Enum.Parse(typeof(ConfigurationType), conf.Type), DbConnectionString = DBUtility.BuildConnectionString(conf.ServerAddress, conf.DatabaseName, conf.UserName, conf.Password) }); } biz.Configurations = confs.ToArray(); if (business.ReferenceID != null && business.ReferenceID.Length > 0) { biz.ReferenceID = business.ReferenceID.ToArray(); } int result = Provider.BusinessManager().UpdateBusinessConfiguration(biz); return(result.ToString()); }
public string CheckDatabaseExistency(SQLServerConnectionModel connection) { string connectionString = DBUtility.BuildConnectionString(connection.ServerAddress, "master", connection.UserName, connection.Password); string[] result = Provider.SQLServerDatabaseManager().ListDatabases(connectionString); foreach (var item in result) { if (item.ToLower() == connection.DatabaseName.ToLower()) { return("1"); } } return("0"); }
public string[] ListDatabases(SQLServerConnectionModel connection) { string connectionString = DBUtility.BuildConnectionString(connection.ServerAddress, connection.DatabaseName, connection.UserName, connection.Password); return(Provider.SQLServerDatabaseManager().ListDatabases(connectionString)); }