public List <D_Fsu> GetFsus()
{
var entities = new List <D_Fsu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetFsus, null)) {
while (rdr.Read())
{
var entity = new D_Fsu();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.StaTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.RoomTypeId = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.VendorId = SqlTypeConverter.DBNullStringHandler(rdr["VendorId"]);
entity.VendorName = SqlTypeConverter.DBNullStringHandler(rdr["VendorName"]);
entities.Add(entity);
}
}
return(entities);
}
public List <D_Fsu> GetFsusInRoom(string id)
{
SqlParameter[] parms = { new SqlParameter("@RoomId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <D_Fsu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetFsusInRoom, parms)) {
while (rdr.Read())
{
var entity = new D_Fsu();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.StaTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.RoomTypeId = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.VendorId = SqlTypeConverter.DBNullStringHandler(rdr["VendorId"]);
entity.VendorName = SqlTypeConverter.DBNullStringHandler(rdr["VendorName"]);
entities.Add(entity);
}
}
return(entities);
}
