/// <summary>
/// To import data to grid
/// </summary>
/// <param name="pFileName"></param>
/// <param name="fileExtension"></param>
private void Import_To_Grid(string pFileName, string fileExtension)
{
UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL();
DataTable dtCoordinates = objUploadPAPCoordinatesBLL.ExcelDataImportintoGrid(pFileName, fileExtension, 0, Convert.ToInt32(Session["USER_ID"]));
if (dtCoordinates.Columns.Contains("PAP NUMBER") &&
dtCoordinates.Columns.Contains("ROW_X") && dtCoordinates.Columns.Contains("ROW_Y") &&
dtCoordinates.Columns.Contains("WL_X") && dtCoordinates.Columns.Contains("WL_Y"))
{
dtCoordinates.Columns.Add("ID", typeof(int));
dtCoordinates.Columns.Add("ROW_LATITUDE", typeof(string));
dtCoordinates.Columns.Add("ROW_LONGITUDE", typeof(string));
dtCoordinates.Columns.Add("WL_LATITUDE", typeof(string));
dtCoordinates.Columns.Add("WL_LONGITUDE", typeof(string));
if (!dtCoordinates.Columns.Contains("HHID"))
{
dtCoordinates.Columns.Add("HHID", typeof(string));
}
GrdPAPCoordinates.DataSource = dtCoordinates;
GrdPAPCoordinates.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "CalcLatLongForGrid", "CalcLatLongForGrid()", true);
pnlFileUpload.Visible = false;
DataTable dt = (DataTable)GrdPAPCoordinates.DataSource;
ViewState["EXCEL_DATA"] = dtCoordinates;
GrdPAPCoordinates.Columns[GrdPAPCoordinates.Columns.Count - 1].Visible = false;
GrdPAPCoordinates.Columns[GrdPAPCoordinates.Columns.Count - 2].Visible = false;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Invalid Excel File.Please Upload a valid Excel File.');", true);
}
}
/// <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;
}
