//Initialize Shoe Database
public void initShoeDB()
{
DB = Db4oFactory.OpenFile("Shoe Database.yap");
IList <ShoeClass> dtList = DB.Query <ShoeClass>(typeof(ShoeClass));
if (dtList.Count() <= 0)
{
ShoeClass AP = new ShoeClass()
{
ShoeID = "AP001",
ShoeName = "Air Presto Off-White",
Price = 1900
};
ShoeClass AJ = new ShoeClass()
{
ShoeID = "AJ001",
ShoeName = "Air Jordan 1 Retro High Off-White Chicago",
Price = 2000
};
ShoeClass NMD = new ShoeClass()
{
ShoeID = "NM001",
ShoeName = "Adidas Human Race NMD Pharrell x Chanel Black",
Price = 8000
};
DB.Store(NMD);
DB.Store(AJ);
DB.Store(AP);
}
DB.Close();
}
public void loadData()
{
//Header Transaction
DB = Db4oFactory.OpenFile("Header Transaction.yap");
currHT = (from x in DB.Query <HeaderTransaction>()
where x.UserId == currentUser.ID
select x).ToList();
DB.Close();
if (currHT.Count() <= 0)
{
MessageBox.Show("Please Buy First!");
}
else
{
List <ShoeClass> shoeList = new List <ShoeClass>();
//Detail Transaction
for (int i = 0; i < currHT.Count; i++)
{
DB = Db4oFactory.OpenFile("Detail Transaction.yap");
List <DetailTransaction> dtList = DB.Query <DetailTransaction>(delegate(DetailTransaction dt)
{
return(dt.HeaderTransactionID == currHT.ElementAt(i).HeaderTransactionID);
}).ToList();
//ShoeClass
DB.Close();
DB = Db4oFactory.OpenFile("Shoe Database.yap");
foreach (var obj in dtList)
{
ShoeClass shoe = (from x in DB.Query <ShoeClass>()
where x.ShoeID == obj.ShoeID
select x).FirstOrDefault();
shoeList.Add(shoe);
}
//IList<ShoeClass> shoeList = DB.Query<ShoeClass>(delegate(ShoeClass shoe){
//});
//Query Detail Transaction to get Shoes from ShoeClass
//IQuery dtQuery = DB.Query();
//dtQuery.Constrain(typeof(ShoeClass));
//dtQuery.Descend("ShoeID").Constrain(dtList.)
dgvMSF.DataSource = shoeList.ToList();
//dgvMSF.DataSource = shoeList.ToList();
DB.Close();
}
}
}
