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);
}
}
public List <Journal> GetAll(Expression <Func <Journal, bool> > filter = null)
{
var journalList = new List <Journal>();
SqlCommand cmd = new SqlCommand("Select * from Journals");
SqlDataReader reader = VTYS.SqlExecuteReader(cmd);
while (reader.Read())
{
Journal journal = new Journal
{
JournalId = Convert.ToInt32(reader[0]),
Name = reader[1].ToString(),
Price = decimal.Parse(reader[3].ToString())
};
journalList.Add(journal);
}
return(journalList);
}
