public void Addfeedback(Variablefeedback v, int sid)
{
SqlConnection sqlcon = c.GetConnnect();
SqlCommand cmd = new SqlCommand("insert into feedback values ('" + sid + "','" + v.instructor + "','" + v.venue + "','" + v.Volunteer + "','" + v.hospitality + "','" + v.course + "','" + v.registration + "','" + v.atmosphere + "')", sqlcon);
sqlcon.Open();
cmd.ExecuteNonQuery();
sqlcon.Close();
}
public void course(Variablefeedback v)
{
SqlConnection sqlcon = c.GetConnnect();
sqlcon.Open();
SqlCommand cmd = new SqlCommand(" select AVG (course) from feedback ", sqlcon);
cmd.ExecuteNonQuery();
v.coursesum = Convert.ToDecimal(cmd.ExecuteScalar());
}
public void getavghosp(Variablefeedback v)
{
SqlConnection sqlcon = c.GetConnnect();
sqlcon.Open();
SqlCommand cmd = new SqlCommand(" select AVG (Hospitality) from feedback ", sqlcon);
cmd.ExecuteNonQuery();
v.hospitalitysum = Convert.ToDecimal(cmd.ExecuteScalar());
}
public void getavgvol(Variablefeedback v)
{
SqlConnection sqlcon = c.GetConnnect();
sqlcon.Open();
SqlCommand cmd = new SqlCommand(" select AVG (Volunteer) from feedback ", sqlcon);
cmd.ExecuteNonQuery();
v.volsum = Convert.ToDecimal(cmd.ExecuteScalar());
}
