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) { } }