private void btnAdd_Click(object sender, EventArgs e) { try { string ver = string.Empty; //ver = client.GetVersion(); //MessageBox.Show(ver); TRReaderServiceLib.ReaderInfo rdrInfo = new TRReaderServiceLib.ReaderInfo(); rdrInfo.ReaderName = txtReaderName.Text; rdrInfo.ReaderDescription = txtReaderDesc.Text; rdrInfo.IPAddress = txtIPAddress.Text.Replace(" ", ""); rdrInfo.PortNo = uint.Parse(txtPortNo.Text); rdrInfo.MAC = txtMACAdd.Text; rdrInfo.LocationRef = txtLocRef.Text; rdrInfo.LocationDescription = txtLocDescription.Text; rdrInfo.ReaderGroupId = rdrGroupID; rdrInfo.ReaderTypeId = ((ReaderType) cmbReaderType.SelectedValue).ReaderTypeID; var res = groupObj.AddReader(rdrInfo); if (res.IsSuccess) { this.DialogResult = DialogResult.OK; this.Close(); } else MessageBox.Show("Unable to Add Reader.", "Add Reader", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show("Failed to add reader, you may want to verify IPAddress and Port settings."); } }
public void InitReader(IReaderService readerService, string endpoint, ReaderInfo objReader, int pReadTimeOutInMS = 1000) { rdrServiceEndpoint = endpoint; DisconnectExistingReader(); SetToDefault(); if (objReader == null) { throw new ApplicationException("Please check configuration ! Null RFIDReader object supplied."); } readTimeOutInMS = pReadTimeOutInMS; readerInfo = objReader; if (readerService == null) throw new ApplicationException("Error : supplied object of Reader Service is NULL/Invalid."); readerServiceObj = readerService; SetToDefault(); //string wcfServiceConn = frmMain.frmMainObj.objReaderGrpBO.ReaderGroups[readerInfo.ReaderGroupId].ReaderWCFConnectionString; //client = frmMain.frmMainObj.objReaderGrpBO.InitService(wcfServiceConn); //if (client == null) // throw new ApplicationException("Error : Could not connect to Reader Service on given connection - " + wcfServiceConn); }
public RFIDMotorolaReader(ReaderInfo readerInfo, uint timeOut, int readerPulseInterval_inMins = 15) { try { #region Param Validation if (readerInfo == null) { throw new ArgumentNullException("readerInfo", "Parameter can't be Empty/Null."); } if (string.IsNullOrWhiteSpace(readerInfo.IPAddress)) { throw new ArgumentNullException("readerInfo.IPAddress", "Parameter can;t be Empty/Null."); } #endregion Param Validation mReaderInfo = readerInfo; mTimeOut = timeOut; mReaderPulseInterval_inMins = readerPulseInterval_inMins; } catch (Exception ex) { LoggerAgent.Error("Error in creating instance of reader. ReaderId: " + readerInfo.ReaderId, ex); throw new ApplicationException("Failed to create new instance of reader.", ex); } }
public frmModifyReader(ReaderInfo readerInfo, IReaderService client) { InitializeComponent(); this.client = client; this.readerInfo = readerInfo; FillForm(); }
public ResultObject AddReader(ReaderInfo rdrInfo) { IReaderService rdrClient = InitService(lstReaderGroups[rdrInfo.ReaderGroupId].ReaderWCFConnectionString); if (rdrClient != null) { var res = rdrClient.AddReader(rdrInfo); return res; } return null; }
public ResultObject AddReader(ReaderInfo rdrInfo) { string url = ""; url = System.Configuration.ConfigurationManager.AppSettings["ServiceUrl"].ToString(); IReaderService rdrClient = InitService(url); if (rdrClient != null) { var res = rdrClient.AddReader(rdrInfo); return res; } return null; }
private void btnModify_Click(object sender, EventArgs e) { TRReaderServiceLib.ReaderInfo rdrInfo = new TRReaderServiceLib.ReaderInfo(); rdrInfo.ReaderId = this.readerInfo.ReaderId; rdrInfo.ReaderName = txtReaderName.Text; rdrInfo.ReaderDescription = txtReaderDesc.Text; rdrInfo.IPAddress = txtIPAddress.Text.Replace(" ",""); rdrInfo.PortNo = uint.Parse(txtPortNo.Text); rdrInfo.MAC = txtMACAdd.Text; rdrInfo.LocationRef = txtLocRef.Text; rdrInfo.LocationDescription = txtLocDescription.Text; rdrInfo.ReaderGroupId = this.readerInfo.ReaderGroupId; rdrInfo.ReaderTypeId = this.readerInfo.ReaderTypeId; ResultObject res = client.ModifyReader(rdrInfo); if (res.IsSuccess) { this.DialogResult = DialogResult.OK; this.Close(); } else MessageBox.Show("Unable to Modify Reader.", "Modify Reader", MessageBoxButtons.OK, MessageBoxIcon.Error); }
protected void btnAddZone_Click(object sender, EventArgs e) { string strScript = ""; using (Neophotonics_webDbHelper BAdbHelper = new Neophotonics_webDbHelper()) { //Checkboxselection HH #region //if (rdtypeHH.Checked == true) //{ // if (txtdesc.Text.Length > 0) // { // string id = value.ToString(); // string[] ids = Regex.Split(id, "."); // string desc = txtdesc.ToString(); // string[] wordsdesc = Regex.Split(desc, "\r\n"); // foreach (string strval in wordsdesc) // { // string[] words = Regex.Split(value, "."); // BAdbHelper.AddParameter("@ZoneDescription", SqlDbType.VarChar, txtdesc.Text); // BAdbHelper.AddParameter("@BuildingId", SqlDbType.Int, drpBildingName.SelectedValue); // BAdbHelper.AddParameter("@ReaderId", SqlDbType.Int, ddReader.SelectedValue); // BAdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; // BAdbHelper.Command.CommandText = "SP_Zone_Add"; // } // int i = BAdbHelper.ExecuteNoneQuery(); // Response.Redirect("~/Setup/ZoneView.aspx?RespMsg=Zone Added Successfully", true); // } //} #endregion if (drpBildingName.SelectedItem.Text == "-Select-" ) { strScript = "<script>"; strScript = strScript + "alert('Please select Building.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } if (ddReader.SelectedItem.Text == "-Select-") { strScript = "<script>"; strScript = strScript + "alert('Please select Hardware.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } if (txtdesc.Text == "") { strScript = "<script>"; strScript = strScript + "alert('Please Enter Description.');"; strScript = strScript + "</script>"; ClientScript.RegisterStartupScript(this.GetType(), "clientscript", strScript.ToString()); return; } try { BAdbHelper.AddParameter("@Type", SqlDbType.VarChar, rdtypeRD.Checked); BAdbHelper.AddParameter("@ZoneDescription", SqlDbType.VarChar, txtdesc.Text); BAdbHelper.AddParameter("@BuildingId", SqlDbType.Int, drpBildingName.SelectedValue); BAdbHelper.AddParameter("@ReaderId", SqlDbType.Int, ddReader.SelectedValue); BAdbHelper.Command.CommandType = System.Data.CommandType.StoredProcedure; BAdbHelper.Command.CommandText = "SP_Zone_Add"; DataSet ReaderDataSet = BAdbHelper.ExcuteDatset(BAdbHelper.Command); if (ReaderDataSet.Tables[0].Rows.Count > 0) { foreach (DataRow row in ReaderDataSet.Tables[0].Rows) { TRReaderServiceLib.ReaderInfo rdrInfo = new TRReaderServiceLib.ReaderInfo(); rdrInfo.ReaderName =row["DeviceName"].ToString(); rdrInfo.ReaderDescription = row["DeviceName"].ToString(); rdrInfo.IPAddress = row["DeviceIPAddress"].ToString(); rdrInfo.PortNo = uint.Parse( row["DevicePortNumber"].ToString()); rdrInfo.MAC = row["DeviceMAC"].ToString(); rdrInfo.LocationRef = row["LocationRef"].ToString(); rdrInfo.LocationDescription = row["LocationRef"].ToString(); rdrInfo.ReaderGroupId = int.Parse (row["ReaderGroupID"].ToString()); rdrInfo.ReaderTypeId =int.Parse( row["ReaderTypeID"].ToString()); rdrInfo.AntennaPower = int.Parse(row["AntennaPower"].ToString()); var res = AddReader(rdrInfo); } } } catch (Exception ex) { } Response.Redirect("~/Setup/ZoneView.aspx?RespMsg=Zone Added Successfully", true); } }
public ResultObject AddReader(ReaderInfo objReaderInfo) { lock (objLock) { LoggerAgent.Trace("Entering..."); ResultObject objRes = new ResultObject(); objRes.MethodInfo = "ReaderService.AddReader "; try { // -- Adding reader to DB ---- ReaderDA objReaderDA = new ReaderDA(); objRes = objReaderDA.AddReader(objReaderInfo); if (objRes.IsSuccess == false) { return objRes; } // --- Connecting to actual reader --- RFIDMotorolaReader rdrObject = null; try { rdrObject = new RFIDMotorolaReader(objReaderInfo, 1000, readerPulseMonitor_InMin); objRes.IsSuccess = rdrObject.Connect(pollCycle, true); } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Unable to connect to Reader. IP Address " + objReaderInfo.IPAddress; objRes.ErrorMessageInternal = "Error : " + ex.ToString(); } //Reader-Service collection will cache actual reader. dicReaders[objReaderInfo.ReaderId] = rdrObject; //Set result object: - /*set online status*/ objReaderInfo.IsOnline = objRes.IsSuccess; //Set readerInfo in result object // NOTE: ReaderId key is already SET by DAL call. // objRes.ResultData["ReaderInfo"] = objReaderInfo; objRes.MethodInfo = "ReaderService.AddReader "; objRes.TimeStampString = DateTime.Now.ToString(); LoggerAgent.Debug("Reader status: " + " Reader IP:Port = " + rdrObject.ReaderInfo.IPAddress + ":" + rdrObject.ReaderInfo.PortNo.ToString() + ", IsOnline = " + rdrObject.ReaderInfo.IsOnline.ToString() ); } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Unable to Add Reader. IP Address " + objReaderInfo.IPAddress; objRes.ErrorMessageInternal = "Error : " + ex.ToString(); LoggerAgent.Error("Error : Failed to AddReader. " + objRes.ErrorMessage, ex); } finally { LoggerAgent.Trace("Leaving..."); } LoggerAgent.Info("Result status = " + ResultObject.GetLogString(objRes)); return objRes; } }
public ResultObject ReconnectReader(ReaderInfo objReaderInfo) { LoggerAgent.Trace("Entering..."); ResultObject objRes = new ResultObject(); objRes.MethodInfo = "ReaderService.ReconnectReader "; try { //param validation if (objReaderInfo == null) { objRes.IsSuccess = false; objRes.ErrorMessage = "ReconnectReader Error : Invalid ReaderInfo object supplied."; objRes.ErrorMessageInternal = string.Empty; objRes.TimeStampString = DateTime.Now.ToString(); return objRes; } if (objReaderInfo.ReaderId <= 0) { objRes.IsSuccess = false; objRes.ErrorMessage = "ReconnectReader Error : ReaderId is invalid. Invalid ReaderInfo object supplied."; objRes.ErrorMessageInternal = string.Empty; objRes.TimeStampString = DateTime.Now.ToString(); return objRes; } var reader = dicReaders[objReaderInfo.ReaderId]; reader.Reconnect(pollCycle, true); objRes.IsSuccess = true; } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Failed to ReconnectReader " + objReaderInfo.ReaderId.ToString(); objRes.ErrorMessageInternal = "Error : " + ex.ToString(); LoggerAgent.Error("Error in Reconnecting reader, ReaderId = " + objReaderInfo.ReaderId.ToString(), ex); } objRes.TimeStampString = DateTime.Now.ToString(); //reset the methodinfo objRes.MethodInfo = "ReaderService.ReconnectReader "; LoggerAgent.Info("Result status = " + ResultObject.GetLogString(objRes)); LoggerAgent.Trace("Leaving..."); return objRes; }
public ResultObject ModifyReader(ReaderInfo objReaderInfo) { ResultObject objRes = new ResultObject(); objRes.MethodInfo = "ReaderService.ModifyReader "; try { //param validation if (objReaderInfo == null) { objRes.IsSuccess = false; objRes.ErrorMessage = "ModifyReader Error : Invalid ReaderInfo object supplied."; objRes.ErrorMessageInternal = string.Empty; objRes.TimeStampString = DateTime.Now.ToString(); return objRes; } if (objReaderInfo.ReaderId <= 0) { objRes.IsSuccess = false; objRes.ErrorMessage = "ModifyReader Error : ReaderId is invalid. Invalid ReaderInfo object supplied."; objRes.ErrorMessageInternal = string.Empty; objRes.TimeStampString = DateTime.Now.ToString(); return objRes; } ReaderDA objReaderDA = new ReaderDA(); objRes = objReaderDA.ModifyReader(objReaderInfo); } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Failed to modify reader " + objReaderInfo.ReaderId.ToString(); objRes.ErrorMessageInternal = "Error : " + ex.ToString(); } objRes.TimeStampString = DateTime.Now.ToString(); //reset the methodinfo objRes.MethodInfo = "ReaderService.ModifyReader "; LoggerAgent.Info("Result status = " + ResultObject.GetLogString(objRes)); LoggerAgent.Trace("Leaving..."); return objRes; }
public ResultObject AddReader(ReaderInfo readerInfo) { ResultObject objRes = new ResultObject(); objRes.MethodInfo = " ReaderDA.AddReader "; string insertSql = "INSERT INTO [RF].[Reader] " + " ([ReaderGroupID] " + ", [ReaderTypeID] " + ", [ReaderName] " + ", [ReaderDescription] " + ", [IPAddress] " + ", [PortNo] " + ", [MACAddress] " + ", [AntennaPower] " + ", [ReaderPower] " + ", [LocationRef] " + ", [LocationDescription] " + ", [IsDeleted] " + ", [CreateDateTime] " + ", [UpdateDateTime] ) " + " VALUES " + "(@ReaderGroupID " + ", @ReaderTypeID " + ", @ReaderName " + ", @ReaderDescription " + ", @IPAddress " + ", @PortNo " + ", @MACAddress " + ", @AntennaPower " + ", @ReaderPower " + ", @LocationRef " + ", @LocationDescription " + ", @IsDeleted " + ", @CreateDateTime " + ", @UpdateDateTime ); "; try { using (var dbhelper = new DbHelper()) { // Fetch Reader Group dbhelper.Command.CommandType = System.Data.CommandType.Text; dbhelper.Command.CommandText = insertSql; dbhelper.AddParameter("@ReaderGroupID", SqlDbType.Int, readerInfo.ReaderGroupId); dbhelper.AddParameter("@ReaderTypeID", SqlDbType.Int, readerInfo.ReaderTypeId); dbhelper.AddParameter("@ReaderName", SqlDbType.NVarChar, readerInfo.ReaderName); dbhelper.AddParameter("@ReaderDescription", SqlDbType.NVarChar, readerInfo.ReaderDescription); dbhelper.AddParameter("@IPAddress", SqlDbType.NVarChar, readerInfo.IPAddress); dbhelper.AddParameter("@PortNo", SqlDbType.Int, readerInfo.PortNo); dbhelper.AddParameter("@MACAddress", SqlDbType.VarChar, readerInfo.MAC == null ? " " : readerInfo.MAC); dbhelper.AddParameter("@AntennaPower", SqlDbType.VarChar, (float)readerInfo.AntennaPower); dbhelper.AddParameter("@ReaderPower", SqlDbType.Float, (float)1.0); // readerInfo.AntennaPower); dbhelper.AddParameter("@LocationRef", SqlDbType.NVarChar, readerInfo.LocationRef); dbhelper.AddParameter("@LocationDescription", SqlDbType.NVarChar, readerInfo.LocationDescription); dbhelper.AddParameter("@IsDeleted", SqlDbType.Bit, 0); dbhelper.AddParameter("@CreateDateTime", SqlDbType.DateTime, DateTime.Now); dbhelper.AddParameter("@UpdateDateTime", SqlDbType.DateTime, DateTime.Now); int i = dbhelper.ExecuteNoneQuery(); objRes.IsSuccess = true; } } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Failed to add reader into database"; objRes.ErrorMessageInternal = " Error : " + ex.ToString(); } //try to return readerId for newly added reader ResultObject internalResultObject = new ResultObject(); internalResultObject = GetReaderByReaderName(readerInfo.ReaderName); //Assign readerId to main result object with key "ReaderId" objRes.ResultData["ReaderId"] = internalResultObject.IsSuccess ? ((ReaderInfo)internalResultObject.ResultData["ReaderInfo"]).ReaderId : -1 /*OnError reader is -1*/; readerInfo.ReaderId = internalResultObject.IsSuccess ? ((ReaderInfo)internalResultObject.ResultData["ReaderInfo"]).ReaderId : -1 /*OnError reader is -1*/; objRes.ResultData["ReaderInsertSql"] = insertSql; objRes.TimeStampString = DateTime.Now.ToString(); return objRes; }
public ResultObject ModifyReader(ReaderInfo readerInfo, bool isdeleted = false) { ResultObject objRes = new ResultObject(); objRes.MethodInfo = " ReaderDA.ModifyReader "; try { using (var dbhelper = new DbHelper()) { // Fetch Reader Group dbhelper.Command.CommandType = System.Data.CommandType.Text; dbhelper.Command.CommandText = "UPDATE [RF].[Reader] " + "SET [ReaderGroupID] = @ReaderGroupID " + ", [ReaderTypeID] = @ReaderTypeID " + ", [ReaderName] = @ReaderName " + ", [ReaderDescription] = @ReaderDescription " + ", [IPAddress] = @IPAddress " + ", [PortNo] = @PortNo " + ", [MACAddress] = @MACAddress " + ", [AntennaPower] = @AntennaPower " + ", [ReaderPower] = @ReaderPower " + ", [LocationRef] = @LocationRef " + ", [LocationDescription] = @LocationDescription " + ", [IsDeleted] = @IsDeleted " + ", [UpdateDateTime] = @UpdateDateTime " + " WHERE ReaderID = @ReaderID ;"; dbhelper.AddParameter("@ReaderGroupID", SqlDbType.Int, readerInfo.ReaderGroupId); dbhelper.AddParameter("@ReaderTypeID", SqlDbType.Int, readerInfo.ReaderTypeId); dbhelper.AddParameter("@ReaderName", SqlDbType.NVarChar, readerInfo.ReaderName); dbhelper.AddParameter("@ReaderDescription", SqlDbType.NVarChar, readerInfo.ReaderDescription); dbhelper.AddParameter("@IPAddress", SqlDbType.NVarChar, readerInfo.IPAddress); dbhelper.AddParameter("@PortNo", SqlDbType.Int, readerInfo.PortNo); dbhelper.AddParameter("@MACAddress", SqlDbType.VarChar, readerInfo.MAC == null ? " " : readerInfo.MAC); dbhelper.AddParameter("@AntennaPower", SqlDbType.VarChar, (float)readerInfo.AntennaPower); dbhelper.AddParameter("@ReaderPower", SqlDbType.Float, readerInfo.AntennaPower); dbhelper.AddParameter("@LocationRef", SqlDbType.NVarChar, readerInfo.LocationRef); dbhelper.AddParameter("@LocationDescription", SqlDbType.NVarChar, readerInfo.LocationDescription); dbhelper.AddParameter("@IsDeleted", SqlDbType.Bit, isdeleted ? 1 : 0); dbhelper.AddParameter("@UpdateDateTime", SqlDbType.DateTime, DateTime.Now); dbhelper.AddParameter("@ReaderID", SqlDbType.Int, readerInfo.ReaderId); int i = dbhelper.ExecuteNoneQuery(); objRes.IsSuccess = true; objRes.ResultData["ReaderId"] = readerInfo.ReaderId; //objRes.ResultData["ReaderInfo"] = readerInfo; } } catch (Exception ex) { objRes.IsSuccess = false; objRes.ErrorMessage = "Failed to modify reader into database"; objRes.ErrorMessageInternal = " Error : " + ex.ToString(); } objRes.TimeStampString = DateTime.Now.ToString(); return objRes; }