public DataSet SelectEventReviewByReviewId(BALEventReview obj)
{
DataSet ds = new DataSet();
query = "select * from eventreview er inner join event e on er.eventid=e.eventid where er.eventreviewid=" + obj.EventReviewId;
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void DeleteEventReview(BALEventReview obj)
{
query = "Delete from EventReview where eventreviewid=" + obj.EventReviewId;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdateEventReview(BALEventReview obj)
{
query = "update EventReview set contactname='" + obj.ContactName + "',email='" + obj.Email + "',mobileno='" + obj.MobileNo + "',reviewdetail='" + obj.ReviewDetail + "',reviewdate='" + obj.ReviewDate + "',eventid=" + obj.EventId+" where eventreviewid="+obj.EventReviewId ;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertEventReview(BALEventReview obj)
{
query = "insert into eventreview (contactname,email,mobileno,reviewdetail,reviewdate,eventid) values ('" + obj.ContactName + "','" + obj.Email + "','" + obj.MobileNo + "','" + obj.ReviewDetail + "','" + obj.ReviewDate + "'," + obj.EventId + ")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
