public void storeCSV(HttpPostedFileBase csvFile, List <Ad> list) { string path = null; var fileName = Path.GetFileName(csvFile.FileName); path = AppDomain.CurrentDomain.BaseDirectory + fileName; csvFile.SaveAs(path); FileStream fs = new FileStream(path, FileMode.Open); StreamReader sr = new StreamReader(fs); //ignore first line concerns headers string headers = sr.ReadLine(); //store each line string s = sr.ReadLine(); //if not at the end of file while (s != null) { string[] ligne = s.Split(';'); //skip irrelevant data while (String.IsNullOrWhiteSpace(ligne[6]) && String.IsNullOrWhiteSpace(ligne[7])) { s = sr.ReadLine(); ligne = s.Split(';'); } if (String.IsNullOrWhiteSpace(ligne[6])) { ligne[6] = "0"; } if (String.IsNullOrWhiteSpace(ligne[7])) { ligne[7] = "0"; } //create a relevant ad Ad a = new Ad() { Year = Int32.Parse(ligne[0]), Market = ligne[1], Segment = ligne[2], Brand = ligne[3], Copy_Duration = Int32.Parse(ligne[4]), Copy_Name = ligne[5], Score_1 = Int32.Parse(ligne[6]), Score_2 = Int32.Parse(ligne[7].Replace('%', ' ')) }; list.Add(a); s = sr.ReadLine(); } //close the file sr.Close(); fs.Close(); //adding of the ads in the database using (var context = new AdModel()) { foreach (Ad ad in list) { context.Ads.Add(ad); } context.SaveChanges(); } }
public void storeListInDb(List <Ad> list) { //adding of the ads in the database using (AdModel context = new AdModel()) { foreach (Ad ad in list) { context.Ads.Add(ad); } context.SaveChanges(); } }