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