protected void Btn_SubmitReview_Click(object sender, EventArgs e)
{
UserRating ur = new UserRating();
ur = new UserRating();
int result = ur.CreateReview(Lbl_Name.Text, Ddl_Tp.SelectedItem.Value, Tb_Feedback.Value, Rating1.CurrentRating.ToString());
if (result == 1)
{
Lbl_Msg.Text = "Thank you for your feedback";
Validation.CssClass = "alert alert-dismissable alert-success";
Lbl_Msg.ForeColor = Color.Green;
}
else
{
Lbl_Msg.Text = "Error in adding record! Inform System Administrator!";
Lbl_Msg.ForeColor = Color.Red;
}
// insert avg
int Total = 0;
string connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(connStr);
myConn.Open();
SqlCommand cmd = new SqlCommand("SELECT rating FROM UserRating", myConn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Total += Convert.ToInt32(dt.Rows[i][0].ToString());
}
int Average = Total / (dt.Rows.Count);
TourPackage tp = new TourPackage();
tp = new TourPackage();
int avg = tp.AverageRating(Ddl_Tp.SelectedItem.Value, Average.ToString());
}
}
