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