protected void UploadFileH2OANDEasygo(FileUpload FuBulkDetails) { try { string fileNametext = string.Empty; if (FuBulkDetails.HasFile) { if (FuBulkDetails.FileName.Contains(".csv")) { fileNametext = FuBulkDetails.FileName; string strPath = Server.MapPath("InventoryFiles") + "/" + FuBulkDetails.FileName; FuBulkDetails.SaveAs(strPath); ViewState["FileImport"] = strPath; //-----Datatable for imported files complete data ViewState["objDT"] = CSVTODataTable(strPath, (DataTable)ViewState["objDT"]); DataTable dt = (DataTable)ViewState["objDT"]; // bool iscolExists = false; foreach (DataColumn dcol in dt.Columns) { if (dcol.ColumnName.ToUpper() == "ICCID ON WHICH THAT BUNDLE ACTIVATED") { iscolExists = true; break; } } if (!iscolExists) { dt.Columns.Add(new DataColumn("ICCID ON WHICH THAT BUNDLE ACTIVATED")); } // //------Datatable for get mapped details from DB DataTable objDt = new DataTable(); objDt.TableName = "tDtSIMBulkTransfer"; objDt.Columns.Add("ICCID ON WHICH THAT BUNDLE ACTIVATED"); for (int i = 0; i < dt.Rows.Count; i++) { string ICCIDnumber = string.Empty, iccidprefix = string.Empty; //iccidprefix = Convert.ToString(dt.Rows[i]["iccidPREFIX"]).ToUpper(); //if (!iscolExists) // ICCIDnumber = (((iccidprefix == string.Empty || iccidprefix=="NULL") ? "8919601" : Convert.ToString(dt.Rows[i]["iccidPREFIX"])) // + Convert.ToString(dt.Rows[i]["iccid"])); //else iccidprefix = Convert.ToString(dt.Rows[i]["Sim Number"]).ToUpper(); ICCIDnumber = (Convert.ToString(dt.Rows[i]["Sim Number"])); ICCIDnumber = ICCIDnumber.Replace("'", ""); dt.Rows[i]["ICCID ON WHICH THAT BUNDLE ACTIVATED"] = ICCIDnumber; DataRow objDr = objDt.NewRow(); objDr["ICCID ON WHICH THAT BUNDLE ACTIVATED"] = ICCIDnumber; objDt.Rows.Add(objDr); //DataRow objDr = objDt.NewRow(); //objDr["ICCID ON WHICH THAT BUNDLE ACTIVATED"] = Convert.ToString(dt.Rows[i]["ICCID ON WHICH THAT BUNDLE ACTIVATED"]); //objDt.Rows.Add(objDr); } objDt.AcceptChanges(); string s1 = ""; DataView dv1 = objDt.DefaultView; dv1.RowFilter = "[ICCID ON WHICH THAT BUNDLE ACTIVATED]<>'" + s1 + "'"; objDt = dv1.ToTable(); string str = "<Table>"; foreach (DataRow dr in objDt.Rows) { str = str + "<Row><SimNo>" + dr["ICCID ON WHICH THAT BUNDLE ACTIVATED"] + "</SimNo></Row>"; } str = str + "</Table>"; DataSet ds = ssc.GetImportFile(str); // GetImportFileDetailsService(objDt, "Import") =>Error :-The remote server returned an error: (413) Request Entity Too Large // ds = ssc.GetImportFileDetailsService(objDt, "Import"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable FileObjectImportedTable = (DataTable)(ViewState["objDT"]); string s = ""; DataView dv = FileObjectImportedTable.DefaultView; dv.RowFilter = "[Sim Number]<>'" + s + "'"; FileObjectImportedTable = dv.ToTable(); DataTable ICCIDMappingTable = ds.Tables[0]; DataTable FinalMappedTable = DataTableJoinHelper.JoinTwoDataTablesOnOneColumn(FileObjectImportedTable, ICCIDMappingTable, "ICCID ON WHICH THAT BUNDLE ACTIVATED", DataTableJoinHelper.JoinType.Left); if (FinalMappedTable != null) { //grdDetails.DataSource = FinalMappedTable; //grdDetails.DataBind(); //DataView view = new DataView(FinalMappedTable); //DataTable dtExcel = view.ToTable(); FinalMappedTable.Columns.Remove("ICCID ON WHICH THAT BUNDLE ACTIVATED"); FinalMappedTable.AcceptChanges(); if (FinalMappedTable.Rows.Count > 0) { ViewState["FinalMappedTable"] = FinalMappedTable; grdDetails.DataSource = FinalMappedTable; grdDetails.DataBind(); // -------------shadab Ali--------------- due to Export Button //string filename = fileNametext + "_ReportWithDistributor" + // "_"+DateTime.UtcNow.ToString("ddMMyyyyHHmm")+ ".xls"; //System.IO.StringWriter tw = new System.IO.StringWriter(); //System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); //GridView grdView = new GridView(); ////dgGrid.HeaderStyle //grdView.DataSource = FinalMappedTable; //grdView.DataBind(); //ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true); ////Get the HTML for the control. //grdView.RenderControl(hw); ////Write the HTML back to the browser. ////Response.ContentType = application/vnd.ms-excel; //Response.ContentType = "application/vnd.ms-excel"; //Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); //this.EnableViewState = false; //Response.Write(tw.ToString()); // Response.End(); // ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true); } } } } } else { ScriptManager.RegisterStartupScript(this, Page.GetType(), "File Column Mismatch1", "alert('Please upload only .csv file')", true); } } else { ScriptManager.RegisterStartupScript(this, Page.GetType(), "File Column Mismatch2", "alert('Please select file for upload')", true); } } catch (Exception ex) { throw ex; } finally { ViewState["FileImport"] = null; ViewState["objDT"] = null; } }
private void ShowReport() { try { if (grdDetails.Rows.Count > 0) { DataTable dt = (DataTable)ViewState["objDT"]; //------Datatable for get mapped details from DB DataTable objDt = new DataTable(); objDt.TableName = "tDtSIMBulkTransfer"; objDt.Columns.Add("ICCID ON WHICH THAT BUNDLE ACTIVATED"); for (int i = 0; i < dt.Rows.Count; i++) { DataRow objDr = objDt.NewRow(); objDr["ICCID ON WHICH THAT BUNDLE ACTIVATED"] = Convert.ToString(dt.Rows[i]["ICCID ON WHICH THAT BUNDLE ACTIVATED"]); objDt.Rows.Add(objDr); } objDt.AcceptChanges(); DataSet ds = ssc.GetImportFileDetailsService(objDt, "Import"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { DataTable FileObjectImportedTable = (DataTable)(ViewState["objDT"]); DataTable ICCIDMappingTable = ds.Tables[0]; DataTable FinalMappedTable = DataTableJoinHelper.JoinTwoDataTablesOnOneColumn(FileObjectImportedTable, ICCIDMappingTable, "ICCID ON WHICH THAT BUNDLE ACTIVATED", DataTableJoinHelper.JoinType.Left); if (FinalMappedTable != null) { DataView view = new DataView(FinalMappedTable); DataTable dtExcel = view.ToTable(); if (dtExcel.Rows.Count > 0) { string filename = " FileWithDistributor.xls"; System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); GridView grdView = new GridView(); //dgGrid.HeaderStyle grdView.DataSource = dtExcel; grdView.DataBind(); ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true); //Get the HTML for the control. grdView.RenderControl(hw); //Write the HTML back to the browser. //Response.ContentType = application/vnd.ms-excel; Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); this.EnableViewState = false; Response.Write(tw.ToString()); Response.End(); ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true); } } } } } else { ShowPopUpMsg("There is no row to export to excel!!"); return; } } catch (Exception ex) { throw ex; } }