public void Delete(Post entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Posts WHERE PostId = @PostId")) { cmd.Parameters.AddWithValue("PostId", entity.PostId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Clothe entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Clothes WHERE ClotheId = @ClotheId")) { cmd.Parameters.AddWithValue("ClotheId", entity.ClotheId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Add(Clothe entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Clothes (Name,UnitPrice) " + "VALUES(@Name,@UnitPrice)")) { cmd.Parameters.AddWithValue("Name", entity.Name); cmd.Parameters.AddWithValue("UnitPrice", entity.UnitPrice); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Clothe entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Clothes set Name = @Name, UnitPrice=@UnitPrice WHERE ClotheId = @ClotheId")) { cmd.Parameters.AddWithValue("@ClotheId", entity.ClotheId); cmd.Parameters.AddWithValue("@Name", entity.Name); cmd.Parameters.AddWithValue("@UnitPrice", entity.UnitPrice); VTYS.SqlExecuteNonQuery(cmd); } }
public void Add(Post entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Posts (Title,Details) " + "VALUES(@Title,@Details)")) { cmd.Parameters.AddWithValue("Title", entity.Title); cmd.Parameters.AddWithValue("Details", entity.Details); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Post entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Posts set Title = @Title, Details=@Details WHERE PostId = @PostId")) { cmd.Parameters.AddWithValue("@PostId", entity.PostId); cmd.Parameters.AddWithValue("@Title", entity.Title); cmd.Parameters.AddWithValue("@Details", entity.Details); VTYS.SqlExecuteNonQuery(cmd); } }
public List <Clothe> GetAll(Expression <Func <Clothe, bool> > filter = null) { List <Clothe> clotheList = new List <Clothe>(); SqlCommand cmd = new SqlCommand("Select * from Clothes"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Clothe clothe = new Clothe { ClotheId = Convert.ToInt32(reader[0]), Name = reader[1].ToString(), UnitPrice = Convert.ToDecimal(reader[2]) }; clotheList.Add(clothe); } return(filter == null ? clotheList : clotheList.Where(filter.Compile()).ToList()); }
public List <Post> GetAll(Expression <Func <Post, bool> > filter = null) { List <Post> 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(filter == null ? postList : postList.Where(filter.Compile()).ToList()); }