public DataService()
{
RoomGuideDataStructure.DataService dataServiceValue = new RoomGuideDataStructure.DataService();
dataServiceValue.serverName = GetConfigValue("ServerName");
dataServiceValue.userName = GetConfigValue("UserName");
dataServiceValue.databaseName = GetConfigValue("Database");
dataServiceValue.password = GetConfigValue("Password");
this.sqlConnection = this.GetConnection(dataServiceValue);
}
private SqlConnection GetConnection(RoomGuideDataStructure.DataService dataService)
{
string connectionString = string.Empty;
try
{
connectionString = "Data Source=" + dataService.serverName + "; Initial Catalog=" + dataService.databaseName + ";User ID=" + dataService.userName + ";Password="******";";
return(new SqlConnection(connectionString));
}
catch (Exception connectionException)
{
return(new SqlConnection(connectionString));
throw connectionException;
}
}
public DataService(RoomGuideDataStructure.DataService dataService)
{
this.sqlConnection = this.GetConnection(dataService);
}