public JsonResult loadExcelContacts()
{
List <ExcelEmail> contacts = new List <ExcelEmail>();
List <Mistakes> errores = new List <Mistakes>();
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
string extension = Path.GetExtension(file.FileName).ToLower();
string connString = "";
string[] validFileTypes = { ".xlsx" };
string path1 = string.Format("{0}/{1}", Server.MapPath("~/Content/ExcelContactsUpload"), file.FileName);
if (!Directory.Exists(path1))
{
Directory.CreateDirectory(Server.MapPath("~/Content/ExcelContactsUpload"));
}
if (validFileTypes.Contains(extension))
{
if (System.IO.File.Exists(path1))
{
System.IO.File.Delete(path1);
}
file.SaveAs(path1);
if (extension.Trim() == ".xlsx")
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path1 + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
DataTable dt = Utility.ConvertXSLXtoDataTable(path1, connString);
foreach (DataRow row in dt.Rows)
{
if (row[0].ToString() != "")
{
var contact = new ExcelEmail();
contact.name = row[0].ToString();
contact.email = row[1].ToString();
if (ValidateEmail(contact.email))
{
contacts.Add(contact);
}
}
}
}
}
}
var jsonResult = Json(contacts, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public async Task <ActionResult> EmailConfirmTheStudent(string id, string student_no)
{
ExcelEmail excelemail = new ExcelEmail();
Task.Run(async() => { await excelemail.EmailExcel(id, student_no); }).Wait();
Item item = await DocumentDBRepository <Item> .GetItemAsync(id, student_no);
if (item == null)
{
return(HttpNotFound());
}
ViewBag.Email = "Email Sent Successfully";
return(View(item));
}
