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