public void Database_GetTours_Inserttourlog_Failed() { Tourlog tmp = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); int ret = Database.InsertTourlogs(tmp, "컴컴컴컴컴컴컴컴"); Assert.AreEqual(-1, ret); }
public void Buisnesslogic_CreatePDFFailed() { Exception ex_returnval = null; Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; try { int returnval = PdfWriter.CreatePdfReport(@"U:\tmp", Tour1).Result; } catch (Exception e) { ex_returnval = e; } Assert.AreEqual(typeof(AggregateException), ex_returnval.GetType()); }
public void Buisnesslogic_SerializeExportFailed() { Exception ex_returnval = null; Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); Tour Tour2 = new Tour(null, "Weite Runde2", "abc", "Illmitz", "Podersdorf", 20); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; Tourlog.Add(Tour1); Tourlog.Add(Tour2); try { JsonOperator.Export(Tourlog, @"Z:\tmp"); } catch (Exception e) { ex_returnval = e; } Assert.AreEqual(typeof(DirectoryNotFoundException), ex_returnval.GetType()); Assert.Pass(); }
public void TestPDFStringTourlog() { var TL = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); string[] expected = new string[] { TL.TLID.ToString(), TL.Timestamp.ToString(), TL.Report, TL.Distance.ToString(), TL.Totaltime.ToString(), TL.Rating.ToString(), TL.AvgSpeed.ToString(), TL.Difficulty.ToString(), TL.EnergyBurn.ToString(), TL.Temperature.ToString(), TL.Water.ToString() }; Assert.AreEqual(TL.PrintToPDF(), expected, "Some useful error message"); }
public void Buisnesslogic_SerializeExport() { Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); Tour Tour2 = new Tour(null, "Weite Runde2", "abc", "Illmitz", "Podersdorf", 20); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; Tourlog.Add(Tour1); Tourlog.Add(Tour2); JsonOperator.Export(Tourlog, @"E:\tmp"); Assert.IsTrue(File.Exists(@"E:\tmp\Tours.json")); }
public void Buisnesslogic_CreatePDF() { Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; PdfWriter.CreatePdfReport(@"C:\tmp", Tour1); Assert.AreEqual(true, File.Exists(@"C:\tmp\Report.pdf")); }
public void Buisnesslogic_DeserializeTourJson() { Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; Tourlog.Add(Tour1); ObservableCollection <Tour> returnval = JsonOperator.DeserializeTours(@"E:\tmp\Tours.json"); Assert.AreEqual(returnval[0].Name, Tourlog[0].Name); }
public void Buisnesslogic_SerializeTourJson() { Tour Tour1 = new Tour(null, "Weite Runde", "abc", "Illmitz", "Podersdorf", 20); Tourlog TL1 = new Tourlog(-1, DateTime.Now, "Very Nice", 10, 120, 3, 3.34, 4, 200, 40, 3.5); ObservableCollection <Tourlog> Tourloglist = new ObservableCollection <Tourlog>(); ObservableCollection <Tour> Tourlog = new ObservableCollection <Tour>(); Tourloglist.Add(TL1); Tour1.Tourlogs = Tourloglist; Tourlog.Add(Tour1); string returnval = JsonOperator.SerializeTours(Tourlog); string expt = JsonSerializer.Serialize(Tourlog); Assert.AreEqual(expt, returnval); }
/// <summary>Inserts the tourlogs.</summary> /// <param name="TL">The tl.</param> /// <param name="name">The name.</param> /// <returns> /// <br /> /// </returns> public static int InsertTourlogs(Tourlog TL, string name) { int returnval = -3; using NpgsqlConnection conn = Connectionhander.returnConnection(); conn.Open(); try { var cmd = new NpgsqlCommand($"Select insert_tourlog((Select TID from Tour WHERE Name = @payload), @report , @datetime,@dist,@tottime,@rateing,@diff,@temp); ", conn); cmd.Parameters.Add(new NpgsqlParameter("payload", name)); cmd.Parameters.Add(new NpgsqlParameter("report", TL.Report)); cmd.Parameters.Add(new NpgsqlParameter("datetime", TL.Timestamp)); cmd.Parameters.Add(new NpgsqlParameter("dist", TL.Distance)); cmd.Parameters.Add(new NpgsqlParameter("tottime", TL.Totaltime)); cmd.Parameters.Add(new NpgsqlParameter("rateing", TL.Rating)); cmd.Parameters.Add(new NpgsqlParameter("diff", TL.Difficulty)); cmd.Parameters.Add(new NpgsqlParameter("temp", TL.Temperature)); NpgsqlDataReader myReader = cmd.ExecuteReader(); if (myReader.HasRows) { Console.WriteLine("Query Generated result:"); while (myReader.Read()) { returnval = myReader.GetInt16(0); } } } catch (Exception e) { Console.WriteLine("SQ :Query Error: " + e.Message); throw; } finally { conn.Close(); } return(returnval); }
public async void Execute(object?parameter) { try { Tourlog tmp = new Tourlog(__addtourviewmodel.Time, __addtourviewmodel.Report, __addtourviewmodel.Distance, __addtourviewmodel.TTime, __addtourviewmodel.Rating, __addtourviewmodel.Difficulty, __addtourviewmodel.Temp); await Mainlogic.Inserttourlog(tmp, MainViewModel.PublicselectedTour.Name); MainViewModel.Singelton.UpdateTours(); } catch (Exception e) { Console.WriteLine(e); throw; } if (parameter != null && parameter is Window) { ((Window)parameter).Close(); } }
public static async Task Inserttourlog(Tourlog tmp, string selectedname) { Database.InsertTourlogs(tmp, selectedname); }
public static void DeleteTourLog(Tourlog tmp) { Database.DeleteTourlog(tmp.TLID); }