public GeoMappingCollection Get() { //string filter = null; string sort = null; int pageNumber = 1; int pageSize = 1000; GeoMappingCollection recs = new GeoMappingCollection(); string language = Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName; UserAccount user = UserAccount.GetByPrinciple(User); if (user != null) { using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["CONN_STRING"])) { var report = conn.Query <GeoMapping>("dbo.report_Generic_ListForGeoMapping", null, commandType: CommandType.StoredProcedure); foreach (GeoMapping rec in report) { if (rec.latitude != 0) { recs.Add(rec); } } } } return(recs); }
public GeoMappingCollection Get(Guid id) { string filter = null; Guid dispatchLocationID = id; string sort = null; int pageNumber = 1; int pageSize = 10000; GeoMappingCollection recs = new GeoMappingCollection(); //RecordManagementRequest request = new RecordManagementRequest(pageNumber, pageSize, sort, filter); string language = Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName; UserAccount user = UserAccount.GetByPrinciple(User); if (user != null) { try { using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["CONN_STRING"])) { conn.Open(); DynamicParameters args = new DynamicParameters(); args.Add("@IDN", id.ToString()); var results = conn.Query <GeoMapping>("dbo.report_Generic_List_Coordinates_ForGeoMapping", args, commandType: CommandType.StoredProcedure); conn.Close(); foreach (GeoMapping rec in results) { if (rec.latitude != 0) { recs.Add(rec); } } } } catch (Exception ex) { } } return(recs); }