public void Fill_User_List(DataTable dt, INFO_COLOR_MODE color_mode)
{
int rows_count = dt.Rows.Count;
// IMPORTANT
if (rows_count == 0)
{
return;
}
for (int i = 0; i < rows_count; i++)
{
int user_id = int.Parse(dt.Rows[i][0].ToString());
if (user_id == 0)
{
continue;
}
string name = dt.Rows[i][1].ToString();
string surname = dt.Rows[i][2].ToString();
string gender = dt.Rows[i][3].ToString();
int age = int.Parse(dt.Rows[i][4].ToString());
string email = dt.Rows[i][5].ToString();
string password = dt.Rows[i][6].ToString();
string date = dt.Rows[i][7].ToString();
int fee = int.Parse(dt.Rows[i][8].ToString());
User user = new User(user_id, name, surname, gender, age, email, password, date, fee);
user.Set_Book(color_mode);
this.Add_User_to_List(user);
}
}
public void Fill_Book_List(DataTable dt, Book_List main_list, Book_List search_list, Book_Tag main_tag, Panel main_panel, INFO_COLOR_MODE color_mode, bool fill_image_list = true)
{
int rows_count = book_count = dt.Rows.Count;
// IMPORTANT
if (rows_count == 0)
{
return;
}
for (int i = 0; i < rows_count; i++)
{
int book_id = int.Parse(dt.Rows[i][0].ToString());
if (book_id == 0)
{
continue;
}
int author_id = int.Parse(dt.Rows[i][1].ToString());
int publisher_id = int.Parse(dt.Rows[i][2].ToString());
int category_id = int.Parse(dt.Rows[i][3].ToString());
int librarian_id = int.Parse(dt.Rows[i][4].ToString());
int shelf_id = int.Parse(dt.Rows[i][5].ToString());
int popularity_id = int.Parse(dt.Rows[i][6].ToString());
string name = dt.Rows[i][7].ToString();
string date = dt.Rows[i][8].ToString();
string description = dt.Rows[i][9].ToString();
int count = int.Parse(dt.Rows[i][10].ToString());
string cover_path = dt.Rows[i][11].ToString();
int popularity_score = int.Parse(dt.Rows[i][12].ToString());
Book book = new Book(book_id, author_id, publisher_id, category_id, librarian_id, shelf_id, name, count, date, description, cover_path, popularity_id, popularity_score);
book.Set_Book(main_list, search_list, main_tag, main_panel, color_mode);
this.Add_Book_to_List(book);
}
if (fill_image_list)
{
Fill_Cover_Image_List();
}
}