public List <MLivre> getByTitle(string title, bool lazy = false) { var result = new List <MLivre>(); using (var ctx = new modelEntities()) { title = title.Replace(" ", "%"); //todo : modifier if (!lazy) { var livres = ctx.Livre.Where(x => SqlMethods.Like(x.titre, title)); if (livres.Count() != 0) { foreach (var item in livres) { result.Add(Mapping(item)); } } else { return(data.callApiTitle(title)); } } else { return(data.callApiTitle(title)); } } return(result); }
public void InsertBookFile(string filename) { string line; using (var ctx = new modelEntities()) { ctx.Database.Connection.Open(); var file = new StreamReader(filename); while ((line = file.ReadLine()) != null) { if (!line.Contains("id")) { var data = line.Split(';'); if (data.Length > 1 && !String.IsNullOrEmpty(data[19])) { var item = new Livre() { titre = data[3].Split('[')[0], auteur = data[14], genre = data[18], isbn = data[19] }; ctx.Livre.Add(item); ctx.SaveChanges(); } } } } }
public MBoite getBoxById(int idbox) { using (var ctx = new modelEntities()) { var box = ctx.Boite.FirstOrDefault(x => x.id_boite == idbox); if (box != null) { return(Mapping(box)); } return(null); } }
public MLivre callApiISBN(string isbn) { using (var ctx = new modelEntities()) { var json = callAPI(URL_BASE + API_KEY + BOOK_REQUEST + isbn); var data = json["data"].Children(); var livre = parseBook(data.First()); ctx.Livre.Add(DLivre.Mapping(livre)); ctx.SaveChanges(); return(livre); } }
public List <MLivre> getBooks() { var result = new List <MLivre>(); using (var ctx = new modelEntities()) { foreach (var item in ctx.Livre.ToList()) { result.Add(Mapping(item)); } } return(result); }
public List <MBoite> getBoxFromcity(string city) { var result = new List <MBoite>(); using (var ctx = new modelEntities()) { foreach (var box in ctx.Boite.Where(x => x.ville == city).ToList()) { result.Add(Mapping(box)); } } return(result); }
public MLivre getByISBN(string isbn) { using (var ctx = new modelEntities()) { var livre = ctx.Livre.FirstOrDefault(x => x.isbn == isbn); if (livre != null) { return(Mapping(livre)); } else { return(data.callApiISBN(isbn)); } } }
public List <MLivre> getBooksFromBox(int idBox) { var result = new List <MLivre>(); using (var ctx = new modelEntities()) { var listLivre = ctx.Boite_Livre.Where(x => x.id_boite == idBox).ToList(); foreach (var item in listLivre) { var livre = ctx.Livre.FirstOrDefault(y => y.id_livre == item.id_livre); result.Add(Mapping(livre)); } } return(result); }
public List <MBoite> getBoxFromLocalisation(float longitude, float latitude) { var result = new List <MBoite>(); using (var ctx = new modelEntities()) { foreach (var box in ctx.Boite.ToList()) { if (Distance(latitude, longitude, (float)box.latitude, (float)box.longitude) < 10) { result.Add(Mapping(box)); } } } return(result); }
public int addBook(MLivre livre) { using (var ctx = new modelEntities()) { ctx.Livre.Add(new Livre() { titre = livre.Title, auteur = livre.Author, isbn = livre.isbn13, description = livre.Summary, genre = livre.Genre, url_image = livre.UrlImage }); return(ctx.SaveChanges()); } return(-1); }
public List <Provincie> GetProvincie() { List <Provincie> listProvincie = new List <Provincie>(); try { using (var entities = new modelEntities()) { listProvincie = (from a in entities.Provincie orderby a.Provincia ascending select a).ToList(); } } catch (Exception e) { string errore = e.ToString(); return(null); } return(listProvincie); }
public List <Comuni> GetComuni(string sigla) { List <Comuni> listComune = new List <Comuni>(); try { using (var entities = new modelEntities()) { listComune = (from a in entities.Comuni where a.Provincia == sigla orderby a.Comune ascending select a).ToList(); } } catch (Exception e) { string errore = e.ToString(); return(null); } return(listComune); }
public List <MLivre> callApiTitle(string title) { var result = new List <MLivre>(); using (var ctx = new modelEntities()) { title = title.Replace(" ", "+"); var json = callAPI(URL_BASE + API_KEY + BOOKS_TITLE_REQUEST + title); var data = json["data"].Children().ToList(); foreach (var item in data) { var livre = parseBook(item); if (ctx.Livre.FirstOrDefault(x => x.isbn == livre.isbn13) != null) { ctx.Livre.Add(DLivre.Mapping(livre)); ctx.SaveChanges(); } result.Add(livre); } } return(result); }
public void InsertBoxFile(string filename) { string line; using (var ctx = new modelEntities()) { ctx.Database.Connection.Open(); var file = new StreamReader(filename); while ((line = file.ReadLine()) != null) { if (!line.Contains("Code")) { var data = line.Split(';'); if (data.Length > 1) { var item = new Boite() { adresse = data[0], code_postal = data[1], ville = data[2], remarque = data[4] }; if (!String.IsNullOrEmpty(data[3]) && data[3] != ",") { var coordonate = data[3].Split(','); item.latitude = decimal.Parse(coordonate[0].Replace('.', ',')); item.longitude = decimal.Parse(coordonate[1].Replace('.', ',')); } ctx.Boite.Add(item); ctx.SaveChanges(); } } } }; }