public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = new StreamReader(req.Body).ReadToEnd();
            Request <ISet <String> > request = JsonConvert.DeserializeObject <Request <ISet <String> > >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();
                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <ISet <String> > .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }


                    foreach (String file in request.obj)
                    {
                        // Anfrage bearbeiten
                        string sql = "insert imageNutzer values(@ID, @FNAME)";
                        using (SqlCommand com1 = new SqlCommand(sql, con))
                        {
                            com1.Parameters.Add("@ID", System.Data.SqlDbType.Int);
                            com1.Parameters.Add("@FNAME", System.Data.SqlDbType.NVarChar);

                            com1.Parameters["@FNAME"].Value = file;
                            com1.Parameters["@ID"].Value    = request.Id;

                            com1.ExecuteNonQuery();
                        }
                    }
                }

                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }
        public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = new StreamReader(req.Body).ReadToEnd();
            Request <ISet <String> > request = JsonConvert.DeserializeObject <Request <ISet <String> > >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();
                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <ISet <String> > .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }


                    // Anfrage bearbeiten
                    request.obj = new HashSet <String>();
                    string sql = "Select * from imageNutzer where id_nutzer=" + request.Id;
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                request.obj.Add(reader.GetString(1));
                            }
                        }
                    }
                }

                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }
Esempio n. 3
0
        public static async System.Threading.Tasks.Task <HttpResponseMessage> runAsync([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
            Request <SpielHighscores> request = JsonConvert.DeserializeObject <Request <SpielHighscores> >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();

                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <SpielHighscores> .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }

                    // Anfrage bearbeiten
                    request.obj = new SpielHighscores();

                    string sql = "Select * from Spiel";
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                Spiel spiel = new Spiel();
                                request.obj.spiele.Add(reader.GetInt32(0), spiel);
                                spiel.id_spiel           = reader.GetInt32(0);
                                spiel.spiel              = reader.GetString(1);
                                spiel.globaleBestzeit    = reader.GetInt32(2);
                                spiel.globalerDurschnitt = reader.GetInt32(3);
                                spiel.rekordhalter       = reader.GetString(5);

                                if (spiel.globaleBestzeit == Int32.MaxValue)
                                {
                                    spiel.rekordhalter    = "Niemand";
                                    spiel.globaleBestzeit = 0;
                                }
                            }
                        }

                        foreach (int key in request.obj.spiele.Keys)
                        {
                            sql = "Select * from Highscore where id_spiel=" + key + " and id_nutzer=" + request.Id;
                            using (SqlCommand com2 = new SqlCommand(sql, con))
                            {
                                using (SqlDataReader reader2 = com2.ExecuteReader())
                                {
                                    reader2.Read();
                                    Spiel spiel = request.obj.spiele[reader2.GetInt32(1)];
                                    spiel.bestzeit              = reader2.GetInt32(2);
                                    spiel.schlechtesteZeit      = reader2.GetInt32(3);
                                    spiel.durchschnitt          = reader2.GetInt32(4);
                                    spiel.anzahl_gespielt       = reader2.GetInt32(5);
                                    spiel.akummulierteSpielzeit = reader2.GetInt64(6);

                                    if (spiel.bestzeit == Int32.MaxValue)
                                    {
                                        spiel.bestzeit = 0;
                                    }
                                }
                            }
                        }
                    }
                }
                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }
Esempio n. 4
0
        public static HttpResponseMessage run([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string          requestBody = new StreamReader(req.Body).ReadToEnd();
            Request <Spiel> request     = JsonConvert.DeserializeObject <Request <Spiel> >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();
                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <Spiel> .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }


                    // Anfrage bearbeiten
                    string sql = "Update Highscore Set bestzeit=@BEST, schlechteste_Zeit=@BAD, durchschnitt=@AVERG, anzahl=@COU, kumulierteSpielzeit=@KUM Where id_Spiel=@SID and id_Nutzer=@NID";
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        com1.Parameters.Add("@BEST", System.Data.SqlDbType.Int);
                        com1.Parameters.Add("@BAD", System.Data.SqlDbType.Int);
                        com1.Parameters.Add("@AVERG", System.Data.SqlDbType.Int);
                        com1.Parameters.Add("@COU", System.Data.SqlDbType.Int);
                        com1.Parameters.Add("@KUM", System.Data.SqlDbType.BigInt);

                        com1.Parameters.Add("@SID", System.Data.SqlDbType.Int);
                        com1.Parameters.Add("@NID", System.Data.SqlDbType.Int);


                        com1.Parameters["@BEST"].Value  = request.obj.bestzeit;
                        com1.Parameters["@BAD"].Value   = request.obj.schlechtesteZeit;
                        com1.Parameters["@AVERG"].Value = request.obj.durchschnitt;
                        com1.Parameters["@COU"].Value   = request.obj.anzahl_gespielt;
                        com1.Parameters["@KUM"].Value   = request.obj.akummulierteSpielzeit;

                        com1.Parameters["@SID"].Value = request.obj.id_spiel;
                        com1.Parameters["@NID"].Value = request.Id;

                        com1.ExecuteNonQuery();
                    }


                    sql = "Select * from Spiel where id=" + request.obj.id_spiel;
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            reader.Read();
                            request.obj.globaleBestzeit    = reader.GetInt32(2);
                            request.obj.globalerDurschnitt = reader.GetInt32(3);
                            request.obj.rekordhalter       = reader.GetString(5);
                        }
                    }
                }
                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }
        public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = new StreamReader(req.Body).ReadToEnd();
            Request <ISet <String> > request = JsonConvert.DeserializeObject <Request <ISet <String> > >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();
                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <ISet <String> > .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }


                    ISet <String> blobs = await FUNCTIONS2.GetImages();

                    string blob = null;

                    string sql = "Select blob from Nutzer where id=" + request.Id;
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                blob = reader.GetString(0);
                            }
                        }
                    }

                    sql = "Select * from imageNutzer where id_nutzer=" + request.Id;
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                if (blobs.Contains(reader.GetString(1)))
                                {
                                    blobs.Remove(reader.GetString(1));
                                }
                            }
                        }
                    }

                    if (blobs.Count == 0)
                    {
                        request.Errorcode = -11;
                        throw new Exception("");
                    }

                    CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Environment.GetEnvironmentVariable("AZURE_STORAGE_CONNECTION_STRING"));
                    var client      = storageAccount.CreateCloudBlobClient();
                    var cbContainer = client.GetContainerReference("images");
                    var container   = client.GetContainerReference(blob);

                    //Blobs kopieren
                    await FUNCTIONS2.CopyImages(cbContainer, container, blobs);

                    FUNCTIONS2.writeToDb(blobs, request.Id, con);
                    request.obj = blobs;
                }
                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }
            catch (Exception e1)
            {
                request.Success = false;
                request.Error   = "Ein Fehler ist aufgetreten";
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }
Esempio n. 6
0
        public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = new StreamReader(req.Body).ReadToEnd();
            Request <ISet <string> > request = JsonConvert.DeserializeObject <Request <ISet <String> > >(requestBody);

            try
            {
                using (SqlConnection con = new SqlConnection(Environment.GetEnvironmentVariable("DB_CONNECTION_STRING")))
                {
                    con.Open();
                    // TOKEN überprüfen
                    HttpResponseMessage message = FUNCTIONS <ISet <String> > .checkToken(request, con);

                    if (message != null)
                    {
                        return(message);
                    }


                    string blob = null;
                    string sql  = "Select blob from Nutzer where id=" + request.Id;
                    using (SqlCommand com1 = new SqlCommand(sql, con))
                    {
                        using (SqlDataReader reader = com1.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                blob = reader.GetString(0);
                            }
                        }
                    }
                    CloudStorageAccount storageAccount = CloudStorageAccount.Parse(Environment.GetEnvironmentVariable("AZURE_STORAGE_CONNECTION_STRING"));
                    var client    = storageAccount.CreateCloudBlobClient();
                    var container = client.GetContainerReference(blob);

                    CloudBlockBlob cloudBlockBlob;
                    foreach (String file in request.obj)
                    {
                        cloudBlockBlob = container.GetBlockBlobReference(file);
                        await cloudBlockBlob.DeleteIfExistsAsync();

                        sql = "Delete from imageNutzer where id_nutzer=@ID and nameOfFile=@FNAME";
                        using (SqlCommand com1 = new SqlCommand(sql, con))
                        {
                            com1.Parameters.Add("@ID", System.Data.SqlDbType.Int);
                            com1.Parameters.Add("@FNAME", System.Data.SqlDbType.NVarChar);

                            com1.Parameters["@FNAME"].Value = file;
                            com1.Parameters["@ID"].Value    = request.Id;

                            com1.ExecuteNonQuery();
                        }
                    }
                }

                request.Success = true;
            }
            catch (SqlException e)
            {
                request.Success   = false;
                request.Error     = e.Message;
                request.Errorcode = e.ErrorCode;
            }

            return(new HttpResponseMessage
            {
                Content = new StringContent(JsonConvert.SerializeObject(request))
            });
        }