public void UpdateBusinesInquiry(BALBusinessInquiry obj)
{
query = "update BusinessInquiry set BusinessId=" + obj.BusinessId + ",ContactName='" + obj.ContactName + "',Mobile='" + obj.Mobile + "',Email='" + obj.Email + "',InquiryContent='" + obj.InquiryContent + "',InquiryDate='" + obj.InquiryDate;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertBusinessInquiry(BALBusinessInquiry obj)
{
query = "insert into BusinessInquiry(BusinessId,ContactName,Mobile,Email,InquiryContent,InquiryDate) values(" + obj.BusinessId + ",'" + obj.ContactName + "','" + obj.Mobile + "','" + obj.Email + "','" + obj.InquiryContent + "','" + obj.InquiryDate + "')";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectBusinessInquiryByBusinessID(BALBusinessInquiry obj)
{
query = "select * from BusinessInquiry bi inner join Business b on bi.BusinessId=b.BusinessId where bi.BusinessId="+obj.BusinessId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void DeleteBusinessInquiry(BALBusinessInquiry obj)
{
query = "Delete from BusinessInquiry where BusinessInquiryId=" + obj.BusinessInquiryId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
