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