protected void btnUpload_Click(object sender, EventArgs e) { //string filePath = ""; if (ImportSB.HasFile && ImportSB.FileName.Contains(".xls")) { //UploadedFile file = layoutUpload.UploadedFiles[0]; if (File.Exists(Server.MapPath("~/Southbound/" + txtPO.Text + ".xls"))) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true); } else { ImportSB.SaveAs(Server.MapPath("~/Southbound/" + txtPO.Text + ".xls")); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Upload Production Order File" }); context.SaveChanges(); } } List <SouthBound> SBs = new List <SouthBound>(); using (var stream = File.Open(Server.MapPath("~/Southbound/" + txtPO.Text + ".xls"), FileMode.Open, FileAccess.Read)) { using (var reader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { string[] date = txtDate.Text.Split('-'); string[] ShipDate = txtShipDate.Text.Split('-'); SouthBound s = new SouthBound(); s.fc_status = "A"; s.fs_invoice = txtInvoice.Text; s.fs_trucker = txtTrucker.Text; s.fd_date = new DateTime(int.Parse(date[0]), int.Parse(date[1]), int.Parse(date[2])); s.fs_tracking = txtTracking.Text; s.fs_productionOrder = txtPO.Text; s.fs_reference = txtReference.Text; s.fi_exportRecords = int.Parse(ddlsexport.SelectedItem.Value); s.fs_exportRecords = ddlsexport.SelectedItem.Text; s.fi_importRecords = int.Parse(ddlsimport.SelectedItem.Value); s.fs_importRecords = ddlsimport.SelectedItem.Text; s.fi_shipper = int.Parse(ddlsShippers.SelectedItem.Value); s.fs_shipper = ddlsShippers.SelectedItem.Text; s.fi_shipTo = int.Parse(ddlsShipTo.SelectedItem.Value); s.fs_shipTo = ddlsShipTo.SelectedItem.Text; s.fs_moneda = ddlsCurrency.SelectedItem.Text; s.fs_incoterms = ddlsIncoterms.SelectedItem.Text; s.fd_shipDate = new DateTime(int.Parse(ShipDate[0]), int.Parse(ShipDate[1]), int.Parse(ShipDate[2])); s.fs_partNumber = reader.GetString(1); s.fs_description = reader.GetString(1); s.fs_scheduleHsCode = reader.GetString(2); s.fs_coo = reader.GetString(3); s.fi_qty = int.Parse(reader.GetDouble(4).ToString()); s.fd_totalWeightLbs = reader.GetDouble(5); s.fd_totalWeightKgs = reader.GetDouble(6); s.fd_unitPrice = decimal.Parse(reader.GetDouble(7).ToString()); s.fd_exitPrice = decimal.Parse(reader.GetDouble(8).ToString()); if (s.fs_partNumber == null) { reader.NextResult(); } else { SBs.Add(s); } } catch (Exception ex) { Console.Write(ex.Message); } } } rgProductionOrder.DataSource = SBs.ToList(); rgProductionOrder.DataBind(); } } }
protected void lnkInsertar_Click(object sender, EventArgs e) { List <SouthBound> SBs = new List <SouthBound>(); using (var stream = File.Open(Server.MapPath("~/Southbound/" + txtPO.Text + ".xls"), FileMode.Open, FileAccess.Read)) { using (var reader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { string[] date = txtDate.Text.Split('-'); string[] ShipDate = txtShipDate.Text.Split('-'); SouthBound s = new SouthBound(); s.fc_status = "A"; s.fs_invoice = txtInvoice.Text; s.fs_trucker = txtTrucker.Text; s.fd_date = new DateTime(int.Parse(date[0]), int.Parse(date[1]), int.Parse(date[2])); s.fs_tracking = txtTracking.Text; s.fs_productionOrder = txtPO.Text; s.fs_reference = txtReference.Text; s.fi_exportRecords = int.Parse(ddlsexport.SelectedItem.Value); s.fs_exportRecords = ddlsexport.SelectedItem.Text; s.fi_importRecords = int.Parse(ddlsimport.SelectedItem.Value); s.fs_importRecords = ddlsimport.SelectedItem.Text; s.fi_shipper = int.Parse(ddlsShippers.SelectedItem.Value); s.fs_shipper = ddlsShippers.SelectedItem.Text; s.fi_shipTo = int.Parse(ddlsShipTo.SelectedItem.Value); s.fs_shipTo = ddlsShipTo.SelectedItem.Text; s.fs_moneda = ddlsCurrency.SelectedItem.Text; s.fs_incoterms = ddlsIncoterms.SelectedItem.Text; s.fd_shipDate = new DateTime(int.Parse(ShipDate[0]), int.Parse(ShipDate[1]), int.Parse(ShipDate[2])); try { s.fs_partNumber = reader.GetString(0); } catch { s.fs_partNumber = reader.GetDouble(0).ToString(); } s.fs_description = reader.GetString(1); s.fs_scheduleHsCode = reader.GetString(2); s.fs_coo = reader.GetString(3); s.fi_qty = int.Parse(reader.GetDouble(4).ToString()); s.fd_totalWeightLbs = reader.GetDouble(5); s.fd_totalWeightKgs = reader.GetDouble(6); s.fd_unitPrice = decimal.Parse(reader.GetDouble(7).ToString()); s.fd_exitPrice = decimal.Parse(reader.GetDouble(8).ToString()); if (s.fs_partNumber == null) { reader.NextResult(); } else { using (var context = new YETIEntities()) { context.SouthBounds.Add(s); context.SaveChanges(); } } } catch (Exception ex) { Console.Write(ex.Message); } } } using (var context = new YETIEntities()) { cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Add Production Order: " + txtPO.Text; context.cqf_logActividad.Add(log); context.SaveChanges(); } } } Response.Redirect("SouthBoundList.aspx"); }