public static void Add(HostConfigurationEntity item) { string cons = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); StringBuilder query = new StringBuilder(@"INSERT INTO dbo.t_Host_Configuration ( Host , Threshold , Period, [ZoneTableId] ) VALUES ( @host , @threshold , @period, @zoneTableId )"); using (SqlConnection conn = new SqlConnection(cons)) { SqlCommand cmd = new SqlCommand(query.ToString(), conn); cmd.Parameters.AddWithValue("@host", item.Host); cmd.Parameters.AddWithValue("@threshold", item.Threshold); cmd.Parameters.AddWithValue("@period", item.Period); cmd.Parameters.AddWithValue("@zoneTableId", item.ZoneTableId); conn.Open(); cmd.ExecuteNonQuery(); } }
public static HostConfigurationEntity GetHostConfiguration(int id) { string cons = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); HostConfigurationEntity result = new HostConfigurationEntity(); StringBuilder query = new StringBuilder(@"SELECT [Host], [Threshold], [Period], [Id], [ZoneTableId] from [t_Host_Configuration] WHERE [Id] = @id"); using (SqlConnection conn = new SqlConnection(cons)) { SqlCommand cmd = new SqlCommand(query.ToString(), conn); cmd.Parameters.AddWithValue("@id", id); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { result = new HostConfigurationEntity(); result.Host = Convert.ToString(reader["Host"]); result.Period = Convert.ToInt32(reader["Period"]); result.Threshold = Convert.ToInt32(reader["Threshold"]); result.TableID = Convert.ToInt32(reader["Id"]); result.ZoneTableId = Convert.ToInt32(reader["ZoneTableId"]); } } } return(result); }
public static List <HostConfigurationEntity> GetList(string host) { string cons = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); List <HostConfigurationEntity> result = new List <HostConfigurationEntity>(); StringBuilder query = new StringBuilder(@"SELECT [Host], [Threshold], [Period], [Id], [ZoneTableId] FROM [t_Host_Configuration] "); StringBuilder where = new StringBuilder(); if (!string.IsNullOrWhiteSpace(host)) { where.Append(" Host LIKE'%'+@host+'%' "); } if (where.Length > 0) { query.AppendFormat(" WHERE {0}", where.ToString()); } using (SqlConnection conn = new SqlConnection(cons)) { SqlCommand cmd = new SqlCommand(query.ToString(), conn); if (!string.IsNullOrWhiteSpace(host)) { cmd.Parameters.AddWithValue("@host", host); } conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { int index = 1; while (reader.Read()) { HostConfigurationEntity item = new HostConfigurationEntity(); item.ID = index++; item.Host = Convert.ToString(reader["Host"]); item.Period = Convert.ToInt32(reader["Period"]); item.Threshold = Convert.ToInt32(reader["Threshold"]); item.TableID = Convert.ToInt32(reader["Id"]); item.ZoneTableId = Convert.ToInt32(reader["ZoneTableId"]); result.Add(item); } } } return(result); }
public static void Edit(HostConfigurationEntity item) { string cons = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); StringBuilder query = new StringBuilder(@"UPDATE dbo.t_Host_Configuration SET Host=@host, Threshold=@threshold, Period=@period, [ZoneTableId]=@zoneTableId WHERE Id=@id"); using (SqlConnection conn = new SqlConnection(cons)) { SqlCommand cmd = new SqlCommand(query.ToString(), conn); cmd.Parameters.AddWithValue("@host", item.Host); cmd.Parameters.AddWithValue("@threshold", item.Threshold); cmd.Parameters.AddWithValue("@period", item.Period); cmd.Parameters.AddWithValue("@id", item.TableID); cmd.Parameters.AddWithValue("@zoneTableId", item.TableID); conn.Open(); cmd.ExecuteNonQuery(); } }
public static void Edit(HostConfigurationEntity item) { HostConfigurationAccess.Edit(item); }
public static void Add(HostConfigurationEntity item) { HostConfigurationAccess.Add(item); }