public static TuVanLamDichVuCollection SelectAll()
{
var List = new TuVanLamDichVuCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static TuVanLamDichVuCollection SelectByTvDvId(SqlConnection con, string TVDV_ID)
{
var List = new TuVanLamDichVuCollection();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("TVDV_ID", TVDV_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Select_SelectByTvDvId_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static TuVanLamDichVuCollection SelectByNhanVienTuNgayDenNgay(SqlConnection con, string Username, string TuNgay, string DenNgay)
{
var List = new TuVanLamDichVuCollection();
var obj = new SqlParameter[4];
if (!string.IsNullOrEmpty(Username))
{
obj[0] = new SqlParameter("Username", Username);
}
else
{
obj[0] = new SqlParameter("Username", DBNull.Value);
}
if (!string.IsNullOrEmpty(TuNgay))
{
obj[2] = new SqlParameter("TuNgay", TuNgay);
}
else
{
obj[2] = new SqlParameter("TuNgay", DBNull.Value);
}
if (!string.IsNullOrEmpty(DenNgay))
{
obj[3] = new SqlParameter("DenNgay", DenNgay);
}
else
{
obj[3] = new SqlParameter("DenNgay", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Select_thongKeByNhanVienTheoThang_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
