static void Main(string[] args) { var cr = ConfigReader.GetConfigReader(); ParentBuilder _pb = new ParentBuilder(); Dictionary <string, List <string> > dict = DictionaryBuilder.BuildDictionary(new List <string>() { "CategoryID", "CategoryName", "Picture" }); _pb.AddChild(new ChildBuilder("categories", dict, ParentBuilder.Statements.Select)); Dictionary <string, List <string> > dict2 = DictionaryBuilder.BuildDictionary(new List <string>() { "ID" }); dict2.Values.ElementAt(0).Add("1"); _pb.AddChild(new ChildBuilder("order_details", dict2, ParentBuilder.Statements.Delete)); Dictionary <string, List <string> > dict3 = DictionaryBuilder.BuildDictionary(new List <string>() { "Quantity" }); dict3.Values.ElementAt(0).Add("15"); //dict3.Values.ElementAt(1).Add("OrderID = 10248"); _pb.AddChild(new ChildBuilder("order_details", dict3, ParentBuilder.Statements.Update, "UA")); Dictionary <string, List <string> > dict4 = DictionaryBuilder.BuildDictionary(new List <string>() { "CategoryName", "Picture", "Description" }); dict4.Values.ElementAt(0).Add("Test123"); dict4.Values.ElementAt(1).Add("Hello.jpg"); dict4.Values.ElementAt(2).Add("Hahahaha"); _pb.AddChild(new ChildBuilder("categories", dict4, ParentBuilder.Statements.Insert)); _pb.Run(); Console.WriteLine("EVERYTHING WORKED"); Console.ReadLine(); }
public static ParentBuilder Run(ParentBuilder parent) { _parent = parent; StartDbConnection(); StartTransaction(); for (int i = 0; i < parent.Children.Count; i++) { Fresh(); ParseCommand(parent.Children[i]); Execute(); } EndTransaction(); EndDbConnection(); return(_parent); }