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);
}
}