public static async Task <List <COVER_DATE> > GetAll() { using (db = new RealInfoEntities()) { return(await Task.Run(() => db.COVER_DATE.Where(a => (a.DATE_THRU != null)).ToList())); } }
public static async Task <List <PROP_MASTER> > GetAllPropertyByAddress(string StreetNum, string StreetName, string city, string zip, string Schema) { List <PROP_MASTER> list = null; string query = String.Format("Select * from IL_{0}.{0}_PROP_MASTER A ", Schema); string where = " WHERE 1=1 "; if (!String.IsNullOrEmpty(StreetNum)) { where += String.Format("AND (A.STREET_NBR like '%{0}%')", StreetNum); } if (!String.IsNullOrEmpty(StreetName)) { where += String.Format("AND (A.STREET_NAME like '%{0}%')", StreetName); } if (!String.IsNullOrEmpty(city)) { where += String.Format("AND (A.CITY like '%{0}%')", city); } if (!String.IsNullOrEmpty(zip)) { where += String.Format("AND (A.ZIP_CODE like '%{0}%')", zip); } using (db = new RealInfoEntities()) { list = await Task.Run(() => db.Database.SqlQuery(typeof(PROP_MASTER), query + where).Cast <PROP_MASTER>().ToList()); } return(list); }
public static async Task <List <PROP_MASTER> > GetAllProperty(string FistName, string LastName, string Schema, string condition) { List <PROP_MASTER> list = null; string query = String.Format("Select * from IL_{0}.{0}_PROP_MASTER A ", Schema); string where = " WHERE 1=1 "; switch (condition) { case "s,": case ",s": if (String.IsNullOrEmpty(FistName)) { where += String.Format("AND (A.LAST_NAME_1 like '{0}%' OR A.LAST_NAME_2 like '{0}%') ", LastName); } else { where += String.Format("AND (A.FIRST_NAME_1 like '{0}%' OR A.FIRST_NAME_2 like '{0}%') ", FistName); } break; case ",e": case "e,": if (String.IsNullOrEmpty(FistName)) { where += String.Format("AND (A.LAST_NAME_1 like '{0}' OR A.LAST_NAME_2 like '{0}') ", LastName); } else { where += String.Format("AND (A.FIRST_NAME_1 like '{0}' OR A.FIRST_NAME_2 like '{0}') ", FistName); } break; case "s,e": where += String.Format("AND (A.FIRST_NAME_1 like '{0}%' OR A.FIRST_NAME_2 like '{0}%') AND (A.LAST_NAME_1 like '{0}' OR A.LAST_NAME_2 like '{0}')", FistName, LastName); break; case "e,s": where += String.Format("AND (A.FIRST_NAME_1 like '{0}' OR A.FIRST_NAME_2 like '{0}') AND (A.LAST_NAME_1 like '{0}%' OR A.LAST_NAME_2 like '{0}%')", FistName, LastName); break; case "s,s": where += String.Format("AND (A.FIRST_NAME_1 like '{0}%' OR A.FIRST_NAME_2 like '{0}%') AND (A.LAST_NAME_1 like '{0}%' OR A.LAST_NAME_2 like '{0}%')", FistName, LastName); break; default: where += String.Format("AND (A.FIRST_NAME_1 like '{0}' OR A.FIRST_NAME_2 like '{0}') AND (A.LAST_NAME_1 like '{0}' OR A.LAST_NAME_2 like '{0}')", FistName, LastName); break; } using (db = new RealInfoEntities()) { list = await Task.Run(() => db.Database.SqlQuery(typeof(PROP_MASTER), query + where).Cast <PROP_MASTER>().ToList()); } return(list); }
public static async Task <List <PROP_MASTER> > GetAllPropertyByTax(string TaxNumber, string Schema) { List <PROP_MASTER> list = null; string query = String.Format("Select * from IL_{0}.{0}_PROP_MASTER A WHERE A.TAX_NBR like '{1}%'", Schema, TaxNumber); using (db = new RealInfoEntities()) { list = await Task.Run(() => db.Database.SqlQuery(typeof(PROP_MASTER), query).Cast <PROP_MASTER>().ToList()); } return(list); }