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;
}
