protected void add_Click(object sender, EventArgs e) { context.cqc_usuarios.Add(new cqc_usuarios { cs_nombre = txtName.Text, cs_correo = txtMail.Text, cs_alta = DateTime.Now, cs_modificacion = DateTime.Now, cb_southBound = chkSouth.Checked, cb_northBount = chkNorth.Checked, cb_masters = chkMasters.Checked, cb_workOrder = chkWork.Checked, cb_ups = chkUps.Checked, cb_balance = chkBalance.Checked, cb_scrap = chkScrap.Checked }); context.SaveChanges(); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Add User: " + txtName.Text }); context.SaveChanges(); limpiarTextBox(); rgSKUs.DataSource = context.cqc_usuarios.ToList(); rgSKUs.DataBind(); }
protected void add_Click(object sender, EventArgs e) { context.NorthBoundMails.Add(new NorthBoundMail { cs_nombre = txtName.Text, cs_correo = txtMail.Text, cb_active = true }); context.SaveChanges(); limpiarTextBox(); rgMails.DataSource = context.NorthBoundMails.ToList(); rgMails.DataBind(); }
protected void download_Click(object sender, EventArgs e) { LinkButton lnk = (LinkButton)sender; string PO = lnk.CommandArgument.ToString(); using (var context = new YETIEntities()) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(Server.MapPath("~/Reports/RWO.rpt")); cryRpt.SetDataSource(context.cqf_workOrder.Where(w => w.fs_workOrder == PO).ToList()); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.RefreshReport(); cryRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("~/Reports/RWO.pdf")); cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Download Report Work Order:" + PO; context.cqf_logActividad.Add(log); context.SaveChanges(); } }
protected void lnkInicio_Click(object sender, EventArgs e) { string pass = Seguridad.Encriptar(inputPassword.Value); using (var context = new YETIEntities()) { int users = context.cqc_usuarios.Where(w => w.cb_active == true && w.cs_correo == inputEmail.Value && w.cs_contrasena == pass).Count(); if (users > 0) { Session["UserID"] = context.cqc_usuarios.Where(w => w.cb_active == true && w.cs_correo == inputEmail.Value && w.cs_contrasena == pass).Select(c => c.ci_id).First().ToString(); cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Sign In "; context.cqf_logActividad.Add(log); context.SaveChanges(); Response.Redirect("Inicio.aspx"); } else { //Usuario o Contraseña equivocados } } }
protected void add_Click(object sender, EventArgs e) { context.cqc_usuarios.Add(new cqc_usuarios { cs_nombre = txtName.Text, cs_correo = txtMail.Text, cb_active = true, cb_masters = chkb_ms.Checked, cb_southBound = chkb_sb.Checked, cb_northBount = chkb_nb.Checked, cb_workOrder = chkb_wo.Checked, cb_ups = chkb_ups.Checked, cs_alta = DateTime.Now, cs_modificacion = DateTime.Now, cs_contrasena = "UABhAHMAcwB3ADAAcgBkACoA" }); context.SaveChanges(); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Add User: " + txtName.Text }); context.SaveChanges(); limpiarTextBox(); rgMails.DataSource = context.cqc_usuarios.ToList(); rgMails.DataBind(); }
protected void add_Click(object sender, EventArgs e) { context.cqc_shippers.Add(new cqc_shippers { cs_nombre = txtShipper.Text, cs_address = txtAddress.Text, cs_locacion = txtLocation.Text }); context.SaveChanges(); limpiarTextBox(); rgNombres.DataSource = context.cqc_shippers.ToList(); rgNombres.DataBind(); }
protected void yes_Click(object sender, EventArgs e) { using (var context = new YETIEntities()) { var result = context.cqf_workOrder.Where(w => w.fs_workOrder == txtWorkOrder.Text && w.fc_status == "A").ToList(); var resul2 = context.cqf_WorkOrderMaster.Where(w => w.fs_workOrder == txtWorkOrder.Text && w.fc_status == "A").ToList(); if (result != null) { foreach (cqf_workOrder s in result) { s.fc_status = "C"; context.SaveChanges(); cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Cancel Work Order: " + txtWorkOrder; context.cqf_logActividad.Add(log); context.SaveChanges(); } foreach (cqf_WorkOrderMaster s in resul2) { s.fc_status = "C"; context.SaveChanges(); cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Cancel Work Order Master: " + txtWorkOrder; context.cqf_logActividad.Add(log); context.SaveChanges(); } } } }
protected void lnkAgregar_Click(object sender, EventArgs e) { if (txtPedimento.Text != "" && txtQty.Text != "" && txtSky.Text != "" && certificado.HasFile && certificado.FileName.Contains("pdf")) { cqf_scrap sp = new cqf_scrap(); sp.fi_qty = int.Parse(txtQty.Text); sp.fs_pedimento = txtPedimento.Text; sp.fdt_fecha = DateTime.Now; sp.fs_sku = txtSky.Text; sp.fs_file = "Certificate" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".pdf"; context.cqf_scrap.Add(sp); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Add Scrap" } ); certificado.SaveAs(Server.MapPath("~/Certificates/" + sp.fs_file)); context.SaveChanges(); //Limpiar ContentPlaceHolder content = (ContentPlaceHolder)this.Master.FindControl("ContentPlaceHolder1"); foreach (Control c in content.Controls) { if (c is TextBox) { TextBox text = c as TextBox; text.Text = ""; } if (c is CheckBox) { CheckBox text = c as CheckBox; text.Checked = false; } } //Abrir modal exito ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModalSuccess();", true); } else { //Open Modal Error ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModalError();", true); } }
protected void add_Click(object sender, EventArgs e) { context.cqc_imports.Add(new cqc_imports { cs_nombre = txtImporter.Text, cs_address = txtAddress.Text, cs_locacion = txtLocation.Text, cs_rfc = txtRFC.Text, immex = txtImmex.Text }); context.SaveChanges(); limpiarTextBox(); rgNombres.DataSource = context.cqc_imports.ToList(); rgNombres.DataBind(); }
protected void add_Click(object sender, EventArgs e) { context.cqc_skus.Add(new cqc_skus { cs_sku = txtSKU.Text, cs_plant = txtPlant.Text, cs_description = txtDescription.Text, cs_comodityCode = txtCode.Text, cs_cost = decimal.Parse(txtCost.Text), cs_materialGroup = txtGroup.Text }); context.SaveChanges(); limpiarTextBox(); rgSKUs.DataSource = context.cqc_imports.ToList(); rgSKUs.DataBind(); }
protected void UploadWO_Click(object sender, EventArgs e) { if (txtWorkOrder.Text != "" && txtWorkOrderDate.Text != "") { string[] WODate = txtWorkOrderDate.Text.Split('-'); cqf_WorkOrderMaster wom = new cqf_WorkOrderMaster(); wom.fc_status = "A"; wom.fs_workOrder = txtWorkOrder.Text; wom.fdt_date = new DateTime(int.Parse(WODate[0]), int.Parse(WODate[1]), int.Parse(WODate[2])); wom.fs_shipperUpsAccount = txtshipperAccount.Text; wom.fs_reference = txtReference.Text; wom.fs_name = txtName.Text; wom.fs_telephone = txtTelephone.Text; wom.fs_company = txtCompany.Text; wom.fs_streetAddress = txtsa.Text; wom.fs_cityState = txtcs.Text; wom.fs_deliverToName = txtDelName.Text; wom.fs_deliverPhone = txtDelPhone.Text; wom.fs_deliverCompany = txtDelCom.Text; wom.fs_deliverStreetAddress = txtDelSA.Text; wom.fs_deliverCityState = txtDelCS.Text; try { wom.fd_weightLbs = double.Parse(txtWeight.Text); } catch { wom.fd_weightLbs = 0.00; } try { wom.fd_dimentionalWeight = double.Parse(txtDimentional.Text); } catch { wom.fd_dimentionalWeight = 0.00; } try { wom.fd_largePackage = double.Parse(txtLarge.Text); } catch { wom.fd_largePackage = 0.00; } wom.fs_shipperRelease = txtShipper.Text; try { wom.fd_groundSdpShippingCharges = decimal.Parse(txtGroud.Text); } catch { wom.fd_groundSdpShippingCharges = decimal.Parse("0.00"); } try { wom.fd_declareValueCarriage = decimal.Parse(txtDeclare.Text); } catch { wom.fd_declareValueCarriage = decimal.Parse("0.00"); } try { wom.fd_amount = decimal.Parse(txtAmount.Text); } catch { wom.fd_amount = decimal.Parse("0.00"); } try { wom.fd_aditionalHandlingCharge = decimal.Parse(txtAditional.Text); } catch { wom.fd_aditionalHandlingCharge = decimal.Parse("0.00"); } try { wom.fd_totalCharges = decimal.Parse(txtTotal.Text); } catch { wom.fd_totalCharges = decimal.Parse("0.00"); } wom.fb_billShipperAccountNumber = rbtn_shipAcc.Checked; wom.fb_billShipperAccountNumber = rbtn_billReceiver.Checked; wom.fb_billThirdParty = rbtn_billThirdParty.Checked; wom.fb_billCreditCard = rbtn_CreditCard.Checked; wom.fs_receiversThirdPartyUpsAcct = txtUpsAcct.Text; wom.fs_thirdPartCompanyName = txtThirdCN.Text; wom.fs_thirdCityState = txtThirdCS.Text; wom.fs_thirdStreetAddress = txtThirdSA.Text; context.cqf_WorkOrderMaster.Add(wom); context.SaveChanges(); List <cqf_workOrder> SBs = new List <cqf_workOrder>(); using (var stream = File.Open(Server.MapPath("~/WorkOrders/" + txtWorkOrder.Text + ".xls"), FileMode.Open, FileAccess.Read)) { using (var reader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { string[] ShipDate = txtWorkOrderDate.Text.Split('-'); cqf_workOrder s = new cqf_workOrder(); s.fc_status = "A"; s.fs_workOrder = txtWorkOrder.Text; try { s.fs_sku = reader.GetDouble(0).ToString(); } catch { s.fs_sku = reader.GetString(0).ToString(); } try { s.fs_paintCode = reader.GetDouble(1).ToString(); } catch { s.fs_paintCode = reader.GetString(1).ToString(); } s.fs_engraving = reader.GetString(2); s.fdt_date = new DateTime(int.Parse(ShipDate[0]), int.Parse(ShipDate[1]), int.Parse(ShipDate[2])); s.fi_qty = int.Parse(reader.GetDouble(3).ToString()); if (s.fs_sku == null) { reader.NextResult(); } else { using (var context = new YETIEntities()) { context.cqf_workOrder.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 Work Order: " + txtWorkOrder.Text; context.cqf_logActividad.Add(log); context.SaveChanges(); } Response.Redirect("Inicio.aspx"); } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal2();", true); } }
protected void btnUpload_Click(object sender, EventArgs e) { if (txtWorkOrder.Text != "") { if (ImportSB.HasFile && ImportSB.FileName.Contains(".xls")) { //UploadedFile file = layoutUpload.UploadedFiles[0]; if (File.Exists(Server.MapPath("~/WorkOrders/" + txtWorkOrder.Text + ".xls"))) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true); } else { ImportSB.SaveAs(Server.MapPath("~/WorkOrders/" + txtWorkOrder.Text + ".xls")); context.cqf_logActividad.Add(new cqf_logActividad { fdt_fecha = DateTime.Now, fi_idUsuario = int.Parse(Session["UserID"].ToString()), fs_actividad = "Upload Work Order File" }); context.SaveChanges(); } } List <cqf_workOrder> SBs = new List <cqf_workOrder>(); using (var stream = File.Open(Server.MapPath("~/WorkOrders/" + txtWorkOrder.Text + ".xls"), FileMode.Open, FileAccess.Read)) { using (var reader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream)) { while (reader.Read()) { if (reader.Depth >= 1) { //reader.NextResult(); try { string[] ShipDate = txtWorkOrderDate.Text.Split('-'); cqf_workOrder s = new cqf_workOrder(); s.fc_status = "A"; s.fs_workOrder = txtWorkOrder.Text; try{ s.fs_sku = reader.GetDouble(0).ToString(); } catch { s.fs_sku = reader.GetString(0).ToString(); } try { s.fs_paintCode = reader.GetDouble(1).ToString(); } catch { s.fs_paintCode = reader.GetString(1).ToString(); } s.fs_engraving = reader.GetString(2); s.fdt_date = new DateTime(int.Parse(ShipDate[0]), int.Parse(ShipDate[1]), int.Parse(ShipDate[2])); s.fi_qty = int.Parse(reader.GetDouble(3).ToString()); if (s.fs_sku == null) { reader.NextResult(); } else { SBs.Add(s); } } catch (Exception ex) { Console.Write(ex.Message); } } } rgWorkOrder.DataSource = SBs.ToList(); rgWorkOrder.DataBind(); } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal2();", true); } }
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"); }
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);/ }