public async Task <CompanyMaster> getComapnyDtl(int COMPID) { try { CompanyMaster obj = new CompanyMaster(); Xdoc = DBXML.CLIENTCONNECTION_h(COMPID, 0); dt = SqlExev2.GetDT(Xdoc, dbConnectionString); obj = (from row in dt.AsEnumerable() select new CompanyMaster { CompName = row.Field <string>("compName"), ServerName = row.Field <string>("serverName"), AuthType = row.Field <string>("AuthType"), UserName = row.Field <string>("userName"), PASSWORD = row.Field <string>("PASSWORD"), DatabaseName = row.Field <string>("databaseName") //isActive = row.Field<string>("isActive"), //createdOn = row.Field<string>("createdOn"), //ceatedBy = row.Field<string>("ceatedBy"), }).FirstOrDefault(); return(await Task.Factory.StartNew(() => obj)); //return obj; } catch (Exception ex) { throw; } }
public async Task <string> getComapnyConnectionstr(int COMPID) { try { CompanyMaster obj = new CompanyMaster(); Xdoc = DBXML.CLIENTCONNECTION_h(COMPID, 0); dt = SqlExev2.GetDT(Xdoc, dbConnectionString); obj = (from row in dt.AsEnumerable() select new CompanyMaster { CompName = row.Field <string>("compName"), ServerName = row.Field <string>("serverName"), AuthType = row.Field <string>("AuthType"), UserName = row.Field <string>("userName"), PASSWORD = row.Field <string>("PASSWORD"), DatabaseName = row.Field <string>("databaseName") }).FirstOrDefault(); string connectionString = ""; if (obj != null) { string connetion = ""; if (obj.AuthType == "SQL Server Authentication") { connetion = "Data Source=" + obj.ServerName + ";Initial Catalog=" + obj.DatabaseName + ";User ID=" + obj.UserName + ";Password="******";"; } else { connetion = "Data Source=" + obj.ServerName + ";Initial Catalog=" + obj.DatabaseName + ";Integrated Security=true;"; } connectionString = connetion; } return(await Task.Factory.StartNew(() => connectionString)); //return obj; } catch (Exception ex) { throw; } }