public static bool SaveXMLToAppResources(this string xmlInput, int appxmlRecordsId, int appDefinitionId, int appSystemId, int userId) { if (!(xmlInput.ValidateXml())) { return(false); } var sqlTalker = new SQLTalker("DEV-ENTERPRISE", "AppResources", "sqluser", "pa55word"); return(sqlTalker.ProcerWithSuccess($"EXEC dbo.AppXmlRecords_InsertOrUpdate {appxmlRecordsId}, {appDefinitionId}, {appSystemId}, {userId}, '{xmlInput}'")); }
private static void AppResourcesSavingExample() { var current = DateTime.Now.Date; var demandTrend = new DemandTrendInput("1", 111, current, current.AddDays(5), TrendChoices.FiscalWeek, new List <int> { 1, 2, 3 }); var demandTrend2 = new DemandTrendInput("2", 222, current, current.AddDays(5), TrendChoices.FiscalWeek, new List <int> { 4, 5, 6 }); var d = new SerializableDictionary <string, DemandTrendInput> { { "1", demandTrend }, { "2", demandTrend2 } }; var serialized = d.SerializeToXml(); var deserialized = serialized.DeserializeXml <SerializableDictionary <string, DemandTrendInput> >(); //var vals = deserialized.ToList(); //var data = new List<DemandTrendInput>(); foreach (var item in deserialized.ToList()) { item.Value.DemandTrendName = item.Key; //data.Add(new DemandTrendInput(item.Key, item.Value.FIKey, item.Value.StartDate, item.Value.EndDate, (TrendChoices)Enum.Parse(typeof(TrendChoices), item.Value.Grouping), item.Value.DemandLocations)); } deserialized.Values.ToList().ForEach(x => Console.WriteLine($"{x.DemandTrendName} {x.StartDate} {x.EndDate}")); var change = serialized.Substring(1, 200); serialized.SaveXMLToAppResources(4, 1, 2, 744); var sqlTalker = new SQLTalker("DEV-ENTERPRISE", "AppResources", "sqluser", "pa55word"); var data = sqlTalker.GetData("EXEC dbo.AppXmlRecords_Select"); var items = serialized.DeserializeXml <SerializableDictionary <string, DemandTrendInput> >(); }