Esempio n. 1
0
        static void Main(string[] args)
        {
            Config cfg = null;

            try { cfg = Config.LoadFromFile(ConfigFile); }
            catch
            {
                if (cfg == null)
                {
                    cfg = new Config();
                }
                cfg.SaveToFile(ConfigFile);

                Console.WriteLine("Require config");
                return;
            }

            SmtpClient smtp = new SmtpClient(cfg.SmtpServer, cfg.SmtpPort)
            {
                EnableSsl   = cfg.SmtpEnableSsl,
                Credentials = new NetworkCredential(cfg.SmtpUser, cfg.SmtpPassword)
            };

            List <int> sended = new List <int>(), errorSend = new List <int>();

            if (File.Exists(DoneFile))
            {
                sended = JsonConvert.DeserializeObject <List <int> >(File.ReadAllText("sended.json"));
                if (sended == null)
                {
                    sended = new List <int>();
                }
            }

            // Connect
            using (MySqlConnection con = new MySqlConnection(new MySqlConnectionStringBuilder()
            {
                Password = cfg.DatabasePassword,
                Database = cfg.Database,
                UserID = cfg.DatabaseUserID,
                Server = cfg.DatabaseServer,
                Port = cfg.DatabasePort
            }
                                                             .ToString()))
            {
                con.Open();

                using (MySqlCommand com = con.CreateCommand())
                {
                    com.Parameters.Clear();

                    // Fetch users & scores
                    using (DataTable dt = SqlHelper.SelectDataTable(com, "SELECT user_id,name,email,user_points from vteams order by user_points DESC,name ASC"))
                        using (DataTable dtscores = SqlHelper.SelectDataTable(com, "SELECT user_id, ts, points from vscores"))
                        {
                            int     maxScore;
                            Score[] globalScore = Chart3.Preload(dtscores, out maxScore);
                            Bitmap  bmp_banner  = Res.report;

                            foreach (DataRow dr in dt.Rows)
                            {
                                string email = dr["email"].ToString();
                                if (string.IsNullOrEmpty(email))
                                {
                                    continue;
                                }

                                int userId = Convert.ToInt32(dr["user_id"]);
                                if (sended.Contains(userId))
                                {
                                    continue;
                                }

                                // Get chart 1

                                string url1 = Chart1.GetChart(userId, com);
                                if (string.IsNullOrEmpty(url1))
                                {
                                    continue;
                                }

                                // Get chart 2

                                string url2 = Chart2.GetChart(userId, com);
                                if (string.IsNullOrEmpty(url2))
                                {
                                    continue;
                                }

                                string url3 = Chart3.GetChart(userId, dr["name"].ToString(), com, dtscores, globalScore, maxScore);
                                if (string.IsNullOrEmpty(url3))
                                {
                                    continue;
                                }

                                // Generate image
                                using (WebClient client = new WebClient())
                                {
                                    byte[] d1 = client.DownloadData(url1);
                                    byte[] d2 = client.DownloadData(url2);
                                    byte[] d3 = client.DownloadData(url3);

                                    if (d1 == null || d2 == null || d3 == null)
                                    {
                                        errorSend.Add(userId);
                                        continue;
                                    }

                                    using (MemoryStream ms1 = new MemoryStream(d1))
                                        using (MemoryStream ms2 = new MemoryStream(d2))
                                            using (MemoryStream ms3 = new MemoryStream(d3))
                                                using (Image bmp1 = Image.FromStream(ms1))
                                                    using (Image bmp2 = Image.FromStream(ms2))
                                                        using (Image bmp3 = Image.FromStream(ms3))
                                                        {
                                                            Bitmap bmpnew = new Bitmap(bmp_banner.Width, bmp_banner.Height);

                                                            using (Graphics g = Graphics.FromImage(bmpnew))
                                                            {
                                                                g.DrawImageUnscaled(bmp_banner, 0, 0);

                                                                using (Font f1 = new Font("Arial", 19, FontStyle.Bold))
                                                                    using (Font f2 = new Font("Arial", 21, FontStyle.Bold))
                                                                        using (Brush br = new SolidBrush(Color.White))
                                                                            //using (Brush br = new SolidBrush(Color.FromArgb(174, 34, 34)))
                                                                            using (StringFormat sf = new StringFormat()
                                                                            {
                                                                                Alignment = StringAlignment.Center,
                                                                                LineAlignment = StringAlignment.Center
                                                                            })
                                                                            {
                                                                                int puesto = dt.Rows.IndexOf(dr) + 1;

                                                                                g.DrawString(dr["name"].ToString(), f1, br, new Rectangle(0, 265, 350, 80), sf);
                                                                                g.DrawString(dr["user_points"].ToString(), f2, br, new Rectangle(550, 278, 170, 80), sf);

                                                                                //g.FillRectangle(br, new Rectangle(720, 265, 200, 80));
                                                                                g.DrawString((puesto == 1 ? "WINNER!" : puesto.ToString() + "º"), f2, br, new Rectangle(710, 278, 195, 80), sf);
                                                                            }

                                                                g.DrawImageUnscaled(bmp1, 64, 447);
                                                                g.DrawImageUnscaled(bmp2, 64, 700);
                                                                g.DrawImageUnscaled(bmp3, 64, 1023);
                                                            }

                                                            using (MemoryStream ms = new MemoryStream())
                                                            {
                                                                bmpnew.Save(ms, ImageFormat.Png);

                                                                //File.WriteAllBytes("D:\\report-test.png", ms.ToArray());

                                                                try
                                                                {
                                                                    MailMessage msg = new MailMessage()
                                                                    {
                                                                        From       = new MailAddress(cfg.SmtpUser, "No reply"),
                                                                        Body       = cfg.MailBody,
                                                                        Subject    = cfg.MailSubject,
                                                                        IsBodyHtml = false,
                                                                    };

                                                                    //email = "*****@*****.**";
                                                                    msg.To.Add(email);
                                                                    //msg.Bcc.Add("*****@*****.**");

                                                                    ms.Seek(0, SeekOrigin.Begin);
                                                                    msg.Attachments.Add(new Attachment(ms, "report.png", "image/png"));

                                                                    smtp.Send(msg);
                                                                    sended.Add(userId);
                                                                }
                                                                catch (Exception e)
                                                                {
                                                                    errorSend.Add(userId);
                                                                }
                                                            }
                                                        }
                                }
                            }
                        }
                }
            }

            File.WriteAllText(DoneFile, JsonConvert.SerializeObject(sended));
            if (errorSend.Count > 0)
            {
                Console.WriteLine(string.Join(",", errorSend));
            }

            Console.WriteLine("END PROCESS, PRESS ENTER TO CONTINUE");
            Console.ReadLine();
        }