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