public void Delete(Radio entity)
{
using (SqlCommand command =
new SqlCommand("delete from Radios where RadioId=@RadioId "))
{
command.Parameters.AddWithValue("@RadioId", entity.RadioId);
VTYS.SqlExecuteNonQuery(command);
}
}
public void Add(Post entity)
{
using (SqlCommand command = new SqlCommand("insert into Posts (Title,Details) values (@Title,@Details)"))
{
command.Parameters.AddWithValue("@Title", entity.Title);
command.Parameters.AddWithValue("@Details", entity.Details);
VTYS.SqlExecuteNonQuery(command);
}
}
public void Update(Post entity)
{
using (SqlCommand command = new SqlCommand("update Posts set Title=@Title, Details=@Details where PostId=@PostId"))
{
command.Parameters.AddWithValue("@PostId", entity.PostId);
command.Parameters.AddWithValue("@Title", entity.Title);
command.Parameters.AddWithValue("@Details", entity.Details);
VTYS.SqlExecuteNonQuery(command);
}
}
public void Add(Radio entity)
{
using (SqlCommand command =
new SqlCommand("insert into Radios (Name,Frequency,isOnline) values (@Name,@Frequency,@isOnline)"))
{
command.Parameters.AddWithValue("@Name", entity.Name);
command.Parameters.AddWithValue("@Frequency", entity.Frequency);
command.Parameters.AddWithValue("@isOnline", entity.isOnline);
VTYS.SqlExecuteNonQuery(command);
}
}
public void Update(Radio entity)
{
using (SqlCommand command =
new SqlCommand("update Radios set Name=@Name, Frequency=@Frequency, isOnline=@isOnline where RadioId=@RadioId "))
{
command.Parameters.AddWithValue("@RadioId", entity.RadioId);
command.Parameters.AddWithValue("@Name", entity.Name);
command.Parameters.AddWithValue("@Frequency", entity.Frequency);
command.Parameters.AddWithValue("@isOnline", entity.isOnline);
VTYS.SqlExecuteNonQuery(command);
}
}
public List <Post> GetAll(Expression <Func <Post, bool> > filter = null)
{
var postList = new List <Post>();
SqlCommand cmd = new SqlCommand("Select * from Posts");
SqlDataReader reader = VTYS.SqlExecuteReader(cmd);
while (reader.Read())
{
Post post = new Post
{
PostId = Convert.ToInt32(reader[0]),
Title = reader[1].ToString(),
Details = reader[2].ToString()
};
postList.Add(post);
}
return(postList);
}
public List <Radio> GetAll(Expression <Func <Radio, bool> > filter = null)
{
var radioList = new List <Radio>();
SqlCommand cmd = new SqlCommand("Select * from Radios");
SqlDataReader reader = VTYS.SqlExecuteReader(cmd);
while (reader.Read())
{
Radio radio = new Radio
{
RadioId = Convert.ToInt32(reader[0]),
Name = reader[1].ToString(),
Frequency = Convert.ToDouble(reader[2]),
isOnline = (bool)reader[3]
};
radioList.Add(radio);
}
return(radioList);
}