public List <DataStructure.EnterpriseNode> Search(string filter, Enums.EnterpriseNodeType enterpriseNodeTypeId = Enums.EnterpriseNodeType.RealEnterPriseNode)
{
EnterpriseNodeCommandBuilder enterpriseNodeCommandBuilder = new EnterpriseNodeCommandBuilder();
SqlCommand query = enterpriseNodeCommandBuilder.Search(filter, enterpriseNodeTypeId);
return(DBManager.GetCollection <DataStructure.EnterpriseNode>(base.ConnectionHandler, query));
}
public SqlCommand Search(string filter, Enums.EnterpriseNodeType enterpriseNodeTypeId = Enums.EnterpriseNodeType.RealEnterPriseNode)
{
SqlCommand q = new SqlCommand();
string query = string.Empty;
string whereCluase = "";
if (!string.IsNullOrEmpty(filter))
{
filter = filter.ToLower();
}
q.Parameters.Add(new SqlParameter("@FILTER", filter));
if (enterpriseNodeTypeId == Enums.EnterpriseNodeType.RealEnterPriseNode)
{
query = string.Format("SELECT EnterpriseNode.EnterpriseNode.* FROM EnterpriseNode.EnterpriseNode INNER JOIN " +
" EnterpriseNode.RealEnterpriseNode ON EnterpriseNode.EnterpriseNode.Id = EnterpriseNode.RealEnterpriseNode.Id ");
whereCluase += "lower(EnterpriseNode.RealEnterpriseNode.FirstName) LIKE N'%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.RealEnterpriseNode.LastName) LIKE N'%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.RealEnterpriseNode.NationalCode) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.RealEnterpriseNode.IDNumber) LIKE '%@FILTER%' OR ";
}
if (enterpriseNodeTypeId == Enums.EnterpriseNodeType.LegalEnterPriseNode)
{
query = string.Format("SELECT EnterpriseNode.EnterpriseNode.* FROM EnterpriseNode.EnterpriseNode INNER JOIN " +
" EnterpriseNode.LegalEnterpriseNode ON EnterpriseNode.EnterpriseNode.Id = EnterpriseNode.LegalEnterpriseNode.Id ");
whereCluase += "lower(EnterpriseNode.LegalEnterpriseNode.Title) LIKE N'%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.LegalEnterpriseNode.RegisterNo) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.LegalEnterpriseNode.NationalId) LIKE '%@FILTER%' OR ";
}
whereCluase += "lower(EnterpriseNode.[Address]) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.Website) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.Cellphone) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.Tel) LIKE '%@FILTER%' OR ";
whereCluase += "lower(EnterpriseNode.Email) LIKE '%@FILTER%' OR ";
if (!string.IsNullOrEmpty(whereCluase))
{
whereCluase = whereCluase.Substring(0, whereCluase.Length - 3);
q.CommandText = string.Format("{0} WHERE {1} ", query, whereCluase);
}
return(q);
}
public List <DataStructure.EnterpriseNode> Search(string filter, Enums.EnterpriseNodeType enterpriseNodeTypeId = Enums.EnterpriseNodeType.RealEnterPriseNode, bool fillcomplex = true)
{
try
{
var list = string.IsNullOrEmpty(filter)
? new List <DataStructure.EnterpriseNode>()
: new EnterpriseNodeBO().Search(this.ConnectionHandler, filter.Trim(),
enterpriseNodeTypeId);
return(list);
}
catch (KnownException ex)
{
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
catch (Exception ex)
{
Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace);
throw new KnownException(ex.Message, ex);
}
}
public List <DataStructure.EnterpriseNode> Search(IConnectionHandler connectionHandler, string filter, Enums.EnterpriseNodeType enterpriseNodeTypeId = Enums.EnterpriseNodeType.RealEnterPriseNode)
{
var da = new EnterpriseNodeDA(connectionHandler);
return(da.Search(filter, enterpriseNodeTypeId));
}
