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();
}
}
}
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 void appendcsm(CommonSenseMedia csm, TextWriter w)
{
w.WriteLine("{0}, {1}, {2}, {3}, {4}",
string.Format("{0}", csm.Isbn13),
string.Format("{0}", csm.url),
string.Format("{0}", csm.notforkids),
string.Format("{0}", csm.offage),
string.Format("{0}", csm.onage));
}