/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL(); GrdPAPCoordinates.DataSource = objUploadPAPCoordinatesBLL.GetAllPapCoordinatesData(0, Convert.ToInt32(Session["PROJECT_ID"])); GrdPAPCoordinates.DataBind(); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL(); GrdPAPCoordinates.DataSource = objUploadPAPCoordinatesBLL.GetAllPapCoordinatesData(Convert.ToInt32(Request.QueryString["HHID"].ToString()), Convert.ToInt32(Session["PROJECT_ID"])); GrdPAPCoordinates.DataBind(); GrdPAPCoordinates.Columns[GrdPAPCoordinates.Columns.Count - 1].Visible = true; GrdPAPCoordinates.Columns[GrdPAPCoordinates.Columns.Count - 2].Visible = true; }
/// <summary> /// Set the PAp coordinates to Map /// </summary> public string GetPap() { int HHID = 0; if (Request.QueryString["HHID"] != null) { HHID = Convert.ToInt32(Request.QueryString["HHID"].ToString()); } UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL(); UploadPAPCoordinatesList objUploadPAPCoordinatesList = objUploadPAPCoordinatesBLL.GetAllPapCoordinatesData(HHID, Convert.ToInt32(Session["PROJECT_ID"])); System.Text.StringBuilder sb = new System.Text.StringBuilder(); int a = 0; string s1 = ""; int ROWCount = 0; for (int i = 0; i < objUploadPAPCoordinatesList.Count; i++) { UploadPAPCoordinatesBO objUploadPAPCoordinatesBO = objUploadPAPCoordinatesList[i]; if (objUploadPAPCoordinatesBO.ROW_LATITUDE != null && objUploadPAPCoordinatesBO.ROW_LATITUDE.Trim() != "" && objUploadPAPCoordinatesBO.ROW_LONGITUDE != null && objUploadPAPCoordinatesBO.ROW_LONGITUDE.Trim() != "") { ROWCount++; if (a == 0) { s1 = string.Format("'{0},{1},{2}'", objUploadPAPCoordinatesBO.ROW_LATITUDE, objUploadPAPCoordinatesBO.ROW_LONGITUDE, objUploadPAPCoordinatesBO.Papname); a++; } sb.Append(string.Format("'{0},{1},{2}'", objUploadPAPCoordinatesBO.ROW_LATITUDE, objUploadPAPCoordinatesBO.ROW_LONGITUDE, objUploadPAPCoordinatesBO.Papname)); sb.Append(";"); } if (objUploadPAPCoordinatesList.Count == i + 1 && ROWCount > 0) { sb.Append(s1); sb.Append(";"); } } if (ROWCount == 0) { for (int i = 0; i < objUploadPAPCoordinatesList.Count; i++) { UploadPAPCoordinatesBO objUploadPAPCoordinatesBO = objUploadPAPCoordinatesList[i]; if (objUploadPAPCoordinatesBO.WL_LATITUDE != null && objUploadPAPCoordinatesBO.WL_LATITUDE.Trim() != "" && objUploadPAPCoordinatesBO.WL_LONGITUDE != null && objUploadPAPCoordinatesBO.WL_LONGITUDE.Trim() != "") { ROWCount++; if (a == 0) { s1 = string.Format("'{0},{1},{2}'", objUploadPAPCoordinatesBO.WL_LATITUDE, objUploadPAPCoordinatesBO.WL_LONGITUDE, objUploadPAPCoordinatesBO.Papname); a++; } sb.Append(string.Format("'{0},{1},{2}'", objUploadPAPCoordinatesBO.ROW_LATITUDE, objUploadPAPCoordinatesBO.ROW_LONGITUDE, objUploadPAPCoordinatesBO.Papname)); sb.Append(";"); } if (objUploadPAPCoordinatesList.Count == i + 1) { sb.Append(s1); sb.Append(";"); } } } if (sb.Length > 0) { sb.Remove(sb.Length - 1, 1); } //System.Text.StringBuilder sb1 = new System.Text.StringBuilder(); //sb1.Append(string.Format("'{0},{1},{2}'", "0.438583", "33.171651", "E")); //sb1.Append(";"); //sb1.Append(string.Format("'{0},{1},{2}'", "0.43588", "33.172681", "B")); //sb1.Append(";"); //sb1.Append(string.Format("'{0},{1},{2}'", "0.437553", "33.177788", "C")); //sb1.Append(";"); //sb1.Append(string.Format("'{0},{1},{2}'", "0.441888", "33.176286", "D")); //sb1.Append(";"); //sb1.Append(string.Format("'{0},{1},{2}'", "0.438583", "33.171651", "E")); //sb1.Append(";"); //if (sb1.Length > 0) sb1.Remove(sb1.Length - 1, 1); return(sb.ToString()); }