/// <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;
}
private void GetPapCoorDetailsByID(int ID)
{
UploadPAPCoordinatesBLL ObjBLL = new UploadPAPCoordinatesBLL();
UploadPAPCoordinatesBO OBJbo = new UploadPAPCoordinatesBO();
OBJbo = ObjBLL.GetPapCoordinatesDataByID(ID);
txtROWX.Text = OBJbo.ROW_X;
txtROWY.Text = OBJbo.ROW_Y;
txtROWLatitude.Text = OBJbo.ROW_LATITUDE;
txtROWLongitude.Text = OBJbo.ROW_LONGITUDE;
txtWLX.Text = OBJbo.WL_X;
txtWLY.Text = OBJbo.WL_Y;
txtWLLatitude.Text = OBJbo.WL_LATITUDE;
txtWLLongitude.Text = OBJbo.WL_LONGITUDE;
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GrdPAPCoordinates_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["PAPCOORID"] = e.CommandArgument;
int ID = Convert.ToInt32(ViewState["PAPCOORID"]);
GetPapCoorDetailsByID(ID);
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
UploadPAPCoordinatesBLL UploadPAPCoordinatesBLLobj = new UploadPAPCoordinatesBLL();
UploadPAPCoordinatesBLLobj.DeletePapCoordinates(Convert.ToInt32(e.CommandArgument));
string message = "Data Deleted successfully";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
ClearDetails();
SetUpdateMode(false);
BindGrid();
}
}
/// <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());
}
/// <summary>
/// To load co ordinates
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnLoadCordinate_Click(object sender, EventArgs e)
{
UploadPAPCoordinatesList list1 = new UploadPAPCoordinatesList();
UploadPAPCoordinatesBO objBo;
for (int i = 0; i < GrdPAPCoordinates.Rows.Count; i++)
{
objBo = new UploadPAPCoordinatesBO();
objBo.HHID = Convert.ToInt32(Request.QueryString["HHID"].ToString());
if (GrdPAPCoordinates.Rows[i].Cells[2].Text != " ")
{
objBo.ROW_X = GrdPAPCoordinates.Rows[i].Cells[2].Text;
}
if (GrdPAPCoordinates.Rows[i].Cells[3].Text != " ")
{
objBo.ROW_Y = GrdPAPCoordinates.Rows[i].Cells[3].Text;
}
TextBox txtlat = (TextBox)GrdPAPCoordinates.Rows[i].FindControl("txtLATITUDE");
TextBox txtlon = (TextBox)GrdPAPCoordinates.Rows[i].FindControl("txtLONGITUDE");
if (txtlat.Text != " ")
{
objBo.ROW_LATITUDE = txtlat.Text;
}
if (txtlon.Text != " ")
{
objBo.ROW_LONGITUDE = txtlon.Text;
}
if (GrdPAPCoordinates.Rows[i].Cells[6].Text != " ")
{
objBo.WL_X = GrdPAPCoordinates.Rows[i].Cells[6].Text;
}
if (GrdPAPCoordinates.Rows[i].Cells[7].Text != " ")
{
objBo.WL_Y = GrdPAPCoordinates.Rows[i].Cells[7].Text;
}
TextBox txtlat1 = (TextBox)GrdPAPCoordinates.Rows[i].FindControl("txtWLLATITUDE");
TextBox txtlon1 = (TextBox)GrdPAPCoordinates.Rows[i].FindControl("txtWLLONGITUDE");
if (txtlat1.Text != " ")
{
objBo.WL_LATITUDE = txtlat1.Text;
}
if (txtlon1.Text != " ")
{
objBo.WL_LONGITUDE = txtlon1.Text;
}
list1.Add(objBo);
}
UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL();
string message = "";
string uID = Session["USER_ID"].ToString();
string Count = objUploadPAPCoordinatesBLL.SaveExcelData(list1, Session["USER_ID"].ToString());
if (!string.IsNullOrEmpty(Count))
{
message = Count + " - Coordinates(s) were added successfully";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
pnlRouteCoordinatesDetails.Visible = true;
pnlFileUpload.Visible = false;
btn_ImportExcel.Visible = true;
BindGrid();
EnableSaveCancel(false);
}
/// <summary>
/// To save the roots manually
/// </summary>
protected void btn_Save_Click(object sender, EventArgs e)
{
string message = "";
UploadPAPCoordinatesBO objBo;
objBo = new UploadPAPCoordinatesBO();
objBo.HHID = Convert.ToInt32(Request.QueryString["HHID"].ToString());
if (txtROWX.Text.Trim() != "")
{
objBo.ROW_X = txtROWX.Text;
}
if (txtROWY.Text.Trim() != "")
{
objBo.ROW_Y = txtROWY.Text;
}
if (txtROWLatitude.Text.Trim() != "")
{
objBo.ROW_LATITUDE = txtROWLatitude.Text;
}
if (txtROWLongitude.Text.Trim() != "")
{
objBo.ROW_LONGITUDE = txtROWLongitude.Text;
}
if (txtWLX.Text.Trim() != "")
{
objBo.WL_X = txtWLX.Text;
}
if (txtWLY.Text.Trim() != "")
{
objBo.WL_Y = txtWLY.Text;
}
if (txtWLLatitude.Text.Trim() != "")
{
objBo.WL_LATITUDE = txtWLLatitude.Text;
}
if (txtWLLongitude.Text.Trim() != "")
{
objBo.WL_LONGITUDE = txtWLLongitude.Text;
}
UploadPAPCoordinatesBLL objUploadPAPCoordinatesBLL = new UploadPAPCoordinatesBLL();
if (Convert.ToInt32(ViewState["PAPCOORID"]) == 0)
{
objBo.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
objUploadPAPCoordinatesBLL.SavePAPCoordinates(objBo);
message = "Data saved successfully";
}
else
{
objBo.Id = Convert.ToInt32(ViewState["PAPCOORID"]);
objBo.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
objUploadPAPCoordinatesBLL.UpdatePAPCoordinates(objBo);
message = "Data updated successfully";
}
ClearDetails();
BindGrid();
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
