public IList<CY.HotelBooking.Core.Business.Web_Module> GetAll()
{
IList<CY.HotelBooking.Core.Business.Web_Module> listAllModule = new List<CY.HotelBooking.Core.Business.Web_Module>();
SqlServerUtility sqlhelper = new SqlServerUtility();
SqlDataReader reader = sqlhelper.ExecuteSqlReader(strSQLAll.ToString());
if (reader != null && !reader.IsClosed)
{
while (reader.Read())
{
CY.HotelBooking.Core.Business.Web_Module module = new CY.HotelBooking.Core.Business.Web_Module();
if (!reader.IsDBNull(0)) { module.Id = reader.GetInt32(0); }
if (!reader.IsDBNull(1)) { module.Module_Code = reader.GetString(1); }
if (!reader.IsDBNull(2)) { module.Module_Name = reader.GetString(2); }
if (!reader.IsDBNull(3)) { module.Module_IsParent = reader.GetInt32(3); }
listAllModule.Add(module);
}
reader.Close();
return listAllModule;
}
return null;
}
public CY.HotelBooking.Core.Business.Web_Module Load(string modulecode)
{
SqlServerUtility sqlhelper = new SqlServerUtility();
sqlhelper.AddParameter("@Module_Code", SqlDbType.VarChar, modulecode, 10);
SqlDataReader reader = sqlhelper.ExecuteSqlReader(strSQLSelectByCode.ToString());
if (reader != null && !reader.IsClosed)
{
if (reader.Read())
{
CY.HotelBooking.Core.Business.Web_Module module = new CY.HotelBooking.Core.Business.Web_Module();
if (!reader.IsDBNull(0)) { module.Id = reader.GetInt32(0); }
if (!reader.IsDBNull(1)) { module.Module_Code = reader.GetString(1); }
if (!reader.IsDBNull(2)) { module.Module_Name = reader.GetString(2); }
if (!reader.IsDBNull(3)) { module.Module_IsParent = reader.GetInt32(3); }
reader.Close();
return module;
}
reader.Close();
}
return null;
}
