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