void LoadAppData(string AppName) { txtFeedback.Visible = btnSubmit.Visible = false; btnInstall.Visible = true; btnUninstall.Visible = true; adb = new ApplicationDBLayer(); adb.getApplicationData(AppName); lblAppName.Text = AppName; lblDevName.Text = "Developer: " + adb.app.getdevName(); lblRating.Text = adb.app.getRating() + " * "; txtDescription.Text = adb.app.getDescription(); size = Convert.ToDecimal(adb.app.dev.getCapacity()); lblSize.Text = Convert.ToString(adb.app.dev.getCapacity()) + " MB"; lblReviews.Text = adb.LoadReviews(AppName).ToString(); //var loc = lblReviews.Location; //loc.X = lblReviews.Location.X + lblReviews.Text.Length + 10; //lblReviewsText.Location = loc; AdjustLblPosition(lblReviewsText, lblReviews); //AdjustLblPosition(lblDownloadText, lblDownloads); //lblReviewsText.Location.X = lblReviews.Text.Length + lblReviewsText.Location.X; lblOS.Text = adb.app.dev.getOS(); decimal p = adb.app.getPrice(); if ((int)p == 0) { lblPrice.Text = "Free"; lblDollar.Visible = false; } else { lblPrice.Text = adb.app.getPrice().ToString(); lblDollar.Visible = true; } lblDownloads.Text = adb.LoadNoOfDownloads(AppName); AdjustLblPosition(lblDownloadText, lblDownloads); //tabUserMenu.SelectedTab = this.tabPage10; if (adb.CheckInstalled(AppName, pID)) { btnInstall.Visible = false; } else { btnUninstall.Visible = false; } circularProgressBar1.Visible = false; circularProgressBar1.Value = 0; lblReviewsText.Visible = true; }
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); } }