public List <Issues> SelectAllIssues() { string query = "select * from issues"; DataSet ds = this.ExecuteDataSet(query); List <Issues> lstIssues = null; if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { lstIssues = new List <Issues>(); for (int i = 0; i < dt.Rows.Count; i++) { string lat = GetString(dt.Rows[i]["issueLat"]); string lng = GetString(dt.Rows[i]["issueLng"]); CommonUtils.RequestAPI rapi = new CommonUtils.RequestAPI(ConfigurationManager.AppSettings["geocodingApi"].ToString()); rapi.AddParams("@latlng", lat + "," + lng); string address = rapi.Response; RootObject root = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize <RootObject>(address); if (root.results.Count > 0) { address = root.results[0].formatted_address; address = address.Substring(0, address.IndexOf(", Maharashtra, India")); } else { address = string.Empty; } Issues issues = new Issues( GetString(dt.Rows[i]["id"]), GetString(dt.Rows[i]["issueLat"]), GetString(dt.Rows[i]["issueLng"]), GetString(dt.Rows[i]["fixLat"]), GetString(dt.Rows[i]["fixLng"]), GetString(dt.Rows[i]["issueImage"]), GetString(dt.Rows[i]["fixImage"]), GetString(dt.Rows[i]["message"]), GetString(dt.Rows[i]["priority"]), GetString(dt.Rows[i]["name"]), GetString(dt.Rows[i]["status"]), address, GetDate(dt.Rows[i]["creationDate"]).ToString("hh:mm tt dd/MM/yyyy"), GetString(dt.Rows[i]["modificationDate"])); lstIssues.Add(issues); } } } return(lstIssues); }
public List<Issues> SelectAllIssues() { string query = "select * from issues"; DataSet ds = this.ExecuteDataSet(query); List<Issues> lstIssues = null; if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { lstIssues = new List<Issues>(); for (int i = 0; i < dt.Rows.Count; i++) { string lat = GetString(dt.Rows[i]["issueLat"]); string lng = GetString(dt.Rows[i]["issueLng"]); CommonUtils.RequestAPI rapi = new CommonUtils.RequestAPI(ConfigurationManager.AppSettings["geocodingApi"].ToString()); rapi.AddParams("@latlng", lat + "," + lng); string address = rapi.Response; RootObject root = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<RootObject>(address); if (root.results.Count > 0) { address = root.results[0].formatted_address; address = address.Substring(0, address.IndexOf(", Maharashtra, India")); } else { address = string.Empty; } Issues issues = new Issues( GetString(dt.Rows[i]["id"]), GetString(dt.Rows[i]["issueLat"]), GetString(dt.Rows[i]["issueLng"]), GetString(dt.Rows[i]["fixLat"]), GetString(dt.Rows[i]["fixLng"]), GetString(dt.Rows[i]["issueImage"]), GetString(dt.Rows[i]["fixImage"]), GetString(dt.Rows[i]["message"]), GetString(dt.Rows[i]["priority"]), GetString(dt.Rows[i]["name"]), GetString(dt.Rows[i]["status"]), address, GetDate(dt.Rows[i]["creationDate"]).ToString("hh:mm tt dd/MM/yyyy"), GetString(dt.Rows[i]["modificationDate"])); lstIssues.Add(issues); } } } return lstIssues; }