public DataSet SelectBusinessKeywordByBusinessID(BALBusinessKeyword obj)
{
query = "select * from BusinessKeyword bk inner join Business b on bk.BusinessId=b.BusinessId inner join Keyword k on bk.KeywordId=k.KeywordId where bk.BusinessId="+obj.BusinessId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void UpdateBusinessKeyword(BALBusinessKeyword obj)
{
query = "update BusinessKeyword set BusinessId=" + obj.BusinessId + ",KeywordId=" + obj.KeywordId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertBusinessKeyword(BALBusinessKeyword obj)
{
query="insert into BusinessKeyword(BusinessId,KeywordId) values("+obj.BusinessId+","+obj.KeywordId + ")";
SqlCommand cmd=new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteBusinessKeyword(BALBusinessKeyword obj)
{
query = "delete from BusinessKeyword where BusinessKeywordId=" + obj.BusinessKeywordId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
