public List <Customers> GetAllCustomers()
 {
     try
     {
         using (var context = new AssessmentDBContext())
         {
             var customers = context.Customers.ToList();
             return(customers);
         }
     }
     catch (Exception ex)
     {
         LogFile(ex.GetType().ToString(), "GetAllCustomers", "DataRepository.cs", ex.InnerException.Message.ToString());
         return(null);
     }
 }
 public void AddCustomer(List <Customers> customers)
 {
     try
     {
         using (var context = new AssessmentDBContext())
         {
             foreach (Customers customer in customers)
             {
                 context.Customers.Add(customer);
                 context.SaveChanges();
             }
         }
     }
     catch (Exception ex)
     {
         LogFile(ex.GetType().ToString(), "AddCustomer", "DataRepository.cs", ex.InnerException.Message.ToString());
         Console.WriteLine(ex.InnerException.Message);
     }
 }