private void ContactForm_Load(object sender, EventArgs e)
{
allData.Clear();
using (CustomerDataModel db = new CustomerDataModel())
{
DbSet <Customer> customers = db.Customers;
foreach (Customer customer in customers)
{
allData.Add(maxIndex, customer);
maxIndex++;
}
}
UpdateData(currentIndex);
}
private void buttonImport_Click(object sender, EventArgs e)
{
String file = textImportFile.Text;
using (TextFieldParser parser = new TextFieldParser(file))
{
bool removeHeader = false;
parser.Delimiters = new string[] { "," };
while (true)
{
string[] parts = parser.ReadFields();
if (parts == null)
{
break;
}
// removeHeader removes the header in CSV file and displays only data in FORM (Row1)
if (removeHeader)
{
using (CustomerDataModel db = new CustomerDataModel())
{
DbSet <Customer> customers = db.Customers;
Customer cust = new Customer();
cust.FirstName = parts[0];
cust.LastName = parts[1];
cust.StreetNumber = parts[2];
cust.Address = parts[3];
cust.City = parts[4];
cust.Province = parts[5];
cust.Country = parts[6];
cust.PostalCode = parts[7];
cust.PhoneNumber = parts[8];
cust.EmailAddress = parts[9];
// this saves it in the DB to be saved when Save is called
customers.Add(cust);
db.SaveChanges();
allData.Add(maxIndex, cust);
maxIndex++;
}
}
removeHeader = true;
}
}
UpdateData(currentIndex);
}