void LoadSearchBox()
{
try
{
adb = new ApplicationDBLayer();
adb.LoadSearchBox(cmbSearchApp);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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 btnInstall_Click(object sender, EventArgs e)
{
try
{
cdb = new CustomerDBLayer();
if (lblPrice.Text == "Free")
{
decimal size1 = size / 2;
if (cdb.InstallApp(lblAppName.Text, pID))
{
circularProgressBar1.Visible = true;
for (int i = 0; i < 100; i++)
{
int a = (int)size1 / 100;
System.Threading.Thread.Sleep(a * 10);
circularProgressBar1.Value = i;
circularProgressBar1.Text = i.ToString() + " %";
}
MessageBox.Show("App Installed Successfully");
circularProgressBar1.Visible = false;
circularProgressBar1.Value = 0;
btnInstall.Visible = false;
btnUninstall.Visible = true;
adb = new ApplicationDBLayer();
lblDownloads.Text = adb.LoadNoOfDownloads(lblAppName.Text);
LoadDeviceInfo();
}
else
{
MessageBox.Show("App Installation Unsuccessful");
}
}
else
{
tabControl5.SelectTab(tabPage11);
txtPayment.Text = lblPrice.Text;
grpSelectCard.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnProceed_Click(object sender, EventArgs e)
{
cdb = new CustomerDBLayer();
int cID = cdb.MakePayment(txtSelectCardNo.Text, pID, cmbSelectCardType.Text, Convert.ToDecimal(txtPayment.Text));
if (cID != 0)
{
decimal size1 = size / 2;
MessageBox.Show("Payment Successful");
if (cdb.InstallApp(lblAppName.Text, pID))
{
circularProgressBar1.Visible = true;
for (int i = 0; i < 100; i++)
{
int a = (int)size1 / 100;
System.Threading.Thread.Sleep(a * 10);
circularProgressBar1.Value = i;
circularProgressBar1.Text = i.ToString() + " %";
}
MessageBox.Show("App Installed Successfully");
btnInstall.Visible = false;
btnUninstall.Visible = true;
adb = new ApplicationDBLayer();
adb.LoadNoOfDownloads(lblAppName.Text);
}
else
{
//Rollback payment is called
MessageBox.Show("App Installation Unsuccessful");
if (cdb.RollbackPayment(cID, cmbSelectCardType.Text, Convert.ToDecimal(txtPayment.Text)))
{
MessageBox.Show("Payment Rollback Successfully");
}
else
{
MessageBox.Show("Payment Rollback Unsuccessful");
}
}
}
else
{
MessageBox.Show("Payment Unsuccessful");
}
}
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 btnUninstall_Click(object sender, EventArgs e)
{
try
{
cdb = new CustomerDBLayer();
if (cdb.UninstallApp(lblAppName.Text, pID))
{
MessageBox.Show("App Uninstalled Successfully");
btnInstall.Visible = true;
btnUninstall.Visible = false;
adb = new ApplicationDBLayer();
adb.LoadNoOfDownloads(lblAppName.Text);
LoadDeviceInfo();
}
else
{
MessageBox.Show("App Uninstall Unsuccessful");
}
}
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);
}
}
private void tabPage1_Paint(object sender, PaintEventArgs e)
{
adb = new ApplicationDBLayer();
GridRecommended.DataSource = adb.LoadRecommendedApps(pID);
}
private void tabPage3_Paint(object sender, PaintEventArgs e)
{
adb = new ApplicationDBLayer();
GridUpdates.DataSource = adb.LoadUpdateData(pID);
}
private void tabPage5_Paint(object sender, PaintEventArgs e)
{
adb = new ApplicationDBLayer();
GridLibrary.DataSource = adb.LoadUnInstalledData(pID);
}
