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