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