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); }
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"); }