public void Delete(Journal entity)
{
using (SqlCommand cmd =
new SqlCommand("DELETE FROM Journals where JournalId = @JournalId"))
{
cmd.Parameters.AddWithValue("JournalId", entity.JournalId);
VTYS.SqlExecuteNonQuery(cmd);
}
}
public void Add(Journal entity)
{
SqlCommand cmd = new SqlCommand("INSERT INTO Journals(Name, Price, IsMonthly) VALUE (@Name, @Price,@IsMonthly)");
cmd.Parameters.AddWithValue("@Name", entity.Name);
cmd.Parameters.AddWithValue("@Price", entity.Price);
cmd.Parameters.AddWithValue("@IsMonthly", entity.IsMonthly);
VTYS.SqlExecuteNonQuery(cmd);
}
public void Update(Journal entity)
{
using (SqlCommand cmd =
new SqlCommand("UPDATE Journals set Name = @Name, Price = @Price, IsMonthly = @IsMonthly where JournalId = @JournalId"))
{
cmd.Parameters.AddWithValue("JournalId", entity.JournalId);
cmd.Parameters.AddWithValue("Name", entity.Name);
cmd.Parameters.AddWithValue("Price", entity.Price);
cmd.Parameters.AddWithValue("IsMonthly", entity.IsMonthly);
VTYS.SqlExecuteNonQuery(cmd);
}
}