public ReadersModel Create(ReadersStubDataObject readersStubDO)
{
ReadersModel model = new ReadersModel
{
Url = urlHelper.Link("SupremaReader", new { deviceId = readersStubDO.DeviceID }),
Name = readersStubDO.Name,
Location = readersStubDO.Location,
DefaultReader = readersStubDO.DefaultReader,
Profile = readersStubDO.Profile,
Online = readersStubDO.Online,
DeviceID = readersStubDO.DeviceID,
IPAddress = readersStubDO.IPAddress
};
return(model);
}
public List<ReadersStubDataObject> GetReadersStubs(string filterStr)
{
string strSQL = "Select Id, ReaderName, Location, DefaultReader,Online,DeviceID,IPAddress from [dbo].BiometricReader";
if (!string.IsNullOrEmpty(filterStr))
{
strSQL += string.Format(@" WHERE ReaderName LIKE '%{0}%' OR Location LIKE '%{0}%'", filterStr.Trim());
}
var list = new List<ReadersStubDataObject>();
using (SqlConnection connection = this.GetConnection())
{
connection.Open();
using (var command = new SqlCommand(strSQL, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
int recCount = 0;
while (reader.Read() && !reader.IsClosed)
{
//if (recCount > 1000) break;
recCount++;
var stub = new ReadersStubDataObject();
stub.ID = reader.GetInt32(reader.GetOrdinal("Id"));
stub.Name = reader["ReaderName"] == DBNull.Value ? "" : reader["ReaderName"].ToString();
stub.Location = reader["Location"] == DBNull.Value ? "" : reader["Location"].ToString();
stub.DefaultReader = reader["DefaultReader"] == DBNull.Value ? false : Convert.ToBoolean(reader["DefaultReader"].ToString());
//stub.Profile = reader["ProfileCode"] == DBNull.Value ? -1 : Int32.Parse(reader["ProfileCode"].ToString());
stub.Online = reader["Online"] == DBNull.Value ? false : Convert.ToBoolean(reader["Online"].ToString());
stub.DeviceID = reader["DeviceID"] == DBNull.Value ? 0 : Int64.Parse(reader["DeviceID"].ToString());
stub.IPAddress = reader["IPAddress"] == DBNull.Value ? "" : reader["IPAddress"].ToString();
list.Add(stub);
}
}
}
}
}
return list;
}
