public void DeleteApplication(Hashtable State)
{
string application_name = State["SelectedApp"].ToString();
DB db = new DB();
string sql = "SELECT application_id FROM applications WHERE application_name='" + application_name + "' AND customer_id='" + State["CustomerID"].ToString() + "'";
string application_id = db.ViziAppsExecuteScalar(State, sql);
sql = "DELETE FROM applications WHERE application_id='" + application_id + "'";
db.ViziAppsExecuteNonQuery(State, sql);
sql = "DELETE FROM application_pages WHERE application_id='" + application_id + "'";
db.ViziAppsExecuteNonQuery(State, sql);
sql = "DELETE FROM branding_images WHERE application_id='" + application_id + "'";
db.ViziAppsExecuteNonQuery(State, sql);
db.CloseViziAppsDatabase(State);
if (State["SelectedAppType"] != null && (State["SelectedAppType"].ToString() == Constants.WEB_APP_TYPE || State["SelectedAppType"].ToString() == Constants.HYBRID_APP_TYPE) &&
State["UrlAccountIdentifier"] != null)
{
AmazonS3 s3 = new AmazonS3();
string Bucket = ConfigurationManager.AppSettings["WebAppBucket"];
string file_name = State["SelectedApp"].ToString().Replace(" ", "_") + Constants.WEB_APP_TEST_SUFFIX + "/index.html";
string key = State["UrlAccountIdentifier"].ToString() + "/" + file_name;
s3.DeleteS3Object(Bucket, key);
file_name = State["SelectedApp"].ToString().Replace(" ", "_") + "/index.html";
key = State["UrlAccountIdentifier"].ToString() + "/" + file_name;
if (s3.S3ObjectExists(Bucket, key))
s3.DeleteS3Object(Bucket, key);
}
}