Beispiel #1
0
 private void DisplayTableInfo(TableD table)
 {
     pnInfoTable.Tag = table.IdTableD;
     lbNameTb.Text   = "No. " + table.NameTable;
     if (table.Status == 0)
     {
         lbTime.Text   = "Không xác định";
         lbPeople.Text = "Chưa có người";
         lbMoney.Text  = "0 VNĐ";
     }
     else if (table.Status == 1)
     {
         int[] bill = TableDDAO.Instance.HowManyPeople(table.IdTableD);
         lbPeople.Text = bill[0].ToString();
         lbMoney.Text  = BillDAO.Instance.GetTotalPriceByIdBill(bill[1]).ToString() + " VNĐ";
         DateTime?time = BillDAO.Instance.GetTimeByidBill(bill[1]);
         if (time == null)
         {
             return;
         }
         else
         {
             if (time.Value.Hour < 12)
             {
                 lbTime.Text = time.Value.Hour.ToString() + ":" + time.Value.Minute.ToString() + " AM";
             }
             else
             {
                 lbTime.Text = (time.Value.Hour - 12).ToString() + ":" + time.Value.Minute.ToString() + " PM";
             }
         }
     }
     //Hien thi so nguoi , thanh toan
 }
Beispiel #2
0
        public void CanFetchNestedNavPropertiesBidirectional()
        {
            var options = BuildOptions(ContextProviderType.InMemory);
            var factory = new RepositoryFactory(options);

            var repoA = factory.Create <TableA>();
            var a     = new TableA {
                Id = 99
            };

            repoA.Add(a);
            repoA.Add(new TableA {
                Id = 2333
            });
            repoA.Add(new TableA {
                Id = 9
            });

            var repoB = factory.Create <TableB>();
            var b     = new TableB {
                Id = 10, TableAId = a.Id
            };

            repoB.Add(b);

            var repoC = factory.Create <TableC>();
            var c     = new TableC {
                Id = 10, TableBId = b.Id
            };

            repoC.Add(c);

            var repoD = factory.Create <TableD>();
            var d     = new TableD {
                Id = 500, TableCId = c.Id
            };

            repoD.Add(d);

            var queryOptions = new QueryOptions <TableA>()
                               .WithFetch(x => x.TableB)
                               .WithFetch(x => x.TableB.TableC)
                               .WithFetch(x => x.TableB.TableC.TableD)
                               .WithFilter(x => x.Id == a.Id);

            var result = repoA.Find(queryOptions);

            Assert.NotNull(result.TableB);
            Assert.NotNull(result.TableB.TableA);
            Assert.Equal(b.Id, result.TableB.Id);

            Assert.NotNull(result.TableB.TableC);
            Assert.NotNull(result.TableB.TableC.TableB);
            Assert.Equal(c.Id, result.TableB.TableC.Id);

            Assert.NotNull(result.TableB.TableC.TableD);
            Assert.NotNull(result.TableB.TableC.TableD.TableC);
            Assert.Equal(d.Id, result.TableB.TableC.TableD.Id);
        }
Beispiel #3
0
        private void btnTable_Click(object sender, EventArgs e)
        {
            Button button = sender as Button;
            TableD table  = button.Tag as TableD;

            //
            //Hiện table info
            //
            DisplayTableInfo(table);

            if (table.Status == 0)
            {
                ContextMenu cm = new ContextMenu();
                cm.MenuItems.Add("Tạo Hóa Đơn", new EventHandler(CreateBill));
                cm.Show(button, button.PointToClient(Cursor.Position));
            }
            else
            {
                ContextMenu cm = new ContextMenu();
                cm.MenuItems.Add("Xem hóa đơn", new EventHandler(SeeBill));
                cm.Show(button, button.PointToClient(Cursor.Position));
            }
        }
        public void TableDInsertStatement_ShouldIncludeIdentity()
        {
            var tableD = new TableD()
            {
                FieldOne = "whatever", Id = 0
            };

            var db = new PostulateDb();

            using (var cn = db.GetConnection())
            {
                if (!db.Syntax.TableExists(cn, typeof(TableD)))
                {
                    var ct = new CreateTable(db.Syntax, new TableInfo("TableD", "dbo", typeof(TableD)));
                    foreach (var cmd in ct.SqlCommands(cn))
                    {
                        cn.Execute(cmd);
                    }
                }

                db.TraceCallback = (cn1, qt) => { Assert.IsTrue(qt.Sql.Equals("hello")); };
                db.Save(tableD);
            }
        }