public HoaDonDichVuInfo HoaDonDichVu_GetItem(int HoaDon_DichVuID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@HoaDon_DichVuID", HoaDon_DichVuID);
SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItem", CommandType.StoredProcedure);
HoaDonDichVuInfo item = null;
while (rd.Read())
{
item = new HoaDonDichVuInfo();
item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString());
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.NgaySuDung = rd["NgaySuDung"].ToString();
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
}
return item;
}
public List<HoaDonDichVuInfo> HoaDonDichVu_GetItems([Optional, DefaultParameterValue(0)] int HoaDon_DichVuID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@HoaDon_DichVuID", HoaDon_DichVuID);
SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItems", CommandType.StoredProcedure);
List<HoaDonDichVuInfo> list = new List<HoaDonDichVuInfo>();
HoaDonDichVuInfo item = null;
while (rd.Read())
{
item = new HoaDonDichVuInfo();
item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString());
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.HoTen = rd["HoTen"].ToString();
item.PhongName = rd["PhongName"].ToString();
item.DichVuName = rd["DichVuName"].ToString();
item.NgaySuDung = rd["NgaySuDung"].ToString();
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
list.Add(item);
}
return list;
}