Exemplo n.º 1
0
        public static void RemoveCancellation(Cancellation canc)
        {
            try
            {
                string query = "DELETE Cancellation WHERE CancellationID = " + canc.CancellationId;

                SqlConnection connection = new SqlConnection(ConnectionString);
                SqlCommand cmd = new SqlCommand(query, connection);
                connection.Open();
                cmd.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception ex)
            {
                string errmsg = "Fehler beim Löschen des Stornos.\n\n";
                errmsg += "DatabaseHandler.RemoveCancellation(canc): " + ex.ToString();
                throw new Exception(errmsg);
            }
        }
Exemplo n.º 2
0
        public static void SaveCancellation(Cancellation canc)
        {
            try
            {
                string query = "UPDATE [Cancellation] SET UserID = " + canc.User.UserID + ", ArticleID = " + canc.Article.ArticleID + ", ArticleCount = " + canc.Count + ", Created = '" + canc.Created + "'" +
                    " WHERE CancellationID = " + canc.CancellationId;

                SqlConnection connection = new SqlConnection(ConnectionString);
                SqlCommand cmd = new SqlCommand(query, connection);
                connection.Open();
                cmd.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception ex)
            {
                string errmsg = "Fehler beim Speichern der Änderungen des Stornos.\n\n";
                errmsg += "DatabaseHandler.SaveCancellation(canc): " + ex.ToString();
                throw new Exception(errmsg);
            }
        }
Exemplo n.º 3
0
        public static Cancellation NewCancellation(CancellationTemplate cancTemplate)
        {
            Cancellation result = null;

            try
            {
                string query = "INSERT INTO Cancellation (UserID, ArticleID, ArticleCount) VALUES (" +
                                cancTemplate.User.UserID + "," + cancTemplate.Article.ArticleID + "," + cancTemplate.Count + "); " +
                                "SELECT * FROM Cancellation WHERE CancellationID = SCOPE_IDENTITY();";

                SqlConnection connection = new SqlConnection(ConnectionString);
                SqlCommand cmd = new SqlCommand(query, connection);
                connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    result = new Cancellation(
                        Convert.ToInt32(reader["CancellationID"]),
                        GetUser(Convert.ToInt32(reader["UserID"])),
                        GetArticle(Convert.ToInt32(reader["ArticleID"])),
                        Convert.ToInt32(reader["ArticleCount"]),
                        Convert.ToDateTime(reader["Created"])
                    );
                }
                connection.Close();
            }
            catch (Exception ex)
            {
                string errmsg = "Fehler beim Erstellen des Stornos.\n\n";
                errmsg += "DatabaseHandler.NewCancellation(cancTemplate): " + ex.ToString();
                throw new Exception(errmsg);
            }

            if (result == null)
                throw new Exception("Fehler beim Erstellen des Stornos. Das Speichern konnte nicht verifiziert werden.\n\nDatabaseHandler.NewCancellation(cancTemplate)");


            return result;
        }