Example #1
0
        public static ArrayList getAllMatHangFromNganhHang(int idNganhHang)
        {
            ArrayList dataList = new ArrayList();

            try
            {
                DataSet dataSet = MatHangDAO.getMatHangFromIdNganhHang(idNganhHang);

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    int    id         = Convert.ToInt32(row["id"]);
                    string tenMatHang = row["tenMatHang"].ToString();
                    //int idNganhHang1 = Convert.ToInt32(row["idNganhHang"]);
                    float   donGian = (float)Convert.ToDouble(row["donGia"]);
                    int     soLuong = Convert.ToInt32(row["soLuong"]);
                    MatHang matHang = new MatHang(id, tenMatHang, idNganhHang, donGian, soLuong);
                    dataList.Insert(0, matHang);
                }
            }
            catch (SqlException e)
            {
            }

            return(dataList);
        }
Example #2
0
        public void getMatHangFromIdNganhHangTest()
        {
            DataSet list = MatHangDAO.getMatHangFromIdNganhHang(20);

            List <MatHang> matHang = new List <MatHang>();

            foreach (DataRow row in list.Tables[0].Rows)
            {
                int    id          = Convert.ToInt32(row["id"]);
                string tenMatHang  = row["tenMatHang"].ToString();
                int    idNganhHang = Convert.ToInt32(row["idNganhHang"]);
                float  donGian     = (float)Convert.ToDouble(row["donGia"]);
                int    soLuong     = Convert.ToInt32(row["soLuong"]);
                matHang.Add(new MatHang(id, tenMatHang, idNganhHang, donGian, soLuong));
            }

            Assert.IsTrue(matHang[0].tenMatHang == "Mì ly");
            Assert.IsTrue(matHang[1].tenMatHang == "Poca");
        }