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["operatore"] == null || Session["Utente"] == null || Session["settings"] == null || Request.QueryString["amzOrd"] == null) { Session.Abandon(); Response.Redirect("login.aspx?path=amzPanoramica"); } u = (UtilityMaietta.Utente)Session["Utente"]; settings = (UtilityMaietta.genSettings)Session["settings"]; op = (LavClass.Operatore)Session["operatore"]; 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("")); * if (folder == "") * 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; aMerchant = new AmzIFace.AmazonMerchant(1, amzSettings.Year, amzSettings.marketPlacesFile, amzSettings); freeProds = Request.QueryString["freeProds"] != null && int.Parse(Request.QueryString["freeProds"].ToString()) > 0; OleDbConnection cnn = new OleDbConnection(settings.OleDbConnString); OleDbConnection wc = new OleDbConnection(settings.lavOleDbConnection); wc.Open(); cnn.Open(); string errore = ""; AmazonOrder.Order o; if (!CheckNomeLavoro(wc, Request.QueryString["amzOrd"].ToString(), amzSettings.AmazonMagaCode)) // ENTRA SE LAVORAZIONE NON ESISTENTE { if (Session[Request.QueryString["amzOrd"].ToString()] != null) { o = (AmazonOrder.Order)Session[Request.QueryString["amzOrd"].ToString()]; } else { o = AmazonOrder.Order.ReadOrderByNumOrd(Request.QueryString["amzOrd"].ToString(), amzSettings, aMerchant, out errore); } if (o == null || errore != "") { Response.Write("Impossibile contattare amazon, riprova più tardi!<br />Errore: " + errore); cnn.Close(); wc.Close(); return; } string invnumb = (Request.QueryString["invnumb"] != null && Request.QueryString["invnumb"].ToString() != "") ? "Ricevuta nr.:@ " + Request.QueryString["invnumb"].ToString() + " @": ""; if (o.Items == null) { o.RequestItemsAndSKU(amzSettings, aMerchant, settings, cnn, wc); } AmazonOrder.Order.lavInfo info = OpenLavorazioneFromAmz(o, wc, cnn, amzSettings, settings, invnumb); InsertPrimoStorico(info.lavID, wc, op, settings); LavClass.SchedaLavoro.MakeFolder(settings, info.rivID, info.lavID, info.userID); } wc.Close(); cnn.Close(); Response.Redirect("amzPanoramica.aspx?token=" + Request.QueryString["token"].ToString() + "&amzOrd=" + Request.QueryString["amzOrd"].ToString() + MakeQueryParams()); }
protected void LavGrid_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.Cells.Count > idCol) { e.Row.Cells[clienteFID - 3].Visible = false; e.Row.Cells[operCol].Visible = false; e.Row.Cells[usidCol].Visible = false; e.Row.Cells[ordCol].Visible = false; e.Row.Cells[idStatoCol].Visible = false; //e.Row.Cells[opDispCol].Visible = false; } if (e.Row.RowIndex == -1) { return; } AmazonOrder.Order.lavInfo idlav = new AmazonOrder.Order.lavInfo(); idlav.lavID = int.Parse(e.Row.Cells[idCol].Text); idlav.rivID = int.Parse(e.Row.Cells[rivcodCol].Text); idlav.userID = int.Parse(e.Row.Cells[clienteFID - 3].Text); e.Row.Cells[obCol].Text = LavClass.Obiettivo.GetFromFile(obFile, "obiettivo", "id", int.Parse(e.Row.Cells[obCol].Text)).nome; e.Row.Cells[obCol].Font.Bold = true; LavClass.Priorita pr = LavClass.Priorita.GetFromFile(prFile, "npriorita", "id", int.Parse(e.Row.Cells[prCol].Text)); e.Row.Cells[prCol].Text = pr.nome; e.Row.Cells[prCol].Font.Bold = true; e.Row.Cells[prCol].BackColor = pr.colore; string allegati = ""; if (LavClass.SchedaLavoro.HasEmptyAttach(idlav.lavID, idlav.rivID, idlav.userID, settings)) { allegati = "<br /><font color='black' size='2px'><b>senza allegato</b></font>"; } else if (!LavClass.SchedaLavoro.HasAllegati(idlav.lavID, idlav.rivID, idlav.userID, settings)) { allegati = "<br /><font color='red' size='2px'><b>nessun allegato</b></font>"; } e.Row.Cells[statoCol].Text = "<b>" + e.Row.Cells[statoCol].Text.Replace("#", "</b><br /><font size='1'>") + "</font>" + allegati; e.Row.Cells[userCol].Font.Size = 9; LavClass.Operatore userRow = LavClass.Operatore.GetFromFile(operFile, "operatore", "id", int.Parse(e.Row.Cells[userCol].Text), tipoOpFile, "tipo", "id"); LavClass.Operatore operRow = LavClass.Operatore.GetFromFile(operFile, "operatore", "id", int.Parse(e.Row.Cells[operCol].Text), tipoOpFile, "tipo", "id"); e.Row.Cells[userCol].Text = "<b>" + userRow.ToString() + "</b><br />(" + operRow.ToString() + ")"; e.Row.BackColor = System.Drawing.ColorTranslator.FromHtml(e.Row.Cells[usidCol].Text); //if (checkCookie(int.Parse(e.Row.Cells[idCol].Text), op.id, settings.lavCookieFile).ToLower() != LavClass.CookieLav.NormalizeCookie(e.Row.Cells[statoCol].Text)) if (checkCookie(int.Parse(e.Row.Cells[idCol].Text), op.id, cookieX).ToLower() != LavClass.CookieLav.NormalizeCookie(e.Row.Cells[statoCol].Text)) { e.Row.Cells[blinkCol].Text = "<img src='pics/star-blink.gif' width='30px' height='30px' />"; } else { e.Row.Cells[blinkCol].Text = ""; } e.Row.Cells[isNoteCol].Text = (HttpUtility.HtmlDecode(e.Row.Cells[isNoteCol].Text).Trim() != "") ? "<img src='pics/postit.png' width='30px' height='30px' title='" + HttpUtility.HtmlDecode(e.Row.Cells[isNoteCol].Text).Trim() + "' />" : ""; string idvett; e.Row.Cells[isVettoreCol].Text = (idvett = HttpUtility.HtmlDecode(e.Row.Cells[isVettoreCol].Text).Trim()) != "0" && File.Exists(Server.MapPath("pics/vettori/" + idvett + ".png")) ? "<img src='pics/vettori/" + idvett + ".png' width='30px' height='30px' />" : ""; //title='" + HttpUtility.HtmlDecode(e.Row.Cells[isVettoreCol].Text).Trim() + "' />" : ""; e.Row.Cells[nomeLavCol].Font.Bold = true; e.Row.Cells[nomeLavCol].Font.Size = 12; Label lbId = new Label(); lbId.Text = int.Parse(e.Row.Cells[idCol].Text).ToString().PadLeft(5, '0'); lbId.ID = "lab_" + e.Row.Cells[idCol].Text; lbId.Width = 45; lbId.Font.Size = 12; lbId.Font.Bold = true; e.Row.Cells[idCol].Controls.Add(lbId); if (e.Row.Cells[linkCol].Text != "0") { e.Row.Cells[linkCol].Text = "<a href='lavDettaglio.aspx?id=" + e.Row.Cells[idCol].Text + "&token=" + Session["token"].ToString() + "&merchantId=" + Request.QueryString["merchantId"].ToString() + "' target='_self'><img src='pics/info.png' width='30px' height='30px' /></a>"; } else { e.Row.Cells[linkCol].Text = ""; } e.Row.Cells[inserCol].Text = "<b>" + e.Row.Cells[inserCol].Text.Replace(" ", "</b><br />"); e.Row.Cells[inserCol].Font.Size = 9; if (DateTime.Parse(e.Row.Cells[consCol].Text) < DateTime.Today) { e.Row.Cells[consCol].BackColor = System.Drawing.Color.Red; e.Row.Cells[consCol].Style.Add("text-decoration", "blink"); e.Row.Cells[consCol].Font.Bold = true; } Button b = new Button(); e.Row.Cells[rdbCol].Controls.Add(b); b.ID = "btn_" + e.Row.Cells[idCol].Text; b.Click += b_Click; b.Text = "*"; b.OnClientClick = "btnVisible(" + idlav.lavID + ");scrollBottom();"; AsyncPostBackTrigger trigger = new AsyncPostBackTrigger(); trigger.ControlID = b.UniqueID; trigger.EventName = "Click"; updPan1.Triggers.Add(trigger); }
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); }