public void PostBarnesData()
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (var sr = new StreamReader(@"C:\Users\tiliska\Documents\bn-sample.csv"))
{
string svLine;
// Read and display lines from the file until the end of
// the file is reached.
using (var webClient = new WebClient())
{
while ((svLine = sr.ReadLine()) != null)
{
var barnesNobleData = svLine.Split(',');
var barnesDto = new BarnesDto();
var isbn13 = barnesNobleData[0];
barnesDto.Isbn13 = isbn13;
try
{
var ageLow = Convert.ToByte(barnesNobleData[1]);
barnesDto.BarnesAgeYoung = ageLow;
var ageHigh = Convert.ToByte(barnesNobleData[2]);
barnesDto.BarnesAgeOld = ageHigh;
var rating = Convert.ToDouble(barnesNobleData[3]);
barnesDto.BarnesAvg = rating;
}
catch (FormatException)
{
Console.WriteLine("data in csv aren't valid");
}
if (post)
{
var sourceCode = "barnes";
if (useCloud)
uri = new Uri(cloudUrl + sourceCode);
else
uri = new Uri(localUrl + sourceCode);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
webClient.Headers["Content-type"] = "application/json";
var memoryStream = new MemoryStream();
var serializedJson = new DataContractJsonSerializer(typeof(BarnesDto));
serializedJson.WriteObject(memoryStream, barnesDto);
byte[] res1 = webClient.UploadData(uri.ToString(), "POST", memoryStream.ToArray());
try
{
}
catch (WebException) { Console.WriteLine(barnesDto.Isbn13 + " has no general data"); }
}
else
{
var service = new BookService();
service.PostBarnesData(barnesDto);
try
{
}
catch (Exception) { }
}
}//while
}//using
}//using
}
public void TestGetBookByTargetSkillAge()
{
var service = new BookService();
service.GetBooks(null, null, "6", null, null);
}
public void PostLexileData()
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
//using (var sr = new StreamReader(@"C:\Users\tiliska\Documents\problematiclexile.txt"))
using (var sr = new StreamReader(@"C:\Users\tiliska\Documents\lexiletitles.txt"))
{
sr.ReadLine();//eat first line
string svLine;
var line = 1;
using (var webClient = new WebClient())
{
var sourceCode = "lexile";
if (useCloud)
uri = new Uri(cloudUrl + sourceCode);
else
uri = new Uri(localUrl + sourceCode);
// Read and display lines from the file until the end of
// the file is reached.
while ((svLine = sr.ReadLine()) != null)
{
line++;
if (svLine.StartsWith("#"))
{
Console.WriteLine("still a # on line " + line);
continue;
}
var bookParams = svLine.Split('\t');
var lexileDto = new LexileDto();
lexileDto.Title = bookParams[0];
lexileDto.Author = bookParams[1];
try
{
lexileDto.Isbn = bookParams[2];
try
{
lexileDto.Isbn13 = bookParams[3];
if (bookParams[5].Length > 0)
lexileDto.LexScore = Convert.ToInt16(bookParams[5]);
if (bookParams[7].Length > 0)
lexileDto.PageCount = Convert.ToInt16(bookParams[7]);
lexileDto.LexUpdate = Convert.ToDateTime(bookParams[12]);
}
catch (FormatException) { Console.WriteLine("metametrics messed up the row in the text db on line " + line); }
lexileDto.LexCode = bookParams[4];
lexileDto.Publisher = bookParams[6];
lexileDto.DocType = bookParams[8];
lexileDto.Series = bookParams[9];
lexileDto.Awards = bookParams[10];
lexileDto.Summary = bookParams[11];
if (post)
{
//HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
webClient.Headers["Content-type"] = "application/json";
var memoryStream = new MemoryStream();
var serializedJson = new DataContractJsonSerializer(typeof(LexileDto));
serializedJson.WriteObject(memoryStream, lexileDto);
byte[] res1 = webClient.UploadData(uri.ToString(), "POST", memoryStream.ToArray());
}
else
{
var service = new BookService();
service.PostLexileData(lexileDto);
}
//else if (method.Equals("skillmetrics"))
//{
// var service = new BookService();
// var skillAggregate = service.GetSkillMetrics(lexileDto.Isbn13);
//}
}
catch (IndexOutOfRangeException) { Console.WriteLine("metametrics messed up the row in the text db on line " + line); }
}//while
}//using
}//using
}
public void PostScholasticData()
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (var sr = new StreamReader(@"C:\Users\tiliska\documents\sch-output2.csv"))
{
var sourceCode = "scholastic";
if (useCloud)
uri = new Uri(cloudUrl + sourceCode);
else
uri = new Uri(localUrl + sourceCode);
sr.ReadLine();
string svLine;
// Read and display lines from the file until the end of
// the file is reached.
while ((svLine = sr.ReadLine()) != null)
{
var scholasticData = svLine.Split(',');
var scholasticDto = new ScholasticDto();
//isbn13
var isbn13 = scholasticData[0];
scholasticDto.Isbn13 = isbn13;
var service = new BookService();
//scholastic lower interest grade
var scholasticGradeLower = scholasticData[1];
scholasticDto.ScholasticGradeLower = scholasticGradeLower.Trim();
//scholastic higher interest grade
var scholasticGradeHigher = scholasticData[2];
if (scholasticGradeHigher.Trim().Length > 0) scholasticDto.ScholasticGradeHigher = (byte?)Convert.ToByte(scholasticGradeHigher);
//scholastic equivalent grade
try
{
var scholasticGrade = scholasticData[3];
scholasticDto.ScholasticGrade = Convert.ToDouble(scholasticGrade);
}
catch (FormatException) { Console.WriteLine("parameter not found"); }
//dra
var dra = scholasticData[4];
scholasticDto.Dra = dra;
//guided reading level
var guidedReading = scholasticData[5];
scholasticDto.GuidedReading = guidedReading;
if (post)
{
//HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
var webClient = new WebClient();
webClient.Headers["Content-type"] = "application/json";
var memoryStream = new MemoryStream();
var serializedJson = new DataContractJsonSerializer(typeof(ScholasticDto));
serializedJson.WriteObject(memoryStream, scholasticDto);
try
{
byte[] res1 = webClient.UploadData(uri.ToString(), "POST", memoryStream.ToArray());
}
catch (WebException) { Console.WriteLine(scholasticDto.Isbn13 + " doesn't have general info"); }
}
else
service.PostScholasticData(scholasticDto);
//case "skillmetrics":
// service.GetSkillMetrics(isbn13);
// break;
//case "contentmetrics":
// service.GetContentMetrics(isbn13);
// break;
}
}
}
public void PostCommonSenseData()
{
using (var sr = new StreamReader(@"C:\Users\tiliska\documents\csm.csv"))
{
sr.ReadLine();
string svLine;
// Read and display lines from the file until the end of
// the file is reached.
while ((svLine = sr.ReadLine()) != null)
{
var commonSenseData = svLine.Split(',');
var commonSenseDto = new CommonSenseDto();
//isbn13
var isbn13 = commonSenseData[0];
commonSenseDto.Isbn13 = isbn13;
var service = new BookService();
var bookReviewUrl = commonSenseData[1];
var notForKids = commonSenseData[2];
commonSenseDto.CommonSenseNoKids = Convert.ToBoolean(notForKids);
var commonSensePause = commonSenseData[3];
commonSenseDto.CommonSensePause = Convert.ToByte(commonSensePause);
var commonSenseOn = commonSenseData[4];
commonSenseDto.CommonSenseOn = Convert.ToByte(commonSenseOn);
if (post)
{
var sourceCode = "commonsense";
if (useCloud)
uri = new Uri(cloudUrl + sourceCode);
else
uri = new Uri(localUrl + sourceCode);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
var webClient = new WebClient();
webClient.Headers["Content-type"] = "application/json";
var memoryStream = new MemoryStream();
var serializedJson = new DataContractJsonSerializer(typeof(CommonSenseDto));
serializedJson.WriteObject(memoryStream, commonSenseDto);
try
{
byte[] res1 = webClient.UploadData(uri.ToString(), "POST", memoryStream.ToArray());
}
catch (WebException) { Console.WriteLine(commonSenseDto.Isbn13 + " doesn't have general info"); }
}
else
service.PostCommonSenseData(commonSenseDto);
}//while
}//using
}
