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