public RedirectToRouteResult Index(Competitors c) { if(ModelState.IsValid) { SendMail(c); Excelfill(c); S = c.Email; return RedirectToAction("Thanks"); } else { return RedirectToAction("Index"); } }
public bool SendMail(Competitors c) { string login = "******"; string password = "******"; string fromMail = "*****@*****.**"; string subject = "Конкурс комментаторов GameShow"; var mailClient = new System.Net.Mail.SmtpClient { Host = "smtp.mailgun.org", Port = 587, EnableSsl = true, UseDefaultCredentials = false, Credentials = new System.Net.NetworkCredential(login, password) }; using( var msg = new System.Net.Mail.MailMessage(/*fromMail, c.Email, subject, content*/)) { msg.From = (new System.Net.Mail.MailAddress(fromMail)); msg.To.Add(new System.Net.Mail.MailAddress(c.Email)); msg.Subject = subject; msg.IsBodyHtml = true; var inlineLogo = new System.Net.Mail.LinkedResource(Server.MapPath("~/Resources/mailservice.jpg")); inlineLogo.ContentId = Guid.NewGuid().ToString(); string body3 = string.Format( @"<div class=""b-message-body__content"" data-lang=""1""> <div dir=""ltr""> Здравствуй, {0} {1}! <br><br> Спасибо за участие в нашем конкурсе! <div> <br> </div> <div> <span style=""font-size:12.8px;"">Мы верим, что именно ты станешь новой звездой первого кибер-спортивного канала в СНГ.</span> <br style=""font-size:12.8px;""> <br style=""font-size:12.8px;""> <span style=""font-size:12.8px;""> Мы обязательно рассмотрим твою заявку и сообщим о результатах по почте {2}! </span><br style=""font-size:12.8px;""> <br style=""font-size:12.8px;""> <div style=""font-size:12.8px;""> С уважением, <font color=""#3d85c6"">Game</font> <font color=""#cc0000"">Show </font><font color=""#3d85c6"">Media Holding!</font> </div> </div> <div> <font color=""#3d85c6""> <br> </font> </div> <div> <table style=""font-size:12.8px;border:none;border-collapse:collapse;""> <tbody> <tr style=""height:0px;""> <td style=""border:0px solid rgb(0,0,0);vertical-align:top;padding:7px;""> <div style=""line-height:1.44;margin-top:0pt;margin-bottom:0pt;""> <img src=""cid:{3}""> </div> <br> </td> </tr> </tbody> </table> </div> </div> </div>", c.Name, c.Surname, c.Email, inlineLogo.ContentId); var view = System.Net.Mail.AlternateView.CreateAlternateViewFromString(body3, null, "text/html"); view.LinkedResources.Add(inlineLogo); msg.AlternateViews.Add(view); try { mailClient.Send(msg); return true; } catch (Exception) { // TODO: Handle the exception return false; } } }
public bool Excelfill(Competitors compet) { string path = @"\\51.254.175.215\c$\inetpub\ftproot\Star\GameShowContest\Contest.xls"; Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet st = null; if (System.IO.File.Exists(path)) { wb = xl.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); st = wb.Worksheets[1]; } else { wb = xl.Workbooks.Add(System.Reflection.Missing.Value); wb.SaveAs(path, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, null, null, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null); st = wb.Worksheets[1]; st.Cells[1, 1] = "Номер"; st.Cells[1, 2] = "Имя"; st.Cells[1, 3] = "Фамилия"; st.Cells[1, 4] = "Email"; st.Cells[1, 5] = "Ссылка на работу"; st.Cells[1, 6] = "Ссылка на видео о себе"; } Microsoft.Office.Interop.Excel.Range range = st.UsedRange; int lastRow = range.Rows.Count + 1; st.Cells[lastRow, 1] = lastRow - 1; st.Cells[lastRow, 2] = compet.Name; st.Cells[lastRow, 3] = compet.Surname; st.Cells[lastRow, 4] = compet.Email; st.Cells[lastRow, 5] = compet.FirstLink; st.Cells[lastRow, 6] = compet.SecondLink; st.Columns.AutoFit(); xl.DisplayAlerts = false; wb.Close(true, path); xl.Quit(); return true; }