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