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