protected void btnFindInvoice_Click(object sender, EventArgs e)
{
//string ricevuta = aMerchant.invoicePrefix(amzSettings) + txInvoice.Text.Trim();
string ricevuta = txInvoice.Text.Trim();
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
wc.Open();
ArrayList al = new ArrayList();
string errore = "";
AmazonOrder.Order o = AmazonOrder.Order.FindOrderByInvoice(ricevuta, amzSettings, aMerchant, wc, out errore);
al.Add(o);
wc.Close();
if (o != null)
{
fillGrid(int.Parse(dropVett.SelectedValue), amzSettings, al); //, false);
}
else if (o == null || errore != "")
{
Response.Write("Impossibile contattare amazon, riprova più tardi!<br />Errore: " + errore);
return;
}
else
{
Response.Write("Nessun ordine trovato!");
}
}
protected void btnFindSingleOrder_Click(object sender, EventArgs e)
{
string errore;
if (!(AmazonOrder.Order.CheckOrderNum(txNumOrdine.Text)))
{
return;
}
AmazonOrder.Order o = AmazonOrder.Order.ReadOrderByNumOrd(txNumOrdine.Text, amzSettings, aMerchant, out errore);
if (o != null)
{
ArrayList l = new ArrayList();
l.Add(o);
gvShips.DataSource = null;
gvShips.DataBind();
//addFirstRow(op.tipo, settings);
//createGrid(l, false, op.tipo, settings);
//addFirstRow(op.tipo, settings);
//createGrid(l, false, op.tipo, settings);
fillGrid(int.Parse(dropVett.SelectedValue), amzSettings, l); //, false);
}
else if (o == null || errore != "")
{
Response.Write("Impossibile contattare amazon, riprova più tardi!<br />Errore: " + errore);
return;
}
//imbNextPag.Visible = imbPrevPag.Visible = false;
}
public EcmScheda(AmazonOrder.Order o, bool amazon, string cat)
{
this.spedizione = o.ShipmentServiceLevelCategory;
this.tipoAcquisto = o.canaleOrdine;
this.compratore = o.buyer;
this.address = o.destinatario;
this.canaleVendita = o.canaleVendita;
this.cat_scheda = cat;
this.dataOrdine = o.dataUltimaMod;
this.isAmazon = amazon;
}
protected void btnMakePdf_Click(object sender, EventArgs e)
{
string data = "&invDate=" + calDataInvoice.SelectedDate.ToString().Replace("/", ".");
//data = labDataScelta.Text.ToString().Replace("/", ".");
if (dataInvoiceHidden.Value != null || dataInvoiceHidden.Value.ToString() != "0")
{
data = "&invDate=" + dataInvoiceHidden.Value.ToString();
}
string numord = Request.QueryString["amzOrd"].ToString();
bool movim = (Request.Form["chkMovimenta"] != null && Request.Form["chkMovimenta"].ToString() == "on");
AmazonOrder.Order o = (AmazonOrder.Order)Session[numord];
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
cnn.Open();
if (o.Items == null)
{
wc.Open();
System.Threading.Thread.Sleep(1500);
o.RequestItemsAndSKU(amzSettings, aMerchant, settings, cnn, wc);
wc.Close();
}
if (movim && !o.HasDispItems(cnn, calDataInvoice.SelectedDate))
{
cnn.Close();
chkMovimenta.Enabled = chkMovimenta.Checked = false;
Response.Write("Disponibilità negative per uno o più Item dell'ordine. Impossibile eseguire lo scarico.<br />" +
"Puoi solo creare il pdf.");
return;
}
cnn.Close();
int invoicenum = (Request.QueryString["amzInv"] != null) ? int.Parse(Request.QueryString["amzInv"].ToString()) : 0;
string regalo = (Request.Form["chkRegalo"] != null && Request.Form["chkRegalo"].ToString() == "on") ? "®alo=true" : "®alo=false";
string mov = movim ? "&movimenta=true" : "&movimenta=false";
string comunicazione = (Request.Form["chkSendRisp"] != null && Request.Form["chkSendRisp"].ToString() == "on") ? "&tiporisposta=" + Request.Form["dropRisposte"].ToString() : "";
string schedaecm = (Request.Form["chkMakeEcmScheda"] != null && Request.Form["chkMakeEcmScheda"].ToString() == "on") ? "&schedaecm=true" : "&schedaecm=false";
string vettSig = (Request.Form["dropVettori"] != null && Request.Form["dropVettori"].ToString() != "0") ? "&vettS=" + Request.Form["dropVettori"].ToString() : "";
//string token = (Request.QueryString["token"] != null) ? Request.QueryString["token"].ToString() : "";
Response.Redirect("download.aspx?amzOrd=" + numord + "&amzInv=" + invoicenum + regalo + mov + schedaecm + comunicazione + MakeQueryParams() + data + vettSig);
}
//private int Year;
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["bprefix"] != null && Request.QueryString["start"] != null && Request.QueryString["vettID"] != null && Session["addresses"] != null && Session["orderList"] != null)
{
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
settings = (UtilityMaietta.genSettings)Session["settings"];
string csv = "";
string bprefix = Request.QueryString["bprefix"].ToString();
int start = int.Parse(Request.QueryString["start"].ToString());
int vettID = int.Parse(Request.QueryString["vettID"].ToString());
string code;
int c = 0;
List <string> lines = new List <string>();
for (c = 0; c < ((ArrayList)Session["addresses"]).Count; c++)
{
code = bprefix + (start + c).ToString().PadLeft(2, '0');
//csv = ((AmazonOrder.Order)((ArrayList)Session["orderIDS"])[c]).orderid + "\t" + DateTime.Today.ToString("ddMMyy") + "\t" + code.ToUpper();
csv = (((ArrayList)Session["orderIDS"])[c]).ToString() + "\t" + DateTime.Today.ToString("ddMMyy") + "\t" + code.ToUpper();
lines.Add(csv);
}
Shipment.ShipRead sr = new Shipment.ShipRead(vettID, amzSettings.amzShipReadColumns);
string[] array = Shipment.ShipRead.AmazonLoadTable(lines, sr, '\t');
csv = "";
foreach (string s in array)
{
csv = (csv == "") ? s : csv + '\n' + s;
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + bprefix + start + "_" + c + ".txt");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
else if (Request.QueryString["shipment"] != null && Session["shipmentTable"] != null)
{
string vettName = Request.QueryString["shipment"].ToString();
System.Data.DataTable csvTable =
(System.Data.DataTable)Session["shipmentTable"];
string csv = "";
int i;
foreach (DataRow dr in csvTable.Rows)
{
for (i = 0; i < csvTable.Columns.Count - 1; i++)
{
csv += dr[i].ToString() + ";";
}
csv += dr[i].ToString() + Environment.NewLine;
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + vettName + "_" + csvTable.Rows.Count.ToString() + ".csv");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
else if (Request.QueryString["csvPackage"] != null && Session[Request.QueryString["csvPackage"].ToString()] != null)
{
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
string shipid = Request.QueryString["csvPackage"].ToString();
FileUpload fup = ((FileUpload)Session["fupPackage"]);
string sourceFile = fup.FileName;
((FileUpload)Session["fupPackage"]).SaveAs(Path.Combine(Server.MapPath("temp"), "model_" + sourceFile));
string localFile = Path.Combine(Server.MapPath("temp"), "model_" + sourceFile);
List <string> lines = File.ReadLines(localFile).ToList();
int colSt = SHIP_MODEL_COL_START;
int rowSt = SHIP_MODEL_ROW_START;
string[] linea;
string fnsku;
boxSets.shipsInfo ship = (boxSets.shipsInfo)Session["ship_" + shipid];
boxSets.Box box;
List <int> boxlistIndexes;
List <string[]> finalRows = new List <string[]>();
DateTime? scad;
int hPos;
// PER OGNI SKU CERCO I BOX
for (int i = rowSt; i < lines.Count; i++)
{
linea = lines[i].Split('\t');
fnsku = linea[SHIP_MODEL_FNSKU_COL];
boxlistIndexes = ship.BoxContainsNames(fnsku);
// PER OGNI BOX IN CUI SKU è PRESENTE SCRIVO QUANTITA
foreach (int index in boxlistIndexes)
{
//box = ship.GetBox(bid);
box = ship.GetBox(index);
scad = box.GetScadenza(fnsku);
hPos = (index * 2) + colSt;
//hPos = (box.id * 2) + colSt;
linea[hPos] = box.GetItemsQtBySku(fnsku).ToString();
//if (hPos + 1 < linea.Length && linea[hPos + 1].Trim() == "")
if (scad.HasValue && hPos + 1 < linea.Length && linea[hPos + 1].Trim() == "")
{
//linea[hPos + 1] = DateTime.Today.AddYears(1).ToShortDateString();
linea[hPos + 1] = scad.Value.ToShortDateString();
}
}
// CONSERVO LA LINEA CON LE QUANTITA
finalRows.Add(linea);
}
List <string> finalFile = new List <string>();
// RICOSTRUISCO IL FILE: INTESTAZIONE
for (int i = 0; i < rowSt; i++)
{
finalFile.Add(lines[i]);
}
string res;
// RICOSTRUISCO IL FILE: PRODOTTI
foreach (string [] skuRow in finalRows)
{
res = String.Join('\t'.ToString(), skuRow);
finalFile.Add(res);
}
string file = String.Join('\n'.ToString(), finalFile);
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + sourceFile);
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(file);
Response.Flush();
Response.End();
}
else if (Request.QueryString["csvFull"] != null && Session[Request.QueryString["csvFull"].ToString()] != null)
{
string shipid = Request.QueryString["csvFull"].ToString();
//string[] cods, qts;
string csv = "codicemaietta;qt;descrizione;sku";
foreach (AmzIFace.AmzonInboundShipments.ShipItem si in (List <AmzIFace.AmzonInboundShipments.ShipItem>)Session[shipid])
{
csv += Environment.NewLine + " ;" + si.quantita + ";" + si.title + ";" + si.FNSKU;
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + shipid + "_full.csv");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
else if (Request.QueryString["csv"] != null && Session[Request.QueryString["csv"].ToString()] != null)
{
string shipid = Request.QueryString["csv"].ToString();
string csv = "";
string[] cods, qts;
csv += "codicemaietta;qt";
foreach (AmzIFace.AmzonInboundShipments.ShipItem si in (List <AmzIFace.AmzonInboundShipments.ShipItem>)Session[shipid])
{
if (si.codmaie == "" || si.qtSca == "")
{
csv += Environment.NewLine + si.codmaie + ";" + si.quantita;
continue;
}
cods = si.codmaie.Split(';');
qts = si.qtSca.Split(';');
for (int i = 0; i < cods.Length; i++)
{
csv += Environment.NewLine + cods[i].Trim() + ";" + (si.quantita * int.Parse(qts[i].Trim())).ToString();
}
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + shipid + ".csv");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
else if (Request.QueryString["path"] != null)
{
string filePath = Request.QueryString["path"].ToString();
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "image/jpg";
Response.AddHeader("content-disposition", "attachment;filename=" + Path.GetFileName(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(filePath))).Replace(" ", "_"));
Response.TransmitFile(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(filePath)));
Response.End();
}
else if (Request.QueryString["zip"] != null && Request.QueryString["id"] != null && Request.QueryString["tipo"] != null)
{
string dir = Request.QueryString["zip"].ToString();
string idLav = Request.QueryString["id"].ToString();
string tipo = Request.QueryString["tipo"].ToString();
string outZip = tipo + "_" + idLav + ".zip";
StreamCompressDirectory(dir, outZip);
}
else if (Request.QueryString["rtfId"] != null)
{
int idLav = int.Parse(Request.QueryString["rtfId"].ToString());
StreamConvertHtml(idLav);
}
else if (Request.QueryString["pdf"] != null && Request.QueryString["amzOrd"] != null && Session[Request.QueryString["amzOrd"].ToString()] != null && Request.QueryString["merchantId"] != null)
{
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
string orderID = Request.QueryString["amzOrd"].ToString();
AmazonOrder.Order order = (AmazonOrder.Order)Session[orderID];
int invoiceNum = order.InvoiceNum;
DateTime invoiceDate = order.InvoiceDate;
string siglaV = order.GetSiglaVettoreStatus();
aMerchant = new AmzIFace.AmazonMerchant(int.Parse(Request.QueryString["merchantId"].ToString()), amzSettings.Year, amzSettings.marketPlacesFile, amzSettings);
AmzIFace.AmazonInvoice.makeInvoicePdf(amzSettings, aMerchant, order, invoiceNum, true, invoiceDate, siglaV, false);
//string fixedFileRegalo = Path.Combine(amzSettings.invoicePdfFolder(aMerchant), aMerchant.invoicePrefix(amzSettings) + invoiceNum.ToString().PadLeft(2, '0') + "_regalo.pdf");
string fixedFileRegalo = order.GetGiftFile(amzSettings, aMerchant);
//if (File.Exists(fixedFileRegalo))
if (order.ExistsGiftFile(amzSettings, aMerchant))
{
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline;filename=" + Path.GetFileName(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(fixedFileRegalo))).Replace(" ", "_"));
Response.TransmitFile(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(fixedFileRegalo)));
}
else
{
Response.Write("File " + fixedFileRegalo + " non trovato!");
}
Response.End();
}
else if (Request.QueryString["pdf"] != null)
{
string filePath = Request.QueryString["pdf"].ToString();
if (File.Exists(filePath))
{
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline;filename=" + Path.GetFileName(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(filePath))).Replace(" ", "_"));
Response.TransmitFile(HttpUtility.HtmlDecode(HttpUtility.UrlDecode(filePath)));
}
else
{
Response.Write("File " + filePath + " non trovato!");
}
Response.End();
}
else if (Request.QueryString["amzOrd"] != null && Request.QueryString["amzInv"] != null && Request.QueryString["merchantId"] != null)
{
int invN = 0;
//if (Session["amzSettings"] == null || !int.TryParse(Request.QueryString["amzInv"].ToString(), out invN) || invN < 1)
if (Session["amzSettings"] == null || !int.TryParse(Request.QueryString["amzInv"].ToString(), out invN))// || invN < 1)
{
Response.Write("Sessione scaduta");
return;
}
//string invoiceNum = Request.QueryString["amzInv"].ToString();
string amzOrd = Request.QueryString["amzOrd"].ToString();
int risposta = (Request.QueryString["tiporisposta"] != null) ? int.Parse(Request.QueryString["tiporisposta"].ToString()) : 0;
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
settings = (UtilityMaietta.genSettings)Session["settings"];
UtilityMaietta.Utente u = (UtilityMaietta.Utente)Session["Utente"];
//Year = DateTime.Today.Year;
aMerchant = new AmzIFace.AmazonMerchant(int.Parse(Request.QueryString["merchantId"].ToString()), amzSettings.Year, amzSettings.marketPlacesFile, amzSettings);
COUNTRY = amzSettings.Year + " - " + aMerchant.nazione + " " + aMerchant.ImageUrlHtml(25, 40, "inherit");
string errore = "";
AmazonOrder.Order order;
if (Session[Request.QueryString["amzOrd"].ToString()] != null)
{
order = (AmazonOrder.Order)Session[Request.QueryString["amzOrd"].ToString()];
}
else
{
order = AmazonOrder.Order.ReadOrderByNumOrd(amzOrd, amzSettings, aMerchant, out errore);
}
if (order == null || errore != "")
{
Response.Write("Impossibile contattare amazon, riprova più tardi!<br />Errore: " + errore);
return;
}
DateTime invoiceDate;
if (Request.QueryString["invDate"] != null)
{
invoiceDate = DateTime.Parse(Request.QueryString["invDate"].ToString());
}
else
{
invoiceDate = DateTime.Today;
}
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
cnn.Open();
wc.Open();
if (order.Items == null)
{
order.RequestItemsAndSKU(amzSettings, aMerchant, settings, cnn, wc);
}
int vettS = 0;
if (Request.QueryString["vettS"] != null)
{
int.TryParse(Request.QueryString["vettS"].ToString(), out vettS);
}
vettS = (vettS == 0) ? order.GetVettoreID(amzSettings) : vettS;
int invoiceNum;
/// IMPORTO DEFINITIVAMENTE L'ORDINE CON I VALORI della precedente schermata. ///
///
if (int.Parse(Request.QueryString["amzInv"].ToString()) > 0)
{
// ORDINE GIA' COMPLETAMENTE IMPORTATO E CON RICEVUTA, SOLO NUOVE MOVIMENTAZIONI
invoiceNum = int.Parse(Request.QueryString["amzInv"].ToString());
if (order.GetVettoreID(amzSettings) != vettS) // NUOVO VETTORE, AGGIORNO
{
order.UpdateVettore(cnn, wc, vettS);
}
}
else if (order.IsFullyImported() || order.IsImported())
{
// ORDINE COMPLETAMENTE IMPORTATO, CREO NUMERO RICEVUTA e MOVIMENTAZIONI
invoiceNum = order.UpdateFullStatus(wc, cnn, amzSettings, aMerchant, invoiceDate, vettS, true);
}
else
{
// ORDINE DA IMPORTARE, CREO NUMERO RICEVUTA E MOVIMENTAZIONI
invoiceNum = order.SaveFullStatus(wc, cnn, amzSettings, aMerchant, invoiceDate, vettS, true);
}
///
//string fixedFile = Path.Combine(amzSettings.invoicePdfFolder(aMerchant), aMerchant.invoicePrefix(amzSettings) + invoiceNum.ToString().PadLeft(2, '0') + ".pdf");
string fixedFile = AmazonOrder.Order.GetInvoiceFile(amzSettings, aMerchant, invoiceNum);
//string fixedFileRegalo = Path.Combine(amzSettings.invoicePdfFolder(aMerchant), aMerchant.invoicePrefix(amzSettings) + invoiceNum.ToString().PadLeft(2, '0') + "_regalo.pdf");
string fixedFileRegalo = order.GetGiftFile(amzSettings, aMerchant);
if (File.Exists(fixedFile))
{
Response.Write("Impossibile sovrascrivere il file " + fixedFile + "<br />" +
"Devi cancellarlo prima di poterlo sovrascrivere!");
return;
}
//else if (File.Exists(fixedFileRegalo))
else if (order.ExistsGiftFile(amzSettings, aMerchant))
{
Response.Write("Impossibile sovrascrivere il file " + fixedFileRegalo + "<br />" +
"Devi cancellarlo prima di poterlo sovrascrivere!");
return;
}
if (Request.QueryString["movimenta"] != null && bool.Parse(Request.QueryString["movimenta"].ToString()))
{
string inv = aMerchant.invoicePrefix(amzSettings) + invoiceNum.ToString().PadLeft(2, '0');
if (!order.HasDispItems(cnn, invoiceDate))
{
cnn.Close();
wc.Close();
Response.Write("Disponibilità negative per uno o più Item dell'ordine. Impossibile eseguire lo scarico.<br />" +
"Puoi solo creare il pdf.");
return;
}
List <AmzIFace.ProductMaga> pm = order.MakeMovimentaAllItems(cnn, amzSettings, u, inv, invoiceDate, order.dataUltimaMod, aMerchant, settings);
UtilityMaietta.writeMagaOrder(pm, amzSettings.AmazonMagaCode, settings, 'F');
}
if (Request.QueryString["schedaecm"] != null && bool.Parse(Request.QueryString["schedaecm"].ToString()))
{
OleDbConnection ecmScn = new OleDbConnection(settings.EcmOleDbConnString);
ecmScn.Open();
EcmUtility.EcmScheda es = new EcmUtility.EcmScheda(order, true, EcmUtility.categoria);
es.makeSchedaEcm(ecmScn);
ecmScn.Close();
}
string siglaV = (vettS == 0) ? order.GetSiglaVettore(cnn, amzSettings) : order.GetSiglaVettoreStatus();
//AmzIFace.AmazonInvoice.makeInvoicePdf(amzSettings, aMerchant, order, invN, false, invoiceDate, siglaV, false);
AmzIFace.AmazonInvoice.makeInvoicePdf(amzSettings, aMerchant, order, invoiceNum, false, invoiceDate, siglaV, false);
if (Request.QueryString["regalo"] != null && bool.Parse(Request.QueryString["regalo"].ToString()))
{
fixedFile = fixedFileRegalo;
//AmzIFace.AmazonInvoice.makeInvoicePdf(amzSettings, aMerchant, order, invN, true, invoiceDate, siglaV, false);
AmzIFace.AmazonInvoice.makeInvoicePdf(amzSettings, aMerchant, order, invoiceNum, true, invoiceDate, siglaV, false);
}
cnn.Close();
wc.Close();
if (risposta != 0)
{
AmazonOrder.Comunicazione com = new AmazonOrder.Comunicazione(risposta, amzSettings, aMerchant);
string subject = com.Subject(order.orderid);
string attach = (com.selectedAttach && File.Exists(fixedFile)) ? fixedFile : "";
bool send = UtilityMaietta.sendmail(attach, amzSettings.amzDefMail, order.buyer.emailCompratore, subject,
com.GetHtml(order.orderid, order.destinatario.ToHtmlFormattedString(), order.buyer.nomeCompratore), false, "", "", settings.clientSmtp,
settings.smtpPort, settings.smtpUser, settings.smtpPass, false, null);
}
/*Response.Buffer = true;
* Response.Charset = "";
* Response.Cache.SetCacheability(HttpCacheability.NoCache);
* Response.ContentType = "application/pdf";
* Response.AddHeader("content-disposition", "attachment;filename=" + Path.GetFileName(fixedFile));
* Response.TransmitFile(fixedFile);*/
/*
*
*/
/*if (Request.QueryString["amzToken"] != null)
* {
* string nexttoken = Request.QueryString["amzToken"].ToString();
* //imbNextPag.PostBackUrl = "amzPanoramica.aspx?token=" + Session["token"].ToString() + "&merchantId=" + Request.QueryString["merchantId"].ToString() + "&amzToken=" + HttpUtility.UrlEncode(nexttoken);
*
* ClientScript.RegisterStartupScript(this.GetType(), "amzTokenPb",
* "<script type='text/javascript' language='javascript'>" +
* "window.open('download.aspx?pdf=" + HttpUtility.UrlEncode(fixedFile) + "&token=" + Session["token"].ToString() + "', '_blank');" +
* "__doPostBack('imbNextPag','OnClick');</script>");
* }
* else*/
//{
Response.Write(@"<script lang='text/javascript'>window.open('download.aspx?pdf=" + HttpUtility.UrlEncode(fixedFile) + "&token=" + Session["token"].ToString() + "', '_blank');" +
"window.top.location.href = 'amzPanoramica.aspx?token=" + Session["token"].ToString() + MakeQueryParams() + "';</script>)");
//}
/*if (Session["token"] != null)
* Response.Redirect("amzPanoramica.aspx?token=" + Session["token"].ToString() + MakeQueryParams());
* else
* Response.Redirect("login.aspx?path=amzPanoramica");
* Response.End();*/
}
else if (Request.QueryString["amzBCSku"] != null && Request.QueryString["labQt"] != null && Request.QueryString["descBC"] != null &&
Request.QueryString["status"] != null && Request.QueryString["labCode"] != null)
{
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
settings = (UtilityMaietta.genSettings)Session["settings"];
int numLabels = int.Parse(Request.QueryString["labQt"].ToString());
string sku = Request.QueryString["amzBCSku"].ToString();
string descBC = HttpUtility.HtmlDecode(HttpUtility.UrlDecode(Request.QueryString["descBC"].ToString()));
string status = Request.QueryString["status"].ToString();
AmzIFace.AmazonInvoice.PaperLabel pl = new AmzIFace.AmazonInvoice.PaperLabel(0, 0, amzSettings.amzPaperLabelsFile, Request.QueryString["labCode"].ToString());
string file = "barcode_" + sku + "_" + numLabels.ToString() + ".pdf";
Response.ContentType = "application/pdf";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + file);
AmzIFace.AmzonInboundShipments.MakeBarCodeFullPages(sku, descBC, status, numLabels, Response.OutputStream, amzSettings,
amzSettings.amzBarCodeWpx, amzSettings.amzBarCodeHpx, amzSettings.amzBarCodeWmm, amzSettings.amzBarCodeHmm, pl);
Response.End();
return;
}
else if (Request.QueryString["printAll"] != null && Request.QueryString["labCode"] != null && Session["printAll"] != null && Request.QueryString["status"] != null)
{
amzSettings = (AmzIFace.AmazonSettings)Session["amzSettings"];
settings = (UtilityMaietta.genSettings)Session["settings"];
string status = Request.QueryString["status"].ToString();
string shipid = Request.QueryString["printAll"].ToString();
AmzIFace.AmazonInvoice.PaperLabel pl = new AmzIFace.AmazonInvoice.PaperLabel(0, 0, amzSettings.amzPaperLabelsFile, Request.QueryString["labCode"].ToString());
List <AmzIFace.AmzonInboundShipments.FullLabel> printAll = (List <AmzIFace.AmzonInboundShipments.FullLabel>)Session["printAll"];
int forPage = pl.rows * pl.cols;
int numpages = ((printAll.Count % forPage) == 0) ? printAll.Count / forPage : (printAll.Count / forPage) + 1;
List <AmzIFace.AmzonInboundShipments.FullLabel[][]> document = new List <AmzIFace.AmzonInboundShipments.FullLabel[][]>();
AmzIFace.AmzonInboundShipments.FullLabel[][] page;
int count = 0;
for (int p = 0; p < numpages; p++)
{
if (count >= printAll.Count)
{
break;
}
page = new AmzIFace.AmzonInboundShipments.FullLabel[pl.rows][];
for (int r = 0; r < pl.rows; r++)
{
if (count >= printAll.Count)
{
break;
}
page[r] = new AmzIFace.AmzonInboundShipments.FullLabel[pl.cols];
for (int c = 0; c < pl.cols; c++)
{
if (count >= printAll.Count)
{
break;
}
page[r][c] = new AmzIFace.AmzonInboundShipments.FullLabel();
page[r][c].sku = printAll[count].sku;
page[r][c].desc = printAll[count].desc;
page[r][c].qt = printAll[count].qt;
count++;
}
}
document.Add(page);
}
/*int count = 0, pag = 0;
* int c = 1, r = 1;
* ArrayList labels = new ArrayList();
*
* //////////// ERRORE AUMENTO R E C
* while (count < printAll.Count)
* {
* labels.Add(new AmzIFace.AmazonInvoice.PaperLabel(c++, r++, amzSettings.amzPaperLabelsFile, Request.QueryString["labCode"].ToString()));
* count++;
* }
* for (int r = 0; r < pl.rows; r++)
* {
* if (count >= printAll.Count)
* break;
* for (int c = 0; c < pl.cols; c++)
* {
* if (count >= printAll.Count)
* break;
*
* labels.Add(new AmzIFace.AmazonInvoice.PaperLabel(c, r, amzSettings.amzPaperLabelsFile, Request.QueryString["labCode"].ToString()));
* count++;
* }
* }*/
string file = "barcode_" + shipid + "_" + printAll.Count.ToString() + ".pdf";
Response.ContentType = "application/pdf";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + file);
AmzIFace.AmzonInboundShipments.MakeMultiBarCodeGrid(document, Response.OutputStream, status, amzSettings, amzSettings.amzBarCodeWpx, amzSettings.amzBarCodeHpx,
amzSettings.amzBarCodeWmm, amzSettings.amzBarCodeHmm, pl);
Response.End();
return;
}
Response.Write("Sessione scaduta");
return;
}
private AmazonOrder.Order.lavInfo OpenLavorazioneFromAmz(AmazonOrder.Order order, OleDbConnection wc, OleDbConnection cnn, AmzIFace.AmazonSettings amzs, UtilityMaietta.genSettings s, string invoice)
{
string mailcl = order.buyer.emailCompratore;
LavClass.UtenteLavoro ul = new LavClass.UtenteLavoro(mailcl, amzs.AmazonMagaCode, wc, cnn, s);
LavClass.Operatore opLav;
LavClass.Macchina mc = new LavClass.Macchina(amzs.lavMacchinaDef, s.lavMacchinaFile, s);
LavClass.TipoStampa ts = new LavClass.TipoStampa(amzs.lavTipoStampaDef, s.lavTipoStampaFile);
LavClass.Obiettivo ob = new LavClass.Obiettivo(amzs.lavObiettivoDef, s.lavObiettiviFile);
//LavClass.Priorita pr = new LavClass.Priorita(amzs.lavPrioritaDef, s.lavPrioritaFile);
LavClass.Priorita pr = new LavClass.Priorita(((order.ShipmentServiceLevelCategory.ShipmentLevelIs(AmazonOrder.ShipmentLevel.ESPRESSA)) ? amzs.lavPrioritaDefExpr : amzs.lavPrioritaDefStd),
s.lavPrioritaFile);
LavClass.Operatore approvatore = new LavClass.Operatore(amzs.lavApprovatoreDef, s.lavOperatoreFile, s.lavTipoOperatoreFile);
int lavid = 0;
//double myprice;
if (ul.id == 0) // NON HO MAIL UTENTE
{
// INSERISCI SAVE UTENTE
UtilityMaietta.clienteFattura amazonRiv = new UtilityMaietta.clienteFattura(amzs.AmazonMagaCode, cnn, s);
LavClass.UtenteLavoro.SaveUtente(amazonRiv, wc, order.buyer.nomeCompratore + " c/o " + order.destinatario.nome, order.buyer.emailCompratore, order.destinatario.ToString(), order.destinatario.ToStringFormatted());
ul = new LavClass.UtenteLavoro(order.buyer.emailCompratore, amzs.AmazonMagaCode, wc, cnn, s);
}
if (ul.HasOperatorePref())
{
opLav = ul.OperatorePreferito();
}
else
{
opLav = new LavClass.Operatore(amzs.lavOperatoreDef, s.lavOperatoreFile, s.lavTipoOperatoreFile);
}
//string postit = ((order.GetSiglaVettore(cnn, amzs)) == postaSigla) ? "Spedizione con " + postaSigla : "";
// INSERISCI SAVE LAVORAZIONE
string testo = (invoice != "") ? "Lavorazione <b>" + order.canaleVendita.ToUpper() + "</b> automatica.<br /><br />" + invoice :
"Lavorazione <b>" + order.canaleVendita.ToUpper() + "</b> automatica.";
lavid = LavClass.SchedaLavoro.SaveLavoro(wc, amzs.AmazonMagaCode, ul.id, opLav.id, mc.id, ts.id, ob.id, DateTime.Now, op,
null, null, true, approvatore.id, false, testo, "", order.dataSpedizione, order.orderid, pr.id);
// ADD PRODOTTI
ArrayList distinctMaietta;
if (freeProds && Session["freeProds"] != null) /// VENGO DA RICEVUTA FREEINVOICE E CON SPUNTA CREA LAVORAZIONE
{
distinctMaietta = new ArrayList((List <AmzIFace.CodiciDist>)Session["freeProds"]);
foreach (AmzIFace.CodiciDist codD in distinctMaietta)
{
LavClass.ProdottoLavoro.SaveProdotto(lavid, codD.maietta.idprodotto, codD.qt, "", codD.totPrice / codD.qt, false, wc);
}
}
else if (order.Items != null) /// VENGO DA PANORAMICA
{
distinctMaietta = FillDistinctCodes(order.Items, aMerchant, s); //, DateTime.Today);
foreach (AmzIFace.CodiciDist codD in distinctMaietta)
{
LavClass.ProdottoLavoro.SaveProdotto(lavid, codD.maietta.idprodotto, codD.qt, "", codD.totPrice / codD.qt, false, wc);
}
}
AmazonOrder.Order.lavInfo li = new AmazonOrder.Order.lavInfo();
li.lavID = lavid;
li.rivID = amzs.AmazonMagaCode;
li.userID = ul.id;
return(li);
}
protected void btnSaveCodes_Click(object sender, EventArgs e)
{
int tabLenght = 0, z = 0;
if (Request.Form["hidRowsCount"] != null)
{
tabLenght = int.Parse(Request.Form["hidRowsCount"].ToString()) - 1;
}
string[] skuIndex = getHidIndex(tabLenght);
rowSku[] lista = new rowSku[skuIndex.Length];
int count = 0;
/// INSERIMENTO DA ORDINE AMAZON SU SKU
/// DIFFERENZIAZIONE FATTA PER LE COPIE DA #c1 RIPETUTO
if (Request.QueryString["amzOrd"] != null || Request.QueryString["amzSingleSku"] != null)
{
for (int i = 0; i < lista.Length; i++)
{
lista[i].sku = Request.Form["hidSku#" + skuIndex[i]].ToString();
if (i > 0 && lista[i].sku != lista[i - 1].sku) // CAMBIO SKU
{
count = 0;
}
lista[i].codicemaietta = (Request.Form["txCodMaga#" + RepeteRight(lista[i].sku, "#c1", count)] != null) ?
Request.Form["txCodMaga#" + RepeteRight(lista[i].sku, "#c1", count)].ToString().Trim() :
Request.Form["hidCodMaie#" + RepeteRight(lista[i].sku, "#c1", count)].ToString().Trim();
lista[i].tiporisposta = int.Parse(Request.Form["dropTpr#" + RepeteRight(lista[i].sku, "#c1", count)].ToString());
lista[i].lavorazione = (Request.Form["chkLav#" + RepeteRight(lista[i].sku, "#c1", count)] != null &&
Request.Form["chkLav#" + RepeteRight(lista[i].sku, "#c1", count)].ToString() == "on");
lista[i].qts = int.Parse(Request.Form["txQtS#" + RepeteRight(lista[i].sku, "#c1", count)].ToString());
lista[i].ismcs = (Request.Form["chkMCS#" + RepeteRight(lista[i].sku, "#c1", count)] != null &&
Request.Form["chkMCS#" + RepeteRight(lista[i].sku, "#c1", count)].ToString() == "on");
lista[i].vettoreID = (Request.Form["dropVett#" + RepeteRight(lista[i].sku, "#c1", count)] != null) ?
int.Parse(Request.Form["dropVett#" + RepeteRight(lista[i].sku, "#c1", count)].ToString()) : amzSettings.amzDefVettoreID;
count++;
}
}
/// INSERIMENTO/MODIFICA DA SINGOLO SKU
/// DIFFERENZIAZIONE DA #si + count
else if (Request.QueryString["amzSku"] != null) //TORNO IN PANORAMICA
{
lista = new rowSku[tabLenght];
string mainSku = Request.QueryString["amzSku"].ToString();
for (int i = 0; i < lista.Length; i++) // CICLO PER RIGHE INSERITE DAL PROGRAMMA #SI + i
{
lista[i].sku = mainSku;
lista[i].codicemaietta = (Request.Form["txCodMaga#" + lista[i].sku + "#si" + i.ToString()] != null) ?
Request.Form["txCodMaga#" + lista[i].sku + "#si" + i.ToString()].ToString().Trim() :
Request.Form["hidCodMaie#" + lista[i].sku + "#si" + i.ToString()].ToString().Trim();
lista[i].tiporisposta = int.Parse(Request.Form["dropTpr#" + lista[i].sku + "#si" + i.ToString()].ToString());
lista[i].lavorazione = (Request.Form["chkLav#" + lista[i].sku + "#si" + i.ToString()] != null &&
Request.Form["chkLav#" + lista[i].sku + "#si" + i.ToString()].ToString() == "on");
lista[i].qts = int.Parse(Request.Form["txQtS#" + lista[i].sku + "#si" + i.ToString()].ToString());
lista[i].ismcs = (Request.Form["chkMCS#" + lista[i].sku + "#si" + i.ToString()] != null &&
Request.Form["chkMCS#" + lista[i].sku + "#si" + i.ToString()].ToString() == "on");
lista[i].vettoreID = (Request.Form["dropVett#" + lista[i].sku + "#si" + i.ToString()] != null) ?
int.Parse(Request.Form["dropVett#" + lista[i].sku + "#si" + i.ToString()].ToString()) :
amzSettings.amzDefVettoreID;
for (z = 1; (Request.Form["txCodMaga#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)] != null); z++) // CICLO PER EVENTUALI RIGHE COPIATE #c0 z volte
{
lista[i + z].sku = mainSku;
lista[i + z].codicemaietta = Request.Form["txCodMaga#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString().Trim();
lista[i + z].tiporisposta = int.Parse(Request.Form["dropTpr#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString());
lista[i + z].lavorazione = (Request.Form["chkLav#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)] != null &&
Request.Form["chkLav#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString() == "on");
lista[i + z].qts = int.Parse(Request.Form["txQtS#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString());
lista[i + z].ismcs = (Request.Form["chkMCS#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)] != null &&
Request.Form["chkMCS#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString() == "on");
lista[i + z].vettoreID = (Request.Form["dropVett#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)] != null) ?
int.Parse(Request.Form["dropVett#" + RepeteRight(mainSku + "#si" + i.ToString(), "#c1", z)].ToString()) :
amzSettings.amzDefVettoreID;
}
i = i + z - 1;
}
}
z = 0;
foreach (rowSku l in lista)
{
if (z + 1 < lista.Length && (lista[z].sku == lista[z + 1].sku && lista[z].vettoreID != lista[z + 1].vettoreID))
{
Response.Write("Per tutti i prodotti dello stesso SKU è richiesto lo stesso vettore. Impossibile continuare.");
return;
}
z++;
}
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
wc.Open();
cnn.Open();
UtilityMaietta.infoProdotto ip;
//AmazonOrder.SKUItem[] items = new AmazonOrder.SKUItem[lista.Length];
///// CHECK validità codici
///// CONTROLLO SUI CODICI MAIETTA CORRETTI E IN LINEA
for (int i = 0; i < lista.Length; i++)
{
ip = new UtilityMaietta.infoProdotto(lista[i].codicemaietta, cnn, settings);
if (ip.codprodotto == "" || ip.codicefornitore == 0 || !ip.inlinea)
{
Response.Write("Codice maietta " + lista[i].codicemaietta + " non trovato o non in linea, impossibile salvare!");
cnn.Close();
return;
}
}
///// CERCA GLI SKU DISTINCT DA ELIMINARE (QUINDI ELIMINA x SKU con UNO O PIU' COD MAIETTA COLLEGATI)
ArrayList distItem = distinctSku(lista);
///// CLEAR DISTINCT SKU
foreach (rowSku s in distItem)
{
AmazonOrder.SKUItem.ClearSku(wc, s.sku);
}
///// COLLEGA I NUOVI SKU AI CODICI
for (int i = 0; i < lista.Length; i++)
{
AmazonOrder.SKUItem.LinkSku(wc, lista[i].sku, lista[i].codicemaietta, lista[i].tiporisposta, lista[i].lavorazione, lista[i].qts,
lista[i].ismcs, lista[i].vettoreID);
}
///////// Aggiorno items dell'ordine
if (Request.QueryString["amzOrd"] != null && Session[Request.QueryString["amzOrd"].ToString()] != null)
{
AmazonOrder.Order order = (AmazonOrder.Order)Session[Request.QueryString["amzOrd"].ToString()];
order.ReloadItemsAndSKU(order, order.orderid, amzSettings, settings, cnn, wc);
Session[order.orderid] = order;
}
/////////
cnn.Close();
wc.Close();
if (Request.QueryString["amzOrd"] != null) // VENGO DA PANORAMICA VADO IN INVOICE
{
int tpr = GetRisposta(lista, amzSettings);
Response.Redirect("amzAutoInvoice.aspx?token=" + Request.QueryString["token"].ToString() + "&amzOrd=" + Request.QueryString["amzOrd"].ToString() + "&tiporisposta=" + tpr.ToString() + MakeQueryParams());
}
else if (Request.QueryString["amzSingleSku"] != null && Request.QueryString["ship"] != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "goBack", "<script type='text/javascript' language='javascript'>window.history.go(-2);</script>");
}
else if (Request.QueryString["amzSingleSku"] != null) //TORNO IN CERCA SKU SINGOLO
{
Response.Redirect("amzfindcode.aspx?token=" + Request.QueryString["token"].ToString() + "&merchantId=" + Request.QueryString["merchantId"].ToString());
}
else if (Request.QueryString["amzSku"] != null) //TORNO IN PANORAMICA
{
Response.Redirect("amzPanoramica.aspx?token=" + Request.QueryString["token"].ToString() + "&amzSku=" + Request.QueryString["amzSku"].ToString() + MakeQueryParams());
}
}
private void FillTableCodes(AmazonOrder.Order o, OleDbConnection cnn)
{
AddFirstRow();
TableRow tr;
TableCell tc;
Label labSku;
HiddenField hidSku;
TextBox txCodMaga;
//TextBox txTipoR;
DropDownList dropTipoR;
CheckBox chklav;
TextBox txQtS;
CheckBox chkMCS;
DropDownList dropVett;
ImageButton imgB;
DataTable vettori = UtilityMaietta.Vettore.GetVettori(cnn);
ArrayList risposte = AmazonOrder.Comunicazione.GetAllRisposte(amzSettings.amzComunicazioniFile, aMerchant);
int count = 0;
foreach (AmazonOrder.OrderItem oi in o.Items)
{
if (oi.prodotti == null || oi.prodotti.Count == 0) // QUESTO ITEM HA SKU DA INSERIRE
{
tr = new TableRow();
//SKU
tc = new TableCell();
labSku = new Label();
labSku.ID = "labSku#" + oi.sellerSKU + "#si" + count.ToString();
labSku.Text = oi.sellerSKU;
hidSku = new HiddenField();
hidSku.ID = "hidSku#" + oi.sellerSKU + "#si" + count.ToString();
hidSku.Value = oi.sellerSKU;
tc.Controls.Add(labSku);
tc.Controls.Add(hidSku);
tr.Cells.Add(tc);
//CODICE MAGA
tc = new TableCell();
txCodMaga = new TextBox();
txCodMaga.ID = "txCodMaga#" + oi.sellerSKU;
txCodMaga.Text = (AmazonOrder.SKUItem.SkuExistsMaFra(cnn, oi.sellerSKU) ? oi.sellerSKU.ToUpper() : "");
tc.Controls.Add(txCodMaga);
tr.Cells.Add(tc);
//TIPO RISPOSTA
tc = new TableCell();
dropTipoR = new DropDownList();
dropTipoR.ID = "dropTpr#" + oi.sellerSKU;
dropTipoR.Width = 160;
dropTipoR.DataSource = risposte;
dropTipoR.DataTextField = "nome";
dropTipoR.DataValueField = "id";
dropTipoR.DataBind();
tc.Controls.Add(dropTipoR);
/*txTipoR = new TextBox();
* txTipoR.ID = "txTpr#" + oi.sellerSKU;
* txTipoR.Width = 30;
* tc.Controls.Add(txTipoR);*/
tr.Cells.Add(tc);
//LAVORAZIONE
tc = new TableCell();
chklav = new CheckBox();
chklav.ID = "chkLav#" + oi.sellerSKU;
tc.Controls.Add(chklav);
tr.Cells.Add(tc);
//QT SCARICARE
tc = new TableCell();
txQtS = new TextBox();
txQtS.ID = "txQtS#" + oi.sellerSKU;
txQtS.Width = 30;
tc.Controls.Add(txQtS);
tr.Cells.Add(tc);
//OFFERTA
tc = new TableCell();
chkMCS = new CheckBox();
chkMCS.ID = "chkMCS#" + oi.sellerSKU;
tc.Controls.Add(chkMCS);
tr.Cells.Add(tc);
//VETTORE
tc = new TableCell();
dropVett = new DropDownList();
dropVett.ID = "dropVett#" + oi.sellerSKU;
dropVett.DataSource = vettori;
dropVett.DataTextField = "sigla";
dropVett.DataValueField = "id";
dropVett.DataBind();
dropVett.SelectedValue = amzSettings.amzDefVettoreID.ToString();
tc.Controls.Add(dropVett);
tr.Cells.Add(tc);
// AGGIUNGI RIGA
tc = new TableCell();
imgB = new ImageButton();
imgB.ID = "add_" + oi.sellerSKU;
imgB.ImageUrl = "pics/add.png";
imgB.Width = 35;
imgB.Height = 35;
imgB.OnClientClick = "return addRow(this);";
tc.Controls.Add(imgB);
tr.Cells.Add(tc);
if ((count % 2) != 0)
{
tr.BackColor = System.Drawing.Color.LightGray;
}
tabCodes.Rows.Add(tr);
count++;
}
else
{
foreach (AmazonOrder.SKUItem si in oi.prodotti) // QUESTO ITEM E' GIA' MEMORIZZATO
{
tr = new TableRow();
//SKU
tc = new TableCell();
labSku = new Label();
labSku.ID = "labSku#" + oi.sellerSKU + "#si" + count.ToString();
labSku.Text = "@@" + si.SKU;
hidSku = new HiddenField();
hidSku.ID = "hidSku#@@" + si.SKU + "#si" + count.ToString();
hidSku.Value = "@@" + oi.sellerSKU;
tc.Controls.Add(labSku);
tc.Controls.Add(hidSku);
tr.Cells.Add(tc);
//CODICE MAGA
tc = new TableCell();
tc.Text = si.prodotto.codmaietta;
tr.Cells.Add(tc);
//TIPO RISPOSTA
tc = new TableCell();
tc.Text = si.idrisposta.ToString();
tr.Cells.Add(tc);
//LAVORAZIONE
tc = new TableCell();
chklav = new CheckBox();
chklav.ID = "chkLav#" + oi.sellerSKU;
chklav.Checked = si.lavorazione;
chklav.Enabled = false;
tc.Controls.Add(chklav);
tr.Cells.Add(tc);
//QT SCARICARE
tc = new TableCell();
tc.Text = si.qtscaricare.ToString();
tr.Cells.Add(tc);
//OFFERTA
tc = new TableCell();
chkMCS = new CheckBox();
chkMCS.ID = "chkMCS#" + oi.sellerSKU;
chkMCS.Checked = si.isMCS;
chkMCS.Enabled = false;
tc.Controls.Add(chkMCS);
tr.Cells.Add(tc);
//VETTORE
tc = new TableCell();
dropVett = new DropDownList();
dropVett.ID = "dropVett#" + oi.sellerSKU;
dropVett.DataSource = vettori;
dropVett.DataTextField = "sigla";
dropVett.DataValueField = "id";
dropVett.DataBind();
dropVett.SelectedValue = amzSettings.amzDefVettoreID.ToString();
tc.Controls.Add(dropVett);
tr.Cells.Add(tc);
if ((count % 2) != 0)
{
tr.BackColor = System.Drawing.Color.LightGray;
}
tabCodes.Rows.Add(tr);
count++;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["entry"] == null || !bool.Parse(Session["entry"].ToString()) || Request.QueryString["merchantId"] == null ||
Session["token"] == null || Request.QueryString["token"] == null ||
Session["token"].ToString() != Request.QueryString["token"].ToString() ||
Session["Utente"] == null || Session["settings"] == null ||
(Request.QueryString["amzOrd"] == null && Request.QueryString["amzSku"] == null && Request.QueryString["amzSingleSku"] == null))
{
Session.Abandon();
Response.Redirect("login.aspx?path=amzPanoramica");
}
u = (UtilityMaietta.Utente)Session["Utente"];
settings = (UtilityMaietta.genSettings)Session["settings"];
//workYear = DateTime.Today.Year;
Year = (int)Session["year"];
LavClass.MafraInit folder = LavClass.MAFRA_INIT(Server.MapPath(""));
if (folder.mafraPath == "")
{
folder.mafraPath = Server.MapPath("\\");
}
settings.ReplacePath(@folder.mafraInOut1[0], @folder.mafraInOut1[1]);
settings.ReplacePath(@folder.mafraInOut2[0], @folder.mafraInOut2[1]);
amzSettings = new AmzIFace.AmazonSettings(settings.lavAmazonSettingsFile, Year);
amzSettings.ReplacePath(@folder.mafraInOut1[0], @folder.mafraInOut1[1]);
amzSettings.ReplacePath(@folder.mafraInOut2[0], @folder.mafraInOut2[1]);
/*string folder = LavClass.MAFRA_FOLDER(Server.MapPath(""));
* settings.ReplacePath(@"G:\", @"\\10.0.0.80\c$\");
* settings.ReplacePath(@"F:\", @"\\10.0.0.2\c$\");
* amzSettings = new AmzIFace.AmazonSettings(settings.lavAmazonSettingsFile, Year);
* amzSettings.ReplacePath(@"G:\", @"\\10.0.0.80\c$\");
* amzSettings.ReplacePath(@"F:\", @"\\10.0.0.2\c$\");*/
Session["settings"] = settings;
Session["amzSettings"] = amzSettings;
Session["Utente"] = u;
aMerchant = new AmzIFace.AmazonMerchant(int.Parse(Request.QueryString["merchantId"].ToString()), amzSettings.Year, amzSettings.marketPlacesFile, amzSettings);
COUNTRY_TITLE = aMerchant.nazione;
COUNTRY = Year + " - " + aMerchant.nazione + " " + aMerchant.ImageUrlHtml(25, 40, "inherit");
if (Page.IsPostBack)
{
}
else if (Request.QueryString["amzOrd"] != null) // VENGO DA PANORAMICA VADO IN INVOICE
{
OPERAZIONE = " Inserimento da ordine";
string amzOrd = Request.QueryString["amzOrd"].ToString();
labOrderID.Text = "Ordine n#: " + amzOrd;
string errore = "";
if (Session[amzOrd] != null)
{
order = (AmazonOrder.Order)Session[Request.QueryString["amzOrd"].ToString()];
}
else
{
order = AmazonOrder.Order.ReadOrderByNumOrd(amzOrd, amzSettings, aMerchant, out errore);
}
Session[Request.QueryString["amzOrd"].ToString()] = order;
if (order == null || errore != "")
{
Response.Write("Impossibile contattare amazon, riprova più tardi!<br />Errore: " + errore);
return;
}
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
cnn.Open();
if (order.Items == null)
{
System.Threading.Thread.Sleep(1500);
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
wc.Open();
order.RequestItemsAndSKU(amzSettings, aMerchant, settings, cnn, wc);
wc.Close();
}
FillTableCodes(order, cnn);
cnn.Close();
labRedCode.Text = "";
}
else if (Request.QueryString["amzSingleSku"] != null)
{
OPERAZIONE = " Inserimento singolo";
string amzSingleSku = Request.QueryString["amzSingleSku"].ToString();
labOrderID.Text = "";
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
cnn.Open();
FillTableSingleSku(amzSingleSku, cnn);
cnn.Close();
if (amzSingleSku.Contains(" "))
{
btnSaveCodes.Enabled = false;
}
}
else if (Request.QueryString["amzSku"] != null) /// MODIFICO SKU ESISTENTE
{
OPERAZIONE = " Modifica";
string amzSku = Request.QueryString["amzSku"].ToString();
labOrderID.Text = "";
OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString);
OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection);
cnn.Open();
wc.Open();
ArrayList items = AmazonOrder.SKUItem.SkuItems(amzSku, wc, cnn, settings, amzSettings);
FillTableSKU(items, cnn);
cnn.Close();
wc.Close();
labRedCode.Text = "I codici con sfondo rosso sono già movimentati.<br />Non è possibile quindi modificare l'associazione.";
}
}
