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