public void UpdateCategory(BALCategory obj) { query = "update Category set CategoryId=" + obj.CategoryId + ",CategoryName='" + obj.CategoryName; SqlCommand cmd = new SqlCommand(query,con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void DeleteCategory(BALCategory obj) { query = "delete from Category where CategoryId=" + obj.CategoryId; SqlCommand cmd = new SqlCommand(query,con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void InsertCategory(BALCategory obj) { query = "insert into Category(categoryname,categoryimage) values ('" + obj.CategoryName + "','" + obj.CategoryImage + "')"; SqlCommand cmd= new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void UpdateCategoryWithoutImage(BALCategory obj) { query = "update Category set categoryname='" + obj.CategoryName + "' where categoryid=" + obj.CategoryId; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public DataSet SelectCategoryByCategoryId(BALCategory obj) { query = "select * from category where categoryid="+obj.CategoryId; DataSet ds = new DataSet(); SqlDataAdapter adp = new SqlDataAdapter(query, con); adp.Fill(ds); return ds; }