private void btnSearch_Click(object sender, EventArgs e) { try { if (cmbSearchApp.Text != "Search for apps & games") { tabUserMenu.Visible = true; tabUserMenu.SelectedTab = this.tabSearchResults; tabControl5.SelectTab(tabPage9); adb = new ApplicationDBLayer(); GridSearchResults.DataSource = adb.LoadGrid(cmbSearchApp.Text); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { try { if (con.State == ConnectionState.Closed) { con.Open(); } String x; if (txtFeedback.Text == "Descrbe Your Experience(optional) Upto 100 characters allowed") { x = " "; } else { x = x = txtFeedback.Text; } string query = "select id from Application where name='" + lblAppName.Text + "'"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); string id = ""; int c = 0; while (reader.Read()) { if (reader["id"] != DBNull.Value) { id = reader["id"].ToString(); } c++; } reader.Close(); if (c != 0) { query = "insert into Feedback values(" + id + ",'" + x + "'," + rating + ")"; cmd.CommandText = query; cmd.ExecuteNonQuery(); reader.Close(); query = "select CAST(avg(rating) As dec(3,2)) as 'avg' from Feedback where aid=" + id; cmd.CommandText = query; reader = cmd.ExecuteReader(); string z = "0"; while (reader.Read()) { if (reader["avg"] != DBNull.Value) { z = reader["avg"].ToString(); } } reader.Close(); query = "update Application set rating=" + z + " where id=" + id; cmd.CommandText = query; cmd.ExecuteNonQuery(); MessageBox.Show("Feedback Submitted Successfully"); adb = new ApplicationDBLayer(); lblReviews.Text = adb.LoadReviews(lblAppName.Text).ToString(); adb = new ApplicationDBLayer(); GridSearchResults.DataSource = adb.LoadGrid(""); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }