public ActionResult ReadData()
{
string filePath = @"D:\Tech Academy\TA-C-Sharp-Coding\C# Final\ExcelSourceProject\ExcelSource.xlsx";
var excelSource = new ExcelQueryFactory(filePath);
var readSource = from x in excelSource.Worksheet() select x;
using (ExcelSourceEntities db = new ExcelSourceEntities())
{
foreach (var x in readSource)
{
string firstName = x["FirstName"];
string lastName = x["LastName"];
string emailAddress = x["EmailAddress"];
var excelsource = new ExcelSource();
excelsource.FirstName = firstName;
excelsource.LastName = lastName;
excelsource.EmailAddress = emailAddress;
db.ExcelSources.Add(excelsource);
db.SaveChanges();
}
}
return(View("ReadSuccess"));
}
public ActionResult DisplayData()
{
using (ExcelSourceEntities db = new ExcelSourceEntities())
{
var userdata = db.ExcelSources.ToList();
var dataVms = new List <DataVm>();
foreach (var user in userdata)
{
var dataVm = new DataVm();
dataVm.FirstName = user.FirstName;
dataVm.LastName = user.LastName;
dataVm.EmailAddress = user.EmailAddress;
dataVms.Add(dataVm);
}
return(View(dataVms));
}
}
