public ReaderGroup GetReaderGroup(int groupID)
{
try
{
using (var dbhelper = new DbHelper())
{
// Fetch Reader Group
dbhelper.Command.CommandType = System.Data.CommandType.Text;
dbhelper.Command.CommandText = "SELECT [ReaderGroupID],[ReaderGroupName],[ReaderGroupDescription],[ReaderGroupLocation],[ReaderGroupZone] ,[ReaderDBConnectionString],[ReaderWCFConnectionString] FROM [RF].[ReaderGroup] WHERE [ReaderGroupID] = " + groupID.ToString();
DataSet ds = dbhelper.ExcuteDatset(dbhelper.Command);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
throw new Exception("Reader Group not found for ID " + groupID);
ReaderGroup rdrGrp = DbHelper.DataTableToList<ReaderGroup>(ds.Tables[0]).FirstOrDefault();
// Fetch Readers
dbhelper.Command.CommandType = System.Data.CommandType.Text;
dbhelper.Command.CommandText = "SELECT [ReaderID],[ReaderGroupID],[ReaderTypeID],[ReaderName],[ReaderDescription],[IPAddress],[PortNo],[MACAddress],[AntennaPower],[ReaderPower],[LocationRef],[LocationDescription],[IsDeleted] FROM [RF].[Reader] WHERE [IsDeleted] = 0 AND [ReaderGroupID] = " + groupID.ToString();
DataSet dsReaders = dbhelper.ExcuteDatset(dbhelper.Command);
List<ReaderInfo> readersInfo = DbHelper.DataTableToList<ReaderInfo>(dsReaders.Tables[0]).ToList();
rdrGrp.Readers = readersInfo;
return rdrGrp;
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<ReaderType> GetAllReaderType()
{
try
{
using (var dbhelper = new DbHelper())
{
// Fetch Reader Group
dbhelper.Command.CommandType = System.Data.CommandType.Text;
dbhelper.Command.CommandText = "SELECT [ReaderTypeID],[ReaderTypeName],[ReaderTypeDescriotion],[ReaderTypeBL] FROM [RF].[ReaderType]";
DataSet ds = dbhelper.ExcuteDatset(dbhelper.Command);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
throw new Exception("Reader Type not found");
List<ReaderType> rdrGrpLst = DbHelper.DataTableToList<ReaderType>(ds.Tables[0]).ToList();
return rdrGrpLst;
}
}
catch (Exception ex)
{
throw ex;
}
}
public ResultObject GetReaderByReaderName(string readerName)
{
ResultObject objRes = new ResultObject();
objRes.MethodInfo = "ReaderDA.GetReaderByReaderName ";
try
{
using (var dbhelper = new DbHelper())
{
// Fetch Reader Group
dbhelper.Command.CommandType = System.Data.CommandType.Text;
dbhelper.Command.CommandText = "SELECT [ReaderID],[ReaderGroupID],[ReaderTypeID],[ReaderName],[ReaderDescription],[IPAddress],[PortNo],[MACAddress],[AntennaPower],[ReaderPower],[LocationRef],[LocationDescription],[IsDeleted] FROM [RF].[Reader] WHERE [ReaderName] = '" + readerName + "'";
DataSet dsReaders = dbhelper.ExcuteDatset(dbhelper.Command);
if (dsReaders.Tables.Count == 0 || dsReaders.Tables[0].Rows.Count == 0)
{
//throw new Exception("Reader not found");
objRes.IsSuccess = false;
objRes.ErrorMessage = "Reader not found";
objRes.ErrorMessageInternal = "Empty data table returned by DAL for supplied readerName = " + readerName;
}
List<ReaderInfo> readersInfo = DbHelper.DataTableToList<ReaderInfo>(dsReaders.Tables[0]).ToList();
objRes.IsSuccess = true;
objRes.ResultData["ReaderInfo"] = readersInfo.FirstOrDefault();
}
}
catch (Exception ex)
{
objRes.IsSuccess = false;
objRes.ErrorMessage = "Failed to get ReaderInfo from database on supplied readerName = " + readerName;
objRes.ErrorMessageInternal = "Error : " + ex.ToString();
}
objRes.TimeStampString = DateTime.Now.ToString();
return objRes;
}
