예제 #1
0
        public Transaction GetTransaction(string code)
        {
            SqlConnection conn = connection.GetConnection();

            conn.Open();
            ClientDAO   clientDAO   = new ClientDAO();
            ProductDAO  productDAO  = new ProductDAO();
            DataTable   dt          = new DataTable();
            Transaction transaction = new Transaction();

            try
            {
                string     req = "select * from transactions where code=@code";
                SqlCommand cmd = new SqlCommand(req, conn);
                cmd.Parameters.AddWithValue("@code", code);
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.Fill(dt);
                DataRow row = (from trans in dt.AsEnumerable()
                               where trans.Field <string>("code") == code
                               select trans).First();
                transaction.TransactionDate = row.Field <DateTime>("transactionDate");
                transaction.Code            = row.Field <string>("code");
                transaction.Client          = clientDAO.GetClient(row.Field <string>("clientID"));
                transaction.Product         = productDAO.GetProduct(row.Field <string>("productID"));
            }
            catch (Exception e)
            {
            }
            finally
            {
                conn.Close();
            }
            return(transaction);
        }
예제 #2
0
        public List <Transaction> getTransactionsListByProductID(string productid)
        {
            SqlConnection conn = connection.GetConnection();

            conn.Open();

            DataTable          dt         = new DataTable();
            List <Transaction> list       = null;
            ClientDAO          clientDAO  = new ClientDAO();
            ProductDAO         productDAO = new ProductDAO();

            try
            {
                string     req = "select * from transactions where productID=@productid";
                SqlCommand cmd = new SqlCommand(req, conn);
                cmd.Parameters.AddWithValue("@productid", productid);

                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.Fill(dt);
                dt.AsEnumerable();
                if (dt.Rows.Count != 0)
                {
                    list = new List <Transaction>();

                    foreach (DataRow row in dt.AsEnumerable())
                    {
                        Transaction transaction = new Transaction();
                        transaction.TransactionDate = row.Field <DateTime>("transactionDate");
                        transaction.Code            = row.Field <string>("code");
                        transaction.Client          = clientDAO.GetClient(row.Field <string>("clientID"));
                        transaction.Product         = productDAO.GetProduct(row.Field <string>("productID"));
                        transaction.Quantity        = row.Field <int>("quantity");
                        list.Add(transaction);
                    }
                }
                else
                {
                    throw (new PAS_DE_TRANSACTION_EXCEPTION("The Transactions List Is Currently Empty"));
                }
            }
            catch (Exception e)
            {
            }
            finally
            {
                conn.Close();
            }
            return(list);
        }