public void guardarArchivo(string ubicacion)
{
try
{
CustomersDataContext db = new CustomersDataContext();
var cliente = from c in db.Customers
select c;
StreamWriter writer = new StreamWriter(ubicacion);
StringBuilder buffer = new StringBuilder();
foreach (var c in cliente)
{
buffer.Append(c.CustomerID + "\t" + c.CompanyName + "\t" + c.ContactName + "\t" + c.ContactTitle + "\t" + c.Address + "\t" + c.City + "\t" + c.Region + "\t" + c.PostalCode + "\t" + c.Country + "\t" + c.Phone + "\t" + c.Fax);
buffer.Append("\n");
}
writer.Write(buffer.ToString());
writer.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void leerArchivo(string ubicacion)
{
try
{
CustomersDataContext db = new CustomersDataContext();
StreamReader reader = new StreamReader(ubicacion);
string linea = reader.ReadLine();
while (linea != null)
{
string[] columnas = linea.Split('\t');
Customer cliente = new Customer();
cliente.CustomerID = "Z" + columnas[0].Remove(0, 1);
cliente.CompanyName = columnas[1];
cliente.ContactName = columnas[2];
cliente.ContactTitle = columnas[3];
cliente.Address = columnas[4];
cliente.City = columnas[5];
cliente.Region = columnas[6];
cliente.PostalCode = columnas[7];
cliente.Country = columnas[8];
cliente.Phone = columnas[9];
cliente.Fax = columnas[10];
db.Customers.InsertOnSubmit(cliente);
db.SubmitChanges();
linea = reader.ReadLine();
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}