public static void GetExistSequenceNumber(ProtocolNumber item) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("pn_select_exist_protocol_number", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@TemplateID", SqlDbType.Int).Value = item.TemplateID; command.Parameters.Add("@SponsorCode", SqlDbType.NVarChar).Value = item.SponsorCode; command.Parameters.Add("@ProtocolType", SqlDbType.NChar).Value = item.ProtocolType; command.Parameters.Add("@YearNumber", SqlDbType.Int).Value = item.YearNumber; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { item.SequenceNumber = Convert.ToInt32(reader[1].ToString()); } } } } catch (SqlException ex) { ErrorHandler.CreateLogFile(ErrorFormName, "GetExistingProtocolNumber", ex); } }
public static void InsertItem(ProtocolNumber item, string userName) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("pn_insert_protocol_number", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@RequestID", SqlDbType.Int).Value = item.RequestID; command.Parameters.Add("@TemplateID", SqlDbType.Int).Value = item.TemplateID; command.Parameters.Add("@SponsorCode", SqlDbType.NVarChar).Value = item.SponsorCode; command.Parameters.Add("@ProtocolNumber", SqlDbType.NVarChar).Value = item.FullCode; command.Parameters.Add("@YearNumber", SqlDbType.Int).Value = item.YearNumber; command.Parameters.Add("@SequenceNumber", SqlDbType.Int).Value = item.SequenceNumber; command.Parameters.Add("@RevisedNumber", SqlDbType.Int).Value = item.RevisedNumber; command.Parameters.Add("@ProtocolType", SqlDbType.NChar).Value = item.ProtocolType; command.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = userName; int result = command.ExecuteNonQuery(); } } } catch (SqlException ex) { ErrorHandler.CreateLogFile(ErrorFormName, "InsertProtocolNumber", ex); } }
public static void SelectItem(ProtocolNumber item) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("pn_select_protocol_number", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@RequestID", SqlDbType.Int).Value = item.RequestID; command.Parameters.Add("@TemplateID", SqlDbType.Int).Value = item.TemplateID; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { item.FullCode = reader[0].ToString().Trim(); item.YearNumber = Convert.ToInt32(reader[1].ToString()); item.SequenceNumber = Convert.ToInt32(reader[2].ToString()); item.RevisedNumber = Convert.ToInt32(reader[3].ToString()); item.ProtocolType = reader[4].ToString().Trim(); item.IsActive = Convert.ToBoolean(reader[5].ToString()); item.SponsorCode = reader[6].ToString().Trim(); } } } } catch (SqlException ex) { ErrorHandler.CreateLogFile(ErrorFormName, "SetProtocolNumber", ex); } }
public ProtocolNumberUpdateController(IProtocolNumberUpdateView view) { this.view = view; this.view.SetController(this); this.protocolNumber = new ProtocolNumber(); loginInfo = LoginInfo.GetInstance(); auditItems = new List <AuditItem>(); LoadViewByUserRole(); }
public override Location Parse(MessageInput input) { ProtocolNumber protocolNumber = (ProtocolNumber)input.DataMessage.Bytes[3]; Dictionary <ProtocolNumber, Func <MessageInput, Location> > methods = new Dictionary <ProtocolNumber, Func <MessageInput, Location> > { { ProtocolNumber.LoginInformation, LoginInformationHandler }, { ProtocolNumber.StatusInformation, StatusInformationHandler }, { ProtocolNumber.PositioningData, PositioningDataHandler } }; return(methods.ContainsKey(protocolNumber) ? methods[protocolNumber](input) : null); }
public static void Insert_ProtocolNumber_AuditItem(ProtocolNumber protocolNumber, string userName) { AuditItem item = new AuditItem(); item.TableName = "ProtocolNumbers"; item.Type = "I"; item.PK = "RequestID,TemplateID"; item.PKValue = protocolNumber.RequestID + "," + protocolNumber.TemplateID; item.FieldName = "ProtocolNumber"; item.OldValue = "N/A"; item.NewValue = protocolNumber.FullCode; item.UpdatedBy = userName; item.Reason = "Protocol Number button clicked."; InsertAuditItem(item); }
/// <summary> /// Creates a string representation of the IpPacket object. /// </summary> public override string ToString() { var s = new StringBuilder(); s.Append("IP version: "); s.AppendLine(IpVersion.ToString()); s.Append("Internet Header Length "); s.AppendLine(InternetHeaderLength.ToString()); s.Append("DSCP value "); s.AppendLine(DscpValue.ToString()); s.Append("ECN value "); s.AppendLine(ExplicitCongestionNotice.ToString()); s.Append("IP packet length "); s.AppendLine(IpPacketLength.ToString()); s.Append("ID/Fragment Group "); s.AppendLine(FragmentGroupId.ToString()); s.Append("IP header flags "); s.AppendLine(IpHeaderFlags.ToString()); s.Append("Fragment offset "); s.AppendLine(FragmentOffset.ToString()); s.Append("TTL "); s.AppendLine(TimeToLive.ToString()); s.Append("Protocol Number "); s.AppendLine(ProtocolNumber.ToString()); s.Append("Header Checksum "); s.AppendLine(PacketHeaderChecksum.ToString()); s.Append("Source IP "); s.AppendLine(SourceIpAddress.ToString()); s.Append("Destination IP "); s.AppendLine(DestinationIpAddress.ToString()); if (IpOptions != null) { s.Append("Length of IP options "); s.AppendLine(IpOptions.Length.ToString()); } s.Append("Packet Data Length "); s.AppendLine(PacketData.Length.ToString()); s.Append("Size of data buffer processed "); s.AppendLine(DataBuffer.Length.ToString()); return(s.ToString()); }
public override int GetHashCode() { return(StartBits.GetHashCode() * ProtocolNumber.GetHashCode() * packetLength.GetHashCode() * EndBits.GetHashCode() * Router.GetHashCode()); }
public ConcoxOutputMessage(ProtocolNumber protocolNumber, string[] serialNumber) { this.protocolNumber = protocolNumber; this.serialNumber = serialNumber; }