public List <Data_Firewall> SearchFirewall(string Destination, int?ProjectID)
{
string ProjID = (ProjectID == 0) ? string.Empty : ProjectID.ToString();
List <Data_Firewall> Firewalls = new List <Data_Firewall>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Firewall";
cmd.Parameters.AddWithValue("@Destination", Destination);
cmd.Parameters.AddWithValue("@ProjectID", ProjID);
if (sqlConn.State != ConnectionState.Open)
{
sqlConn.Open();
}
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Firewall Firewall = new Data_Firewall()
{
FirewallRequestID = (rdr["FirewallRequestID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["FirewallRequestID"].ToString()),
FirewallRequestDesc = rdr["FirewallRequestDesc"].ToString(),
Destination = rdr["Destination"].ToString(),
Source = rdr["Source"].ToString(),
Port = rdr["Port"].ToString(),
ProjectName = rdr["ProjectName"].ToString(),
};
Firewalls.Add(Firewall);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return(Firewalls);
}
public List<Data_Firewall> SearchFirewall(string Destination, int? ProjectID)
{
string ProjID = (ProjectID == 0) ? string.Empty : ProjectID.ToString();
List<Data_Firewall> Firewalls = new List<Data_Firewall>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Firewall";
cmd.Parameters.AddWithValue("@Destination", Destination);
cmd.Parameters.AddWithValue("@ProjectID", ProjID);
if (sqlConn.State != ConnectionState.Open)
sqlConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Firewall Firewall = new Data_Firewall()
{
FirewallRequestID = (rdr["FirewallRequestID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["FirewallRequestID"].ToString()),
FirewallRequestDesc = rdr["FirewallRequestDesc"].ToString(),
Destination = rdr["Destination"].ToString(),
Source = rdr["Source"].ToString(),
Port = rdr["Port"].ToString(),
ProjectName = rdr["ProjectName"].ToString(),
};
Firewalls.Add(Firewall);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return Firewalls;
}
