public DAL.DataSet1.gridDataTable GetDataByUsername(string username)
{
DAL.DataSet1.gridDataTable grid = Adapter.GetDataByUsername();
for (int i = 1; i < grid.Rows.Count; i++)
{
//if (grid.Rows[i]["title"].ToString() == grid.Rows[i - 1]["title"].ToString())
if (grid.Rows[i]["entry_id"].ToString() == grid.Rows[i - 1]["entry_id"].ToString())
{
grid.Rows[i]["AuthorName"] = grid.Rows[i - 1]["AuthorName"] + ", " + grid.Rows[i]["AuthorName"];
grid.Rows[i - 1].Delete();
}
}
for (int i = 1; i < grid.Rows.Count; i++)
{
if (grid.Rows[i].RowState != DataRowState.Deleted && username != grid.Rows[i]["taken_by"].ToString())
{
grid.Rows[i].Delete();
}
}
grid.Columns.Remove("entry_id");
grid.Columns.Remove("BooksLeft");
grid.Columns["book_id"].SetOrdinal(0);
return(grid);
}
public DAL.DataSet1.gridDataTable GetData(byte filter = 0)
{
//gridTableAdapter gridAdapter = new gridTableAdapter();
DAL.DataSet1.gridDataTable grid = Adapter.GetData();
for (int i = 1; i < grid.Rows.Count; i++)
{
if (grid.Rows[i]["title"].ToString() == grid.Rows[i - 1]["title"].ToString())
{
grid.Rows[i]["AuthorName"] = grid.Rows[i - 1]["AuthorName"] + ", " + grid.Rows[i]["AuthorName"];
grid.Rows[i - 1].Delete();
}
}
if (filter == 1)
{
for (int i = 0; i < grid.Rows.Count; i++)
{
if (grid.Rows[i].RowState != DataRowState.Deleted && Convert.ToByte(grid.Rows[i]["BooksLeft"]) == 0)
{
grid.Rows[i].Delete();
}
}
}
grid.Columns["book_id"].SetOrdinal(0);
return(grid); //Adapter.GetData();
}
