//searech
public List <SuDungDVDTO> SearchSDDichVu(string search)
{
List <SuDungDVDTO> list = new List <SuDungDVDTO>();
try
{
DataTable data = DataProvider.Instance.ExecuteQuery("USP_SUDUNGDV_Search @search", new object[] { search });
foreach (DataRow row in data.Rows)
{
SuDungDVDTO sddv = new SuDungDVDTO(row);
list.Add(sddv);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(list);
}
//lấy danh sách
// danh sách sử dụng Dv
public List <SuDungDVDTO> GetAllDSSD()
{
List <SuDungDVDTO> list = new List <SuDungDVDTO>();
try
{
DataTable data = DataProvider.Instance.ExecuteQuery("USP_SUDUNGDV_GetDS");
foreach (DataRow row in data.Rows)
{
SuDungDVDTO sddv = new SuDungDVDTO(row);
list.Add(sddv);
}
}
catch (Exception e)
{
// Do some thing here if error
Console.WriteLine(e);
}
return(list);
}
