/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(Q2) Query demonstration");
Console.WriteLine("------------------------");
Console.WriteLine("Teacher 't.0':");
Teacher t = Orm.Get <Teacher>("t.0");
Console.WriteLine(t.FirstName + " " + t.Name);
Person p = new Person();
p.ID = "p.0";
p.FirstName = "Alex";
p.Name = "Lang";
p.BirthDate = new DateTime(1972, 3, 28);
p.Gender = Gender.MALE;
Orm.Save(p);
Console.WriteLine("\nStudents with grade > 2:");
foreach (Student i in Orm.From <Student>().GreaterThan("Grade", 2))
{
Console.WriteLine(i.FirstName + " " + i.Name);
}
Console.WriteLine("\nShow all persons:");
foreach (Person i in Orm.From <Person>())
{
Console.WriteLine(i.FirstName + " " + i.Name + " (" + i.GetType().Name + ")");
}
}
public List <chartData> EChartData()
{
List <invoiceChartView> chartData = Orm.Get <invoiceChartView>();
List <chartData> data = new List <chartData>();
chartData item = new Models.chartData {
value = chartData[0].Paid, name = "Paid"
};
data.Add(item);
item = new Models.chartData {
value = chartData[0].Unpaid, name = "Unpaid",
};
data.Add(item);
item = new Models.chartData {
value = chartData[0].Pending, name = "Pending"
};
data.Add(item);
item = new Models.chartData {
value = chartData[0].Overdue, name = "Overdue"
};
data.Add(item);
return(data);
}
/// <summary>Shows instances.</summary>
private static void _ShowInstances()
{
for (int i = 0; i < 7; i++)
{
Teacher t = Orm.Get <Teacher>("t.0");
Console.WriteLine("Object [" + t.ID + "] instance no: " + t.InstanceNumber.ToString());
}
}
/// <summary>This show case loads a teacher with a list of classes.</summary>
public static void Show()
{
Console.WriteLine("(4) Load teacher and show classes");
Console.WriteLine("---------------------------------");
Teacher t = Orm.Get <Teacher>("t.0");
Console.WriteLine(t.FirstName + " " + t.Name + " teaches:");
foreach (Class i in t.Classes)
{
Console.WriteLine(i.Name);
}
Console.WriteLine("\n");
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(5) Create and load an object with m:n");
Console.WriteLine("--------------------------------------");
Course c = new Course();
c.ID = "x.0";
c.Name = "Demons 1";
c.Teacher = Orm.Get <Teacher>("t.0");
Student s = new Student();
s.ID = "s.0";
s.Name = "Aalo";
s.FirstName = "Alice";
s.Gender = Gender.FEMALE;
s.BirthDate = new DateTime(1990, 1, 12);
s.Grade = 1;
Orm.Save(s);
c.Students.Add(s);
s = new Student();
s.ID = "s.1";
s.Name = "Bumblebee";
s.FirstName = "Bernard";
s.Gender = Gender.MALE;
s.BirthDate = new DateTime(1991, 9, 23);
s.Grade = 2;
Orm.Save(s);
c.Students.Add(s);
Orm.Save(c);
c = Orm.Get <Course>("x.0");
Console.WriteLine("Students in " + c.Name + ":");
foreach (Student i in c.Students)
{
Console.WriteLine(i.FirstName + " " + i.Name);
}
Console.WriteLine("\n");
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(8) Locking demonstration");
Console.WriteLine("-------------------------");
Console.WriteLine();
Orm.Locking = new DbLocking();
Teacher t = Orm.Get <Teacher>("t.0");
Orm.Lock(t);
Orm.Locking = new DbLocking();
try
{
Orm.Lock(t);
}
catch (Exception ex) { Console.WriteLine(ex.Message); }
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(2) Load and modify object");
Console.WriteLine("--------------------------");
Teacher t = Orm.Get <Teacher>("t.0");
Console.WriteLine();
Console.WriteLine("Salary for " + t.FirstName + " " + t.Name + " is " + t.Salary.ToString() + " Pesos.");
Console.WriteLine("Give rise of 12000.");
t.Salary += 12000;
Console.WriteLine("Salary for " + t.FirstName + " " + t.Name + " is now " + t.Salary.ToString() + " Pesos.");
Orm.Save(t);
Console.WriteLine("\n");
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(3) Create and load an object with foreign key");
Console.WriteLine("----------------------------------------------");
Teacher t = Orm.Get <Teacher>("t.0");
Class c = new Class();
c.ID = "c.0";
c.Name = "Demonolgy 101";
c.Teacher = t;
Orm.Save(c);
c = Orm.Get <Class>("c.0");
Console.WriteLine((c.Teacher.Gender == Gender.MALE ? "Mr. " : "Ms. ") + c.Teacher.Name + " teaches " + c.Name + ".");
Console.WriteLine("\n");
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(6) Use Lazy loading for student list");
Console.WriteLine("-------------------------------------");
Class c = Orm.Get <Class>("c.0");
c.Students.Add(Orm.Get <Student>("s.0"));
c.Students.Add(Orm.Get <Student>("s.1"));
Orm.Save(c);
c = Orm.Get <Class>("c.0");
Console.WriteLine("Students in " + c.Name + ":");
foreach (Student i in c.Students)
{
Console.WriteLine(i.FirstName + " " + i.Name);
}
Console.WriteLine("\n");
}
/// <summary>Implements the show case.</summary>
public static void Show()
{
Console.WriteLine("(Q1) Query demonstration");
Console.WriteLine("------------------------");
Console.WriteLine("Teacher 't.0':");
Teacher t = Orm.Get <Teacher>("t.0");
Console.WriteLine(t.FirstName + " " + t.Name);
Console.WriteLine("\nStudents with grade > 2:");
foreach (Student i in Orm.From <Student>().GreaterThan("Grade", 2))
{
Console.WriteLine(i.FirstName + " " + i.Name);
}
Console.WriteLine("\nShow all persons:");
foreach (Person i in Orm.From <Person>())
{
Console.WriteLine(i.FirstName + " " + i.Name + " (" + i.GetType().Name + ")");
}
}
public List <customers> GetCustomer()
{
return(Orm.Get <customers>());
}
public List <payment> Get(int invoideID)
{
return(Orm.Get <payment>());
}
public List <payment> Get()
{
return(Orm.Get <payment>());
}
