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 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;
}