protected internal StandardSetWebCMS ReturnWebCMSData(List <Datum> result, string guidString)
{
StandardSetWebCMS standardSetWebCMS = new StandardSetWebCMS();
string standardSetName = string.Empty, content = string.Empty;
List <LevelDict> levelList = new List <LevelDict>();
LevelDict levelDict = new LevelDict();
string state = string.Empty;
foreach (var item in result)
{
//Get values for all levels from 1-9
content = item.attributes.document.descr;
levelList = GetLevel(item, levelList, levelDict, content);
state = levelList.Select(x => x.state).First();
if (string.IsNullOrEmpty(standardSetName))
{
string level1 = levelList.Where(x => x.levelNumber == 1).Select(y => y.standardText).First();
string level2 = levelList.Where(x => x.levelNumber == 2).Select(y => y.standardText).First();
string level3 = levelList.Where(x => x.levelNumber == 3).Select(y => y.standardText).First();
standardSetName = FormStandardSetName(state, level1, level2, level3);
}
}
standardSetWebCMS.standardSetName = standardSetName;
if (state == "CC")
{
state = "NT";
}
standardSetWebCMS.state = state;
standardSetWebCMS.webCMSLevels.AddRange(levelList);
return(standardSetWebCMS);
}
protected internal StandardSetWebCMS StripStandardSetJsonForWebCMSRelevantData(string facet, string guidString, string app = null)
{
StandardSetFinal standardSetFinal = StripStandardSetJsonForRiversideRelevantData(facet, guidString, app);
StandardSetWebCMS standardSetWebCMS = ReturnWebCMSData(standardSetFinal.data, guidString);
InsertCollectionIntoWebCMS(standardSetWebCMS);
return(standardSetWebCMS);
}
public dynamic GetAppSpecificStandard(string guidString, string app)
{
if (app == "webcms")
{
StandardSetWebCMS result = helper.StripStandardSetJsonForWebCMSRelevantData("standardset", guidString, app);
return(result);
}
else
{
return(null);
}
}
protected internal void InsertCollectionIntoWebCMS(StandardSetWebCMS standardSetWebCMS)
{
try
{
DataTable standardTable = ConvertToDataTable(standardSetWebCMS.webCMSLevels);
AppConfiguration appConfiguration = new AppConfiguration();
using (SqlConnection sqlcon = new SqlConnection(appConfiguration.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("InsertStandardSetIntoWebCMS", sqlcon))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter standardSetName = new SqlParameter();
standardSetName.Direction = ParameterDirection.Input;
standardSetName.ParameterName = "@StandardSetName";
standardSetName.SqlDbType = SqlDbType.VarChar;
standardSetName.Value = standardSetWebCMS.standardSetName;
cmd.Parameters.Add(standardSetName);
SqlParameter state = new SqlParameter();
state.Direction = ParameterDirection.Input;
state.ParameterName = "@State";
state.SqlDbType = SqlDbType.VarChar;
state.Value = standardSetWebCMS.state;
cmd.Parameters.Add(state);
SqlParameter tableParameter = new SqlParameter();
tableParameter.Direction = ParameterDirection.Input;
tableParameter.ParameterName = "@StandardSetTable";
tableParameter.SqlDbType = SqlDbType.Structured;
tableParameter.Value = standardTable;
cmd.Parameters.Add(tableParameter);
cmd.CommandTimeout = 0;
sqlcon.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
}
}
