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