public static List <Comment> get_comments_of_active_user() //kullanıcının yaptığı yorumlar { using (SQLiteConnection connection_sqlite = new SQLiteConnection(sqlitedb_connstr)) { string sql_string = ""; //default (hata olması durumu) if lere girip değişicek. if (Customer.activeCustomer != 0) { sql_string = $"SELECT * FROM Comment WHERE customerComment = '{Customer.activeCustomer}' "; } if (Seller.activeSeller != 0) { sql_string = $"SELECT * FROM Comment WHERE sellerComment = '{Seller.activeSeller}' "; } using (SQLiteCommand command_sqlite = new SQLiteCommand(sql_string, connection_sqlite)) { List <Comment> allComments = new List <Comment>(); try { command_sqlite.Connection.Open(); using (SQLiteDataReader dataReader = command_sqlite.ExecuteReader()) { while (dataReader.Read()) { Comment comment = new Comment(); comment.SetId(Convert.ToInt32(dataReader["id"])); comment.SetText(dataReader["text"].ToString()); comment.SetCreateTime(Convert.ToDateTime(dataReader["create_date"])); comment.SetCustomer(DbCustomer.get_customer_from_id(Convert.ToInt32(dataReader["customerComment"]))); comment.SetSeller(DbSeller.get_seller_data_from_id(Convert.ToInt32(dataReader["sellerComment"]))); comment.SetProduct(DbProduct.get_product_from_id(Convert.ToInt32(dataReader["product"]))); allComments.Add(comment); //listeye eklendi } } } catch (SQLiteException exception) { MessageBox.Show(exception.Message); } return(allComments); } } }
public static List <Comment> comments_of_product(int selected_product_id) //bir ürünün yorumlarını list şeklinde return ediyoruz { using (SQLiteConnection connection_sqlite = new SQLiteConnection(sqlitedb_connstr)) { string sql_string = $"SELECT * FROM Comment WHERE product = '{selected_product_id}'"; //seçili ürünün yorumları using (SQLiteCommand command_sqlite = new SQLiteCommand(sql_string, connection_sqlite)) { List <Comment> allComments = new List <Comment>(); try { command_sqlite.Connection.Open(); using (SQLiteDataReader dataReader = command_sqlite.ExecuteReader()) { while (dataReader.Read()) { Comment comment = new Comment(); comment.SetId(Convert.ToInt32(dataReader["id"])); comment.SetText(dataReader["text"].ToString()); comment.SetCreateTime(Convert.ToDateTime(dataReader["create_date"])); comment.SetCustomer(DbCustomer.get_customer_from_id(Convert.ToInt32(dataReader["customerComment"]))); comment.SetSeller(DbSeller.get_seller_data_from_id(Convert.ToInt32(dataReader["sellerComment"]))); comment.SetProduct(DbProduct.get_product_from_id(Convert.ToInt32(dataReader["product"]))); allComments.Add(comment); //listeye eklendi } } } catch (SQLiteException exception) { MessageBox.Show(exception.Message); } return(allComments); } } }