private static void ImportStandard(Guid standardSetsKey, BladeRunner.JsonModel.StandardSets.Standard standard)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand("sp_insert_tbl_standards", connection))
{
connection.Open();
command.CommandType = CommandType.StoredProcedure;
SqlParameter retVal = command.Parameters.Add("RetVal", SqlDbType.Int);
retVal.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(new SqlParameter("@standards_key", Guid.NewGuid()));
command.Parameters.Add(new SqlParameter("@standard_sets_key", standardSetsKey));
command.Parameters.Add(new SqlParameter("@standards_id", standard.Id));
command.Parameters.Add(new SqlParameter("@standards_asnIdentifier", standard.AsnIdentifier));
command.Parameters.Add(new SqlParameter("@standards_position", standard.Position));
command.Parameters.Add(new SqlParameter("@standards_depth", standard.Depth));
command.Parameters.Add(new SqlParameter("@standards_statementNotation", standard.StatementNotation));
command.Parameters.Add(new SqlParameter("@standards_statementLabel", standard.StatementLabel));
command.Parameters.Add(new SqlParameter("@standards_listId", standard.ListId));
command.Parameters.Add(new SqlParameter("@standards_description", standard.Description));
command.Parameters.Add(new SqlParameter("@standards_ancestorIds", standard.GetAncestorIds()));
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
}
reader.Close();
}
}
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
_reader = reader;
Standards standards = new Standards();
while (Read())
{
if (CurrentTokenType == JsonToken.StartObject)
{
Standard standard = new Standard();
while (Read())
{
if (CurrentTokenType == JsonToken.PropertyName)
{
string name = CurrentValue.ToString();
switch (name)
{
case "id":
{
standard.Id = ReadString();
break;
}
case "asnIdentifier":
{
standard.AsnIdentifier = ReadString();
break;
}
case "position":
{
standard.Position = ReadInt();
break;
}
case "depth":
{
standard.Depth = ReadInt();
break;
}
case "statementNotation":
{
standard.StatementNotation = ReadString();
break;
}
case "statementLabel":
{
standard.StatementLabel = ReadString();
break;
}
case "listId":
{
standard.ListId = ReadString();
break;
}
case "description":
{
standard.Description = ReadString();
break;
}
case "ancestorIds":
{
List <string> list = new List <string>();
while (Read())
{
if (CurrentTokenType == JsonToken.String)
{
list.Add(CurrentValue.ToString());
}
if (CurrentTokenType == JsonToken.EndArray)
{
break;
}
}
standard.AncestorIds = list;
break;
}
}
}
if (CurrentTokenType == JsonToken.EndObject)
{
break;
}
}
if (standard != new Standard())
{
standards.Add(standard);
}
}
if (CurrentTokenType == JsonToken.EndArray)
{
break;
}
}
return(standards);
}
