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