protected void btnUpload_Click(object sender, EventArgs e) { string filePath = ""; string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + Session["UserID"].ToString() + ".xls"; if (ImportSB.HasFile) { if (File.Exists(Server.MapPath("~/NorthBound/" + filename))) { // File.Delete(Server.MapPath("~/NorthBound/" + ImportSB.FileName)); } else { ImportSB.SaveAs(Server.MapPath("~/NorthBound/" + filename)); filePath = Server.MapPath("~/NorthBound/" + filename); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Upload North Bound File" }); context.SaveChanges(); lblFilename.Text = filename; List <NorthBound> SBs = new List <NorthBound>(); using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { NorthBound s = new NorthBound(); s.fc_status = "A"; s.fdt_invoiceDate = reader.GetDateTime(0); s.fs_invoiceNumber = reader.GetString(1); try { s.fs_trailerNumber = reader.GetString(2); } catch { s.fs_trailerNumber = reader.GetDouble(2).ToString(); } s.fs_sealNumber = reader.GetString(3); s.fi_exportOfRecord = 1; s.fs_exportOfRecord = "Maquila Solutions Mexico SA de CV"; s.fi_importer = 1; s.fs_importer = "YETI Coolers, LLC"; s.fi_shipper = 1; s.fs_shipper = "Maquila Solutions c/o Scanpaint SA de CV"; s.fi_shipTo = 1; s.fs_shipTo = reader.GetString(7); s.fs_incoterm = "EXW"; s.fdt_shipDate = reader.GetDateTime(9); s.fs_shipVia = reader.GetString(10); try { s.fs_SKU = reader.GetString(11); } catch { s.fs_SKU = reader.GetDouble(11).ToString(); } s.fs_descYeti = reader.GetString(12); s.fs_hsCodeYeti = reader.GetString(13); s.fs_COOYeti = "CN"; s.fi_qtyYeti = int.Parse(reader.GetDouble(15).ToString()); s.fd_unitPriceYeti = decimal.Parse(reader.GetDouble(16).ToString()); s.fd_extPriceYeti = decimal.Parse(reader.GetDouble(17).ToString()); s.fs_descSP = reader.GetString(18); s.fs_hsCodeSP = reader.GetString(19); s.fs_COOSP = "CN"; s.fd_unitPriceSP = decimal.Parse(reader.GetDouble(21).ToString()); try { s.fs_WONumber = reader.GetString(22); } catch { s.fs_WONumber = reader.GetDouble(22).ToString(); } try { s.fs_upsTracking = reader.GetString(23); } catch { s.fs_upsTracking = reader.GetDouble(23).ToString(); } s.fd_extPriceSP = decimal.Parse(reader.GetDouble(24).ToString()); s.fd_totalEnteredValue = decimal.Parse(reader.GetDouble(25).ToString()); s.fd_totalWeight = reader.GetDouble(26); s.fd_totalAmount = decimal.Parse(reader.GetDouble(27).ToString()); if (s.fs_descSP == null) { reader.NextResult(); } else { SBs.Add(s); } } catch (Exception ex) { Console.Write(ex.Message); } } } } } uploadinformation.Visible = true; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModalMensajes();", true); rgNorthBound.DataSource = SBs.ToList(); rgNorthBound.DataBind(); } } }
protected void uploadinformation_Click(object sender, EventArgs e) { List <NorthBound> SBs = new List <NorthBound>(); using (var stream = File.Open(Server.MapPath("~/NorthBound/" + lblFilename.Text), FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { NorthBound s = new NorthBound(); s.fc_status = "A"; s.fdt_invoiceDate = reader.GetDateTime(0); s.fs_invoiceNumber = reader.GetString(1); try { s.fs_trailerNumber = reader.GetString(2); } catch { s.fs_trailerNumber = reader.GetDouble(2).ToString(); } s.fs_sealNumber = reader.GetString(3); s.fi_exportOfRecord = 1; s.fs_exportOfRecord = "Maquila Solutions Mexico SA de CV"; s.fi_importer = 1; s.fs_importer = "YETI Coolers, LLC"; s.fi_shipper = 1; s.fs_shipper = "Maquila Solutions c/o Scanpaint SA de CV"; s.fi_shipTo = 1; s.fs_shipTo = reader.GetString(7); s.fs_incoterm = "EXW"; s.fdt_shipDate = reader.GetDateTime(9); s.fs_shipVia = reader.GetString(10); try { s.fs_SKU = reader.GetString(11); } catch { s.fs_SKU = reader.GetDouble(11).ToString(); } s.fs_descYeti = reader.GetString(12); s.fs_hsCodeYeti = reader.GetString(13); s.fs_COOYeti = "CN"; s.fi_qtyYeti = int.Parse(reader.GetDouble(15).ToString()); s.fd_unitPriceYeti = decimal.Parse(reader.GetDouble(16).ToString()); s.fd_extPriceYeti = decimal.Parse(reader.GetDouble(17).ToString()); s.fs_descSP = reader.GetString(18); s.fs_hsCodeSP = reader.GetString(19); s.fs_COOSP = "CN"; s.fd_unitPriceSP = decimal.Parse(reader.GetDouble(21).ToString()); try { s.fs_WONumber = reader.GetString(22); } catch { s.fs_WONumber = reader.GetDouble(22).ToString(); } try { s.fs_upsTracking = reader.GetString(23); } catch { s.fs_upsTracking = reader.GetDouble(23).ToString(); } s.fd_extPriceSP = decimal.Parse(reader.GetDouble(24).ToString()); s.fd_totalEnteredValue = decimal.Parse(reader.GetDouble(25).ToString()); s.fd_totalWeight = reader.GetDouble(26); s.fd_totalAmount = decimal.Parse(reader.GetDouble(27).ToString()); if (s.fs_descSP == null) { reader.NextResult(); } else { SBs.Add(s); /*using (var context = new YETIEntities()) * { * * context.NorthBounds.Add(s); * context.SaveChanges(); * } * * Response.Redirect("Inicio.aspx");*/ } } catch (Exception ex) { Console.Write(ex.Message); } } } } } if (SBs.Count > 0) { foreach (NorthBound n in SBs) { using (var context = new YETIEntities()) { context.NorthBounds.Add(n); context.SaveChanges(); } } context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Add North Bound" }); context.SaveChanges(); Response.Redirect("NorthBoundList.aspx"); } //ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModalMensajes2();", true);/ }