public ReadersDataObject GetReaderByID(int readerID) { ReadersDataObject reader = null; int rdrID = readerID; using (SqlConnection connection = this.GetConnection()) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "GetReaderDetailsByID"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ReaderID", rdrID); SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { DataRow userRow = ds.Tables[0].Rows[0]; reader = getReaderFromRow(userRow); } } } return reader; }
public IHttpActionResult Get(long deviceId) { try { ReadersDataObject readerDO = dataAccess.GetReaderDetailsByDeviceID(deviceId); if (readerDO == null) { return(NotFound()); } return(Ok(modelFactory.Create(readerDO))); } catch (Exception ex) { return(InternalServerError(ex)); } }
public ReadersModel Create(ReadersDataObject readersDO) { ReadersModel model = new ReadersModel { Url = urlHelper.Link("SupremaReader", new { deviceId = readersDO.DeviceID }), Name = readersDO.Name, Location = readersDO.Location, DefaultReader = readersDO.DefaultReader, Profile = readersDO.Profile, Online = readersDO.Online, DeviceID = readersDO.DeviceID, IPAddress = readersDO.IPAddress }; return(model); }
private ReadersDataObject getReaderFromRow(DataRow userRow) { var reader = new ReadersDataObject(); reader.ID = userRow["Id"] == DBNull.Value ? 0 : Int32.Parse(userRow["Id"].ToString()); System.Diagnostics.Trace.WriteLine(System.String.Format("GetReaderFromRow {0}", reader.ID)); reader.CardFormatCode = userRow["CardFormatCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["CardFormatCode"].ToString()); reader.CardOffset = userRow["CardOffset"] == DBNull.Value ? 0 : Int32.Parse(userRow["CardOffset"].ToString()); reader.CardReadModeCode = userRow["CardReadModeCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["CardReadModeCode"].ToString()); reader.OperationModeCode = userRow["OperationModeCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["OperationModeCode"].ToString()); reader.DefaultReader = userRow["DefaultReader"] == DBNull.Value ? false : Convert.ToBoolean(userRow["DefaultReader"].ToString()); reader.DeviceHandle = userRow["DeviceHandle"] == DBNull.Value ? 0 : Int32.Parse(userRow["DeviceHandle"].ToString()); reader.DeviceID = userRow["DeviceID"] == DBNull.Value ? 0 : Int64.Parse(userRow["DeviceID"].ToString()); reader.DHCP = userRow["DHCP"] == DBNull.Value ? false : Convert.ToBoolean(userRow["DHCP"].ToString()); reader.FacilityCode = userRow["FacilityCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["FacilityCode"].ToString()); reader.FailCode = userRow["FailCode"] == DBNull.Value ? "" : userRow["FailCode"].ToString(); reader.FirmwareVersion = userRow["FirmwareVersion"] == DBNull.Value ? "" : userRow["FirmwareVersion"].ToString(); reader.Gateway = userRow["Gateway"] == DBNull.Value ? "" : userRow["Gateway"].ToString(); reader.IPAddress = userRow["IPAddress"] == DBNull.Value ? "" : userRow["IPAddress"].ToString(); reader.KernelVersion = userRow["KernelVersion"] == DBNull.Value ? "" : userRow["KernelVersion"].ToString(); reader.ProductName = userRow["ProductName"] == DBNull.Value ? "" : userRow["ProductName"].ToString(); reader.Location = userRow["Location"] == DBNull.Value ? "" : userRow["Location"].ToString(); reader.Name = userRow["ReaderName"] == DBNull.Value ? "" : userRow["ReaderName"].ToString(); reader.Online = userRow["Online"] == DBNull.Value ? false : Convert.ToBoolean(userRow["Online"].ToString()); reader.ProfileCode = userRow["ProfileCode"] == DBNull.Value ? -1 : Int32.Parse(userRow["ProfileCode"].ToString()); reader.ServerIPAddress = userRow["ServerIPAddress"] == DBNull.Value ? "" : userRow["ServerIPAddress"].ToString(); reader.ServerPort = userRow["Port"] == DBNull.Value ? 0 : Int32.Parse(userRow["Port"].ToString()); reader.Subnet = userRow["Subnet"] == DBNull.Value ? "" : userRow["Subnet"].ToString(); reader.TemplateTypeCode = userRow["TemplateTypeCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["TemplateTypeCode"].ToString()); reader.TimeSync = userRow["TimeSync"] == DBNull.Value ? false : Convert.ToBoolean(userRow["TimeSync"].ToString()); reader.LastSync = userRow["LastSync"] == DBNull.Value ? new DateTime(1970, 1, 1) : Convert.ToDateTime(userRow["LastSync"].ToString()); reader.UpdatedAt = userRow["UpdatedAt"] == DBNull.Value ? new DateTime(1970, 1, 1) : Convert.ToDateTime(userRow["UpdatedAt"].ToString()); reader.TypeCode = userRow["DeviceType"] == DBNull.Value ? 0 : Int32.Parse(userRow["DeviceType"].ToString()); reader.UseServerMatching = userRow["UseServerMatching"] == DBNull.Value ? false : Convert.ToBoolean(userRow["UseServerMatching"].ToString()); reader.UseServerMode = userRow["UseServerMode"] == DBNull.Value ? false : Convert.ToBoolean(userRow["UseServerMode"].ToString()); reader.WiegandOutputCode = userRow["WiegandOutputCode"] == DBNull.Value ? 0 : Int32.Parse(userRow["WiegandOutputCode"].ToString()); reader.WiegandPassthrough = userRow["WiegandPassthrough"] == DBNull.Value ? false : Convert.ToBoolean(userRow["WiegandPassthrough"].ToString()); return reader; }
public static BiometricReader FromDataObjectToReaderEntity(ReadersDataObject readerDataObject) { BiometricReader reader = new BiometricReader(); reader.Id = readerDataObject.ID; reader.DeviceTypeCode = (int)readerDataObject.TypeCode; reader.IpAddress = readerDataObject.IPAddress; reader.ReaderName = readerDataObject.Name; reader.ServerIpAddress = readerDataObject.ServerIPAddress; reader.Port = readerDataObject.ServerPort; reader.Location = readerDataObject.Location; reader.DefaultReader = readerDataObject.DefaultReader; reader.CardOffset = readerDataObject.CardOffset; reader.FacilityCode = readerDataObject.FacilityCode; reader.WiegandPassthrough = readerDataObject.WiegandPassthrough; reader.Online = readerDataObject.Online; reader.DeviceHandle = readerDataObject.DeviceHandle; reader.ProfileCode = readerDataObject.ProfileCode == null ? 0 : (int)readerDataObject.ProfileCode; //Removed BS_CONSTANTS.BS_Custom Profile code reader.FirmwareVersion = readerDataObject.FirmwareVersion; reader.KernelVersion = readerDataObject.KernelVersion; reader.TemplateTypeCode = readerDataObject.TemplateTypeCode == null ? 0 : (int)readerDataObject.TemplateTypeCode; reader.Gateway = readerDataObject.Gateway; reader.Subnet = readerDataObject.Subnet; reader.UseServerMode = readerDataObject.UseServerMode; reader.UseServerMatching = readerDataObject.UseServerMatching; reader.TimeSync = readerDataObject.TimeSync; reader.CardFormatCode = (int)(readerDataObject.CardFormatCode == null ? 0 : readerDataObject.CardFormatCode); //Corp1000 code from BS_Constants reader.WiegandOutputCode = readerDataObject.WiegandOutputCode == null ? 0 : (int)readerDataObject.WiegandOutputCode; reader.FailCode = readerDataObject.FailCode; reader.CardReadModeCode = (int)(readerDataObject.CardReadModeCode == null ? 0 : readerDataObject.CardReadModeCode); //readerDataObject.CardReadMode= reader.OperationModeCode = (int)(readerDataObject.OperationModeCode == null ? 0 : readerDataObject.OperationModeCode); reader.DHCP = readerDataObject.DHCP; reader.DeviceId = readerDataObject.DeviceID; reader.TimeZone = new TimeSpan(readerDataObject.TimeZone); return(reader); }