Example #1
0
    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);
        }
    }