public List <M_Authorization> GetEntities()
{
var entities = new List <M_Authorization>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Authorization_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new M_Authorization();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitTime"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entities.Add(entity);
}
}
return(entities);
}
public List <M_Authorization> GetEntitiesInCard(string card)
{
SqlParameter[] parms = { new SqlParameter("@CardId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(card);
var entities = new List <M_Authorization>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Authorization_Repository_GetEntitiesInCard, parms)) {
while (rdr.Read())
{
var entity = new M_Authorization();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitTime"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entities.Add(entity);
}
}
return(entities);
}
