protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public void migrateUsersToJson()
{
UsersManagerContext db = new UsersManagerContext();
using (StreamWriter sw = new StreamWriter(HttpContext.Current.Server.MapPath("~/App_Data/Users.json")))
{
List <User> users = new List <User>();
foreach (User user in db.Users)
{
User u = new User();
u.Copy(user);
users.Add(u);
}
sw.WriteLine(JsonConvert.SerializeObject(users));
}
db.Dispose();
}
public void migrateCoutriesDataToDataBase()
{
UsersManagerContext db = new UsersManagerContext();
Country country = db.Countries.FirstOrDefault();
string path = HttpContext.Current.Server.MapPath("~/App_Data/Countries.txt");
if (country == null)
{
StreamReader sr = new StreamReader(HttpContext.Current.Server.MapPath("~/App_Data/Countries.txt"));
while (!sr.EndOfStream)
{
string line = sr.ReadLine();
string[] tokens = line.Split(';');
Country newCountry = new Country();
newCountry.Name = tokens[0];
db.Countries.Add(newCountry);
db.SaveChanges();
}
sr.Dispose();
}
db.Dispose();
}