public List<IndustryEntity> SearchIndustry(IndustrySearchEntity searchObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return db.Resolve<IIndustryDB>().SearchIndustry(searchObject); } finally { db.CloseConnection(); } } }
public List<IndustryEntity> SearchIndustry(IndustrySearchEntity searchObject) { List<IndustryEntity> result = null; string sqlStatement = "SELECT " + Environment.NewLine + "Industry.IndustryId," + Environment.NewLine + "Industry.Description," + Environment.NewLine + "Industry.Deleted" + Environment.NewLine + "FROM Industry " + Environment.NewLine + "WHERE Deleted=0 " + Environment.NewLine; if (searchObject.SearchText != null && searchObject.SearchText.Length > 0) { sqlStatement += "AND (Description LIKE N'%" + searchObject.SearchText + "%')" + Environment.NewLine; } //execute result = Connection.Query<IndustryEntity>(sqlStatement,null, Transaction).ToList(); return result; }
public List<IndustryEntity> SearchIndustry(IndustrySearchEntity searchObject) { return Factory.Resolve<IIndustryBL>().SearchIndustry(searchObject); }