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