/// <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());
}
