private void Button6_Click(object sender, EventArgs e)
{
richTextBox1.Clear();
SellersRepository sellRepo = SellersRepository.getInstance();
ArticlesRepository artRepo = ArticlesRepository.getInstance();
Seller s = (Seller)sellRepo.getEntityById(1);
richTextBox1.Text = s.Name;
}
private void Button2_Click(object sender, EventArgs e)
{
richTextBox1.Clear();
SellersRepository sellRepo = SellersRepository.getInstance();
EntityList list = sellRepo.getList();
Seller[] sellers = (Seller[])list.fetch();
foreach (Seller s in sellers)
{
richTextBox1.Text += s.Name + " " + s.Id + "\n";
}
}
private void Button3_Click(object sender, EventArgs e)
{
richTextBox1.Clear();
SellersRepository sellRepo = SellersRepository.getInstance();
ArticlesRepository artRepo = ArticlesRepository.getInstance();
EntityList sellerList = sellRepo.getList();
EntityList articleList = artRepo.getList();
DataList dataRel = sellerList.toDataList();
dataRel.joinWith(articleList, "Id", "seller_id");
DataTable dt = dataRel.fetch();
DataRowCollection rows = dt.Rows;
DataColumnCollection columns = dt.Columns;
for (int i = 0; i < columns.Count; i++)
{
DataColumn column = columns[i];
richTextBox1.Text += column.ToString() + " ";
}
richTextBox1.Text += "\n";
for (int i = 0; i < rows.Count; i++)
{
object[] items = rows[i].ItemArray;
for (int a = 0; a < items.Length; a++)
{
richTextBox1.Text += items[a].ToString() + " ";
}
richTextBox1.Text += "\n";
}
}
