public bool CheckEditOrCreate(Subscription input, SubscribedToCategory subCat) { bool wasSuccess = false; try { /*Since create and edit subscription was done in the samme window * the program has to check if subscriptionID exists, if it does not * exist (SubscripionID==0) then it creates a subscription*/ if (input.SubscriptionID == 0) { wasSuccess = CreateSubscription(input); if (wasSuccess == true) { throw new SubscriptionWasAdded(input); } } if (input.SubscriptionID > 0) { wasSuccess = EditSubscription(input) || EditSubscriptionWCategory(subCat); if (wasSuccess == true) { throw new SubscriptionWasEdited(input); } } return(false); } catch (Exception ex) { Log.WriteEvent(ex); return(true); } }
// Made by Helena Brunsgaard Madsen public bool InsertSubscriptionWCategory(SubscribedToCategory input) //THIS IS THE RIGHT ONE! { if (input == null) { throw new ArgumentNullException(nameof(input)); } try { SqlConnection con = new SqlConnection(DBOpenClose.conStr); DBOpenClose.OpenConnection(con); SqlCommand command = new SqlCommand( "INSERT INTO [SubscribedToCategories] (CategoryID, SubscriptionID) VALUES (@CategoryID, @SubscriptionID)" + "SELECT SubscriptionID FROM Subscription WHERE SubscriptionID=SubscriptionID " + "SELECT CategoryID FROM ProductCategories WHERE CategoryID=CategoryID", con); command.Parameters.Add("@CategoryID", SqlDbType.Int); command.Parameters["@CategoryID"].Value = input.CategoryID; command.Parameters.Add("@SubscriptionID", SqlDbType.Int); command.Parameters["@SubscriptionID"].Value = input.SubscriptionID; command.ExecuteNonQuery(); DBOpenClose.CloseConnection(con); return(true); } catch (Exception ex) { SqlConnection con = new SqlConnection(DBOpenClose.conStr); DBOpenClose.CloseConnection(con); Log.WriteFail(ex); return(false); } }
public bool EditSubscriptionWCategory(SubscribedToCategory input) { if (input == null) { throw new ArgumentNullException(nameof(input)); } try { SqlConnection con = new SqlConnection(DBOpenClose.conStr); DBOpenClose.OpenConnection(con); SqlCommand command = new SqlCommand( "UPDATE [SubscribedToCategories] SET CategoryID=@CategoryID " + "WHERE SubscriptionID=SubscriptionID", con); command.Parameters.Add("@CategoryID", SqlDbType.Int); command.Parameters["@CategoryID"].Value = input.CategoryID; command.Parameters.Add("@SubscriptionID", SqlDbType.Int); command.Parameters["@SubscriptionID"].Value = input.SubscriptionID; command.ExecuteNonQuery(); DBOpenClose.CloseConnection(con); return(true); } catch (Exception ex) { SqlConnection con = new SqlConnection(DBOpenClose.conStr); DBOpenClose.CloseConnection(con); Log.WriteFail(ex); return(false); } }
public List <Categories> SelectSubscriptionwithCategory(int ID) { try { SqlConnection con = new SqlConnection(DBOpenClose.conStr); SubscribedToCategory output = new SubscribedToCategory(); List <Categories> categoryList = new List <Categories>(); DBOpenClose.OpenConnection(con); SqlCommand getSubscription = new SqlCommand( "SELECT * FROM [SubscribedToCategories] WHERE SubscriptionID=@SubscriptionID", con); getSubscription.Parameters.Add("@SubscriptionID", SqlDbType.Int); getSubscription.Parameters["@SubscriptionID"].Value = ID; SqlDataReader reader = getSubscription.ExecuteReader(); while (reader.Read()) { Categories subscribedToCategory = new Categories(); subscribedToCategory.CategoryID = Convert.ToInt32(reader["CategoryID"]); categoryList.Add(subscribedToCategory); } DBOpenClose.CloseConnection(con); return(categoryList); } catch (Exception ex) { SqlConnection con = new SqlConnection(DBOpenClose.conStr); DBOpenClose.CloseConnection(con); List <Categories> categoryList = new List <Categories>(); Log.WriteFail(ex); return(categoryList); } }
private bool CreateSubscriptionWCategory(SubscribedToCategory subCat) { try { return(subscriptionLogic.CreateSubscriptionWCategory(subCat)); } catch (Exception ex) { ErrorHandler.Log.WriteFail(ex); CreateMessage.ShowInputNotValid(); return(false); } }
public bool EditSubscriptionWCategory(SubscribedToCategory input) { return(DB.EditSubscriptionWCategory(input)); }
public bool CreateSubscriptionWCategory(SubscribedToCategory input) { return(DB.InsertSubscriptionWCategory(input)); }
// Made by Helena Madsen /// <summary> /// Inserts a subscription ID and Category ID into a database column containing foreign keys /// </summary> /// <param name="input"></param> /// <returns></returns> public static bool InsertSubscriptionWCategory(SubscribedToCategory input) { DBInsert dBInsert = new DBInsert(); return(dBInsert.InsertSubscriptionWCategory(input)); }
// Made by Helena Madsen /// <summary> /// Editing subscription from picked subscriptionID /// </summary> /// <param name="input"></param> /// <returns></returns> public static bool EditSubscriptionWCategory(SubscribedToCategory input) { DBEdit dBEdit = new DBEdit(); return(dBEdit.EditSubscriptionWCategory(input)); }