Exemple #1
0
        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);
                }
            }
        }
Exemple #2
0
        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);
                }
            }
        }