public static void getcsmdata(string isbn) { //create new TitleIsbn13 to pass to getscsmdata List<TitleIsbn13> ti13s = new List<TitleIsbn13>(); TitleIsbn13 ti13 = new TitleIsbn13(); ti13.isbn13 = isbn; bool exists = false; using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<CommonSenseMedia> csms = new List<CommonSenseMedia>(from c in lr.CommonSenseMedias where c.Isbn13 == isbn select c); if (csms.Count > 0) { // get title from LexileTitles LexileTitle lex = (from l in lr.LexileTitles where l.Isbn13 == isbn select l).First(); ti13.title = lex.Title; exists = true; } } if (exists) { ti13s.Add(ti13); getcsmdata(ti13s); } }
public static void loadbndata(bndata bndata) { // receive bndata, load to database using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<BarnesAndNoble> existing = new List<BarnesAndNoble>(from b in lr.BarnesAndNobles where b.Isbn13 == bndata.isbn13 select b); if (existing.Count == 0) { // create new BarnesAndNoble BarnesAndNoble bn = new BarnesAndNoble(); bn.Isbn13 = bndata.isbn13; bn.AgeHigh = bndata.agehigh; bn.AgeLow = bndata.agelow; bn.Rating = bndata.rating; lr.BarnesAndNobles.Add(bn); lr.SaveChanges(); } else { // update fields on existing BarnesAndNoble existing[0].AgeHigh = bndata.agehigh; existing[0].AgeLow = bndata.agelow; existing[0].Rating = bndata.rating; lr.SaveChanges(); } } }
public static void loadschdata(schdata schdata) { // receive schdata, load to database using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<Scholastic> existing = new List<Scholastic>(from s in lr.Scholastics where s.Isbn13 == schdata.isbn13 select s); if (existing.Count == 0) { // create new BarnesAndNoble Scholastic sch = new Scholastic(); sch.Isbn13 = schdata.isbn13; sch.InterestLowGrade = schdata.interestlowgrade; sch.InterestHighGrade = schdata.interesthighgrade; sch.GradeEquiv = schdata.gradeequiv; sch.DRA = schdata.dra; sch.GuidedReading = schdata.guidedreading; // genre TBD lr.Scholastics.Add(sch); lr.SaveChanges(); } else { // update fields on existing BarnesAndNoble existing[0].InterestLowGrade = schdata.interestlowgrade; existing[0].InterestHighGrade = schdata.interesthighgrade; existing[0].GradeEquiv = schdata.gradeequiv; existing[0].DRA = schdata.dra; existing[0].GuidedReading = schdata.guidedreading; lr.SaveChanges(); } } }
public static string loadschdata(ScholasticDto schdata) { string msg = "(Unable to load to local db)"; // receive schdata, load to database UTF8Encoding enc = new System.Text.UTF8Encoding(); byte[] bs = new byte[1]{(byte)schdata.ScholasticGradeHigher}; try { using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<Scholastic> existing = new List<Scholastic>(from s in lr.Scholastics where s.Isbn13 == schdata.Isbn13 select s); if (existing.Count == 0) { // create new BarnesAndNoble Scholastic sch = new Scholastic(); sch.Isbn13 = schdata.Isbn13; sch.InterestLowGrade = schdata.ScholasticGradeLower; sch.InterestHighGrade = enc.GetString(bs); sch.GradeEquiv = (decimal)schdata.ScholasticGrade; sch.DRA = schdata.Dra; sch.GuidedReading = schdata.GuidedReading; // genre TBD lr.Scholastics.Add(sch); lr.SaveChanges(); msg = "(Loaded new SCH to DB)"; } else { // update fields on existing BarnesAndNoble existing[0].InterestLowGrade = schdata.ScholasticGradeLower; existing[0].InterestHighGrade = enc.GetString(bs); existing[0].GradeEquiv = (decimal)schdata.ScholasticGrade; existing[0].DRA = schdata.Dra; existing[0].GuidedReading = schdata.GuidedReading; lr.SaveChanges(); msg = "(Updated existing SCH in DB)"; } } } catch { } return msg; }
public static string loadcsmdata(csmdata csmdata) { string msg = "(DB LOADING ERROR)"; // receive bndata, load to database try { using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<CommonSenseMedia> existing = new List<CommonSenseMedia>(from c in lr.CommonSenseMedias where c.Isbn13 == csmdata.isbn13 select c); if (existing.Count == 0) { // create new BarnesAndNoble CommonSenseMedia csm = new CommonSenseMedia(); csm.Isbn13 = csmdata.isbn13; csm.url = csmdata.url; csm.notforkids = csmdata.notforkids; csm.offage = csmdata.offage; csm.onage = csmdata.onage; csm.review = csmdata.review; csm.parentreview = csmdata.parentreview; csm.kidreview = csmdata.kidreview; csm.genre = csmdata.genre; lr.CommonSenseMedias.Add(csm); lr.SaveChanges(); msg = "(Loaded new CSM to DB)"; } else { // update fields on existing BarnesAndNoble existing[0].url = csmdata.url; existing[0].notforkids = csmdata.notforkids; existing[0].offage = csmdata.offage; existing[0].onage = csmdata.onage; existing[0].review = csmdata.review; existing[0].parentreview = csmdata.parentreview; existing[0].kidreview = csmdata.kidreview; existing[0].genre = csmdata.genre; lr.SaveChanges(); msg = "(Updated existing CSM in DB)"; } } } catch { } return msg; }
public static string loadbndata(BarnesDto bndata) { string msg = "(Unable to load to local db)"; // receive bndata, load to database try { using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<BarnesAndNoble> existing = new List<BarnesAndNoble>(from b in lr.BarnesAndNobles where b.Isbn13 == bndata.Isbn13 select b); if (existing.Count == 0) { // create new BarnesAndNoble BarnesAndNoble bn = new BarnesAndNoble(); bn.Isbn13 = bndata.Isbn13; bn.AgeHigh = bndata.BarnesAgeOld; bn.AgeLow = bndata.BarnesAgeYoung; bn.Rating = (decimal)bndata.BarnesAvg; lr.BarnesAndNobles.Add(bn); lr.SaveChanges(); msg = "(Loaded new BN to DB)"; } else { // update fields on existing BarnesAndNoble existing[0].AgeHigh = bndata.BarnesAgeOld; existing[0].AgeLow = bndata.BarnesAgeYoung; existing[0].Rating = (decimal)bndata.BarnesAvg; lr.SaveChanges(); msg = "(Updated existing BN in DB)"; } } } catch { } return msg; }
public ActionResult TestResult() { LexileTitlesEntities lte = new LexileTitlesEntities(); // get some info from database, call LexileTitles List<LexileTitle> testlist = new List<LexileTitle>( (from lt in lte.LexileTitles select lt).Take(2)); // call service function // List<byte[]> resultlist = BookCaveSvc.PostNewLexile(testlist); List<StandardResult> resultlist = BookCaveSvc.postNewLexile(testlist); ViewBag.ResultList = resultlist; return View(); }
public ActionResult testCommonSense() { LexileTitlesEntities lte = new LexileTitlesEntities(); // get some info from database, call LexileTitles List<LexileTitle> lexs = new List<LexileTitle>( (from lt in lte.LexileTitles where lt.Awards != null select lt).Take(20)); // 'acquire' CSM record List<TitleIsbn13> TitleIsbns = new List<TitleIsbn13>(); foreach (LexileTitle lex in lexs) { TitleIsbn13 ti = new TitleIsbn13(); ti.isbn13 = lex.Isbn13; ti.title = lex.Title; TitleIsbns.Add(ti); } List<StandardResult> resultlist = DataAcquisition.getcsmdata(TitleIsbns, "loaddb"); ViewBag.ResultList = resultlist; return View(); }
public static void loadcsmdata(csmdata csmdata) { // receive bndata, load to database using (LexileTitlesEntities lr = new LexileTitlesEntities()) { List<CommonSenseMedia> existing = new List<CommonSenseMedia>(from c in lr.CommonSenseMedias where c.Isbn13 == csmdata.isbn13 select c); if (existing.Count == 0) { // create new BarnesAndNoble CommonSenseMedia csm = new CommonSenseMedia(); csm.Isbn13 = csmdata.isbn13; csm.url = csmdata.url; csm.notforkids = csmdata.notforkids; csm.offage = csmdata.offage; csm.onage = csmdata.onage; csm.review = csmdata.review; csm.parentreview = csmdata.parentreview; csm.kidreview = csmdata.kidreview; csm.genre = csmdata.genre; lr.CommonSenseMedias.Add(csm); lr.SaveChanges(); } else { // update fields on existing BarnesAndNoble existing[0].url = csmdata.url; existing[0].notforkids = csmdata.notforkids; existing[0].offage = csmdata.offage; existing[0].onage = csmdata.onage; existing[0].review = csmdata.review; existing[0].parentreview = csmdata.parentreview; existing[0].kidreview = csmdata.kidreview; existing[0].genre = csmdata.genre; lr.SaveChanges(); } } }