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