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