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