public void Seed()
{
try
{
for (int i = 0; i < companyNames.Length; i++)
{
var companyDetails = SplitValue(companyNames[i]);
var company = new Company
{
Id = int.Parse(companyDetails[0]),
Name = companyDetails[1],
Address = companyDetails[2],
Website = companyDetails[3],
Phone_Number = companyDetails[4]
};
_ctx.Companies.Add(company);
_ctx.SaveChanges();
}
for (int j = 0; j < employeeNames.Length; j++)
{
var employeeDetails = SplitValue(employeeNames[j]);
//var employee = new Employee
//{
// Id = int.Parse(employeeDetails[0]),
// First_Name = employeeDetails[1],
// Last_Name = employeeDetails[2],
// Address = employeeDetails[3],
// Phone_Number = employeeDetails[4],
// Salary = employeeDetails[5],
// Email = employeeDetails[6],
// Company_Id = employeeDetails[7]
//};
//_ctx.Employees.Add(employee);
_ctx.SaveChanges();
}
}
catch (Exception ex)
{
string message = ex.ToString();
throw ex;
}
}
public bool SaveAll()
{
return(_ctx.SaveChanges() > 0);
//return true;
}