public Entity.ConfigProperty GetConfig(string domain) { DataTable tbl = this._sqlDbProduct.GetTblData(@" SELECT TOP 1 c.[Id] ,c.[CompanyId] ,c.[TypeLayout] ,c.[XPath] ,c.[JSonOtherConfig] ,c.[JSonOtherConfigDemo] ,c.UrlTest , cf.CategoryXPath , co.Domain , cf.RemoveLastItemClassification , cf.TimeDelay FROM [dbo].[Configuration_Property] c INNER JOIN Configuration cf ON cf.CompanyID = c.CompanyId INNER JOIN Company co ON co.Id = cf.CompanyId Where co.Domain = @CompanyId" , CommandType.Text, new SqlParameter[] { SqlDb.CreateParamteterSQL("@CompanyId", domain, SqlDbType.NVarChar) }); if (tbl.Rows.Count > 0) { var row = tbl.Rows[0]; return(new ConfigProperty() { CategoryXPath = CommonConvert.Obj2String(row["CategoryXPath"]), CompanyId = CommonConvert.Obj2Int64(row["CompanyId"]), JSonOtherConfig = CommonConvert.Obj2String(row["JSonOtherConfig"]), TypeLayout = CommonConvert.Obj2Int(row["TypeLayout"]), XPath = CommonConvert.Obj2String(row["XPath"]), UrlTest = CommonConvert.Obj2String(row["UrlTest"]), Domain = CommonConvert.Obj2String(row["Domain"]), RemoveLastItemClassification = CommonConvert.Obj2Bool(row["RemoveLastItemClassification"]), TimeDelay = CommonConvert.Obj2Int(row["TimeDelay"]) }); } else { return(null); } }