public List <VinaGerman.Entity.BusinessEntity.ContactEntity> SearchContact(ContactSearchEntity searchObject)
{
List <VinaGerman.Entity.BusinessEntity.ContactEntity> result = null;
string sqlStatement = "SELECT " + Environment.NewLine +
"Contact.ContactId," + Environment.NewLine +
"Contact.FullName," + Environment.NewLine +
"Contact.Email," + Environment.NewLine +
"Contact.Phone," + Environment.NewLine +
"Contact.Address," + Environment.NewLine +
"Contact.CompanyId," + Environment.NewLine +
"Contact.UserAccountId," + Environment.NewLine +
"Contact.Position," + Environment.NewLine +
"Contact.DepartmentId," + Environment.NewLine +
"Contact.Deleted" + Environment.NewLine +
"FROM Contact " + Environment.NewLine +
"WHERE Deleted=0 " + Environment.NewLine;
if (searchObject.SearchText != null && searchObject.SearchText.Length > 0)
{
sqlStatement += "AND (FullName LIKE N'%" + searchObject.SearchText + "%' OR Phone LIKE N'%" + searchObject.SearchText + "%' OR Email LIKE N'%" + searchObject.SearchText + "%' OR Address LIKE N'%" + searchObject.SearchText + "%')" + Environment.NewLine;
}
//execute
result = Connection.Query <VinaGerman.Entity.BusinessEntity.ContactEntity>(sqlStatement, null, Transaction).ToList();
return(result);
}
public List <VinaGerman.Entity.BusinessEntity.ContactEntity> SearchContact(ContactSearchEntity searchObject)
{
ICompanySvc channel = CreateChannel();
var result = channel.SearchContact(searchObject);
channel.Dispose();
return(result);
}
public List <VinaGerman.Entity.BusinessEntity.ContactEntity> SearchContact(ContactSearchEntity searchObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return(db.Resolve <IContactDB>().SearchContact(searchObject));
}
finally
{
db.CloseConnection();
}
}
}
public List <VinaGerman.Entity.BusinessEntity.ContactEntity> SearchContact(ContactSearchEntity searchObject)
{
return(Factory.Resolve <IContactBL>().SearchContact(searchObject));
}
