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