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