public DataSet SelectInquiryById(BALInquiry obj) { DataSet ds = new DataSet(); query = "select * from inquiry i inner join event e on i.eventid=e.eventid where i.inquiryid=" + obj.InquiryId; SqlDataAdapter adp = new SqlDataAdapter(query, con); adp.Fill(ds); return ds; }
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(); }
public void UpdateInquiry(BALInquiry obj) { query = "update inquiry set contactname='" + obj.ContactName + "',email='" + obj.Email + "',mobileno='" + obj.MobileNo + "',inquirycontent='" + obj.InquiryContent + "',inquirydate='" + obj.InquiryDate + "',eventid=" + obj.EventId+" where inquiryid="+obj.InquiryId; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void InsertInquiry(BALInquiry obj) { query = "insert into inquiry(contactname,email,mobileno,inquirycontent,inquirydate,eventid) values('"+obj.ContactName+"','"+obj.Email+"','"+obj.MobileNo+"','"+obj.InquiryContent+"','"+obj.InquiryDate+"',"+obj.EventId+")"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void insertInquiry(BALInquiry obj) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "spInsertInquiry"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@customerid", obj.CustomerID); cmd.Parameters.AddWithValue("@inquirycontent", obj.InquiryContent); cmd.Parameters.AddWithValue("@inquirydate", obj.InquiryDate); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }