public List <string> GetDataDataBaseLists(DataBaseNameFilterServiceModel databaseFilterServiceModel)
{
try
{
if (databaseFilterServiceModel == null)
{
}
string connectionString = string.Empty;
List <string> dataBaseName = new List <string>();
if (!string.IsNullOrEmpty(databaseFilterServiceModel.UserName) || !string.IsNullOrEmpty(databaseFilterServiceModel.Password))
{
connectionString = "server= " + databaseFilterServiceModel.ServerInstanceName + " ;uid=" + databaseFilterServiceModel.UserName + ";pwd=" + databaseFilterServiceModel.Password + ";";
}
else
{
connectionString = "Data Source=" + databaseFilterServiceModel.ServerInstanceName + "; Integrated Security=True;";
}
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", conn))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
dataBaseName.Add(dr[0].ToString());
}
}
}
}
return(dataBaseName);
}
catch (Exception ex)
{
throw;
}
}
public HttpResponseMessage GetDatabaseName(DataBaseNameFilterServiceModel databaseFilterServiceModel)
{
return(Request.CreateResponse(HttpStatusCode.OK, _dataBaseConnectionService.GetDataDataBaseLists(databaseFilterServiceModel)));
}
