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