public static void EntryUpload() { Console.WriteLine("Upload data by Answering the following questions:"); Console.WriteLine("Race Course Name:"); string CourseName = Console.ReadLine(); Console.WriteLine("Date Race was Ran (YYYY-MM-DD):"); string DateRan = Console.ReadLine(); Console.WriteLine("Amount Bet:"); string Amount = Console.ReadLine(); Console.WriteLine("Result:(won or lost)"); string res = Console.ReadLine(); BsonDocument docu = new BsonDocument { { "CourseName", CourseName }, { "DateRan", DateRan }, { "AmountWon", ParseControl.AmountParse(Amount) }, { "Result", ResCheck(res) } }; DBInteractionClass.DbCSVUpload(docu); Console.WriteLine("docu added " + docu); Startup.Start(); }
// Parse file Method public static string[] ParseFile(string contents) { string splitString = "\n"; string[] fileLines = contents.Split(new string[] { splitString }, StringSplitOptions.RemoveEmptyEntries); foreach (var line in fileLines) { string l = line.Replace("(", "").Replace(")", ",").Replace(" ", ""); string[] entry = l.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); // take each entry and do something string CourseName = entry[0]; // Date comes in year/month/day, parse using DateTime.Parse and then .ToShortDateString(). string DateRan = entry[1] + "-" + entry[2] + "-" + entry[3]; string Amount = entry[4]; string Result = entry[5]; BsonDocument docu = new BsonDocument { { "CourseName", CourseName }, { "DateRan", ParseControl.DateParse(DateRan) }, { "Amount", ParseControl.AmountParse(Amount) }, { "Result", ParseControl.resultBoolCheck(Result) } }; DBInteractionClass.DbCSVUpload(docu); Console.WriteLine(CourseName + " Added"); } return(fileLines); }