public void InsertInquiry(BalInquiry obj)
{
query = "insert into Inquiry(CityId,InquiryContent,InquiryDate,KeywordId,ContactName,Mobile,Email) values (" + obj.CityId + ",'" + obj.InquiryContent + "','" + obj.InquiryDate + "'," + obj.KeywordID + ",'" + obj.ContactName + "','" + obj.Mobile + "','" + obj.Email + "')";
SqlCommand cmd=new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateInquiry(BalInquiry obj)
{
query="update Inquiry set CityId="+obj.CityId+",InquiryContent='"+obj.InquiryContent+"',InquiryDate='"+obj.InquiryDate+"',KeywordId="+obj.KeywordID+",ContactName='"+obj.ContactName+"',Mobile='"+obj.Mobile+"',Email='"+obj.Email+" where InquiryId="+obj.InquiryId ;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteInquiry(BalInquiry obj)
{
query = "delete from Inquiry where InquiryId="+obj.InquiryId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
