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; }