public void RetrieveSupplierApplicationWorkingTest() // ☑ { supplierAppID = "100"; testSupplierAppRetrieval = SupplierMang.RetrieveSupplierApplication(supplierAppID); Assert.IsNotNull(testSupplierAppRetrieval); TestCleanupAccessor.deleteTestApplication(); }
/// <summary> /// Miguel Santana /// Created: 2015/04/15 /// opens pending supplier dialog /// </summary> /// <param name="selectedItem"></param> /// <param name="readOnly"></param> private void OpenPendingSupplier(SupplierApplication selectedItem = null, bool readOnly = false) { try { if (selectedItem == null) { if (new AddEditPendingSupplier().ShowDialog() == false) { return; } LoadPendingSuppliers(); } else { if (new AddEditPendingSupplier(selectedItem, readOnly).ShowDialog() == false) { return; } if (readOnly) { return; } LoadPendingSuppliers(); } } catch (Exception ex) { throw new WanderingTurtleException(this, ex); } }
public void AddSupplierApplicationNullTest() // ☑ { SupplierApplication SupplierAppNull = null; SupplierMang.AddASupplierApplication(SupplierAppNull); TestCleanupAccessor.deleteTestApplication(); }
/// <summary> /// Pat Banks /// Created: 2015/04/11 /// Returns the result of approving a supplier application and adds records to the Supplier Table and SupplierLogin tables /// </summary> /// <param name="oldSupplierApp">The SupplierApplication object to be updated</param> /// <param name="updatedSupplierApp">The SupplierApplication object with the updated information</param> /// <param name="userName">The username of the Supplier</param> /// <param name="supplyCost">The supplier's portion of ticket proceeds</param> /// <returns>An enumerated result depicting pass or fail</returns> public SupplierResult ApproveSupplierApplication(SupplierApplication oldSupplierApp, SupplierApplication updatedSupplierApp, string userName, decimal supplyCost) { try { PasswordManager myPass = new PasswordManager(); string password = myPass.supplierHash(userName, "Password#1"); //Approving //update db with approval, add supplier record, add supplier login int numRows = SupplierApplicationAccessor.UpdateSupplierApplication(oldSupplierApp, updatedSupplierApp, userName, supplyCost, password); if (numRows == 3) { //refresh cache DataCache._currentSupplierList = SupplierAccessor.GetSupplierList(); DataCache._SupplierListTime = DateTime.Now; return(SupplierResult.Success); } return(SupplierResult.ChangedByOtherUser); } catch (SqlException) { throw; } catch (Exception) { throw; } }
private void Setup(string CompName) { //set up supplier testSupplier = new Supplier(); testSupplier.CompanyName = CompName; testSupplier.FirstName = "FirstBlab"; testSupplier.LastName = "LastBlab"; testSupplier.Address1 = "255 East West St"; testSupplier.Address2 = "APT 1"; testSupplier.Zip = "50229"; testSupplier.PhoneNumber = "575-542-8796"; testSupplier.EmailAddress = "*****@*****.**"; testSupplier.ApplicationID = 999; testSupplier.SupplyCost = (decimal)((60) / 100); testSupplier.Active = true; //setup Supplier application testSupplierApp = new SupplierApplication(); testSupplierApp.ApplicationDate = new DateTime(2005, 2, 3); testSupplierApp.CompanyName = "Awsome Tours"; testSupplierApp.CompanyDescription = "tours of awsomeness"; testSupplierApp.PhoneNumber = "575-542-8796"; testSupplierApp.FirstName = "Test"; testSupplierApp.Address1 = "255 East West St"; testSupplierApp.LastName = "blabla"; testSupplierApp.Zip = "50229"; testSupplierApp.ApplicationID = 999; testSupplierApp.EmailAddress = "*****@*****.**"; testSupplierApp.Address2 = ""; testSupplierApp.ApplicationDate = new DateTime(2005, 2, 2); testSupplierApp.ApplicationStatus = "pending"; testSupplierApp.LastStatusDate = new DateTime(2005, 2, 1); testSupplierApp.Remarks = ""; }
public void RetrieveSupplierApplicationNullIDTest() // ☑ { supplierAppID = null; testSupplierAppRetrieval = SupplierMang.RetrieveSupplierApplication(supplierAppID); Assert.IsNull(testSupplierAppRetrieval); TestCleanupAccessor.deleteTestApplication(); }
public void AddSupplierApplicationEmptyTest() // ☑ { SupplierApplication SupplierAppEmpty = new SupplierApplication(); SupplierMang.AddASupplierApplication(SupplierAppEmpty); TestCleanupAccessor.deleteTestApplication(); }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Updates an existing Supplier Application Record already in the Database /// </summary> /// <param name="oldApplication">A SupplierApplication Object that contains all the information of the record to be changed</param> /// <param name="newApplication">A SupplierApplication Object that contains all the information to change in the record</param> /// <returns>int reflecting number of rows affected</returns> public static int UpdateSupplierApplication(SupplierApplication oldApplication, SupplierApplication newApplication) { var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spUpdateSupplierApplication"; var cmd = new SqlCommand(cmdText, conn); var rowsAffected = 0; // set command type to stored procedure and add parameters cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyName", newApplication.CompanyName); cmd.Parameters.AddWithValue("@CompanyDescription", newApplication.CompanyDescription); cmd.Parameters.AddWithValue("@FirstName", newApplication.FirstName); cmd.Parameters.AddWithValue("@LastName", newApplication.LastName); cmd.Parameters.AddWithValue("@Address1", newApplication.Address1); cmd.Parameters.AddWithValue("@Address2", newApplication.Address2); cmd.Parameters.AddWithValue("@Zip", newApplication.Zip); cmd.Parameters.AddWithValue("@PhoneNumber", newApplication.PhoneNumber); cmd.Parameters.AddWithValue("@EmailAddress", newApplication.EmailAddress); cmd.Parameters.AddWithValue("@ApplicationDate", newApplication.ApplicationDate); cmd.Parameters.AddWithValue("@ApplicationStatus", newApplication.ApplicationStatus); cmd.Parameters.AddWithValue("@LastStatusDate", newApplication.LastStatusDate); cmd.Parameters.AddWithValue("@Remarks", newApplication.Remarks); cmd.Parameters.AddWithValue("@originalApplicationID", oldApplication.ApplicationID); cmd.Parameters.AddWithValue("@originalCompanyName", oldApplication.CompanyName); cmd.Parameters.AddWithValue("@originalCompanyDescription", oldApplication.CompanyDescription); cmd.Parameters.AddWithValue("@originalFirstName", oldApplication.FirstName); cmd.Parameters.AddWithValue("@originalLastName", oldApplication.LastName); cmd.Parameters.AddWithValue("@originalAddress1", oldApplication.Address1); cmd.Parameters.AddWithValue("@originalAddress2", oldApplication.Address2); cmd.Parameters.AddWithValue("@originalZip", oldApplication.Zip); cmd.Parameters.AddWithValue("@originalPhoneNumber", oldApplication.PhoneNumber); cmd.Parameters.AddWithValue("@originalEmailAddress", oldApplication.EmailAddress); cmd.Parameters.AddWithValue("@originalApplicationDate", oldApplication.ApplicationDate); cmd.Parameters.AddWithValue("@originalApplicationStatus", oldApplication.ApplicationStatus); cmd.Parameters.AddWithValue("@originalLastStatusDate", oldApplication.LastStatusDate); cmd.Parameters.AddWithValue("@originalRemarks", oldApplication.Remarks); try { conn.Open(); rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new ApplicationException("Concurrency Violation"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(rowsAffected); }
public void EditSupplierApplicationPartialTest() // ☑ { SupplierApplication testSupplierAppPartial = new SupplierApplication(); testSupplierAppPartial.CompanyName = "test"; testSupplierAppPartial.ApplicationID = 1; testSupplierAppPartial.PhoneNumber = "234-234-2341"; testSupplierAppPartial.FirstName = "test"; SupplierMang.EditSupplierApplication(testSupplierAppPartial, testSupplierAppPartial); }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Retrieves a list of all Supplier Application Records from the Database /// </summary> /// <remarks> /// Rose Steffensmeier /// Updated: 2015/04/03 /// added param to input so that stored procedure will work, param does not affect the actual /// </remarks> /// <returns>List of SupplierApplication objects</returns> public static List <SupplierApplication> GetSupplierApplicationList() { var ApplicationList = new List <SupplierApplication>(); var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spSelectAllSupplierApplication"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var currentSupplierApplication = new SupplierApplication(); currentSupplierApplication.ApplicationID = (int)reader.GetValue(0); currentSupplierApplication.CompanyName = reader.GetValue(1).ToString(); currentSupplierApplication.CompanyDescription = !reader.IsDBNull(2) ? currentSupplierApplication.CompanyDescription = reader.GetValue(2).ToString() : null; currentSupplierApplication.FirstName = reader.GetValue(3).ToString(); currentSupplierApplication.LastName = reader.GetValue(4).ToString(); currentSupplierApplication.Address1 = reader.GetValue(5).ToString(); currentSupplierApplication.Address2 = reader.GetValue(6).ToString(); currentSupplierApplication.Zip = reader.GetValue(7).ToString(); currentSupplierApplication.PhoneNumber = reader.GetValue(8).ToString(); currentSupplierApplication.EmailAddress = reader.GetValue(9).ToString(); currentSupplierApplication.ApplicationDate = (DateTime)reader.GetValue(10); currentSupplierApplication.ApplicationStatus = reader.GetValue(11).ToString(); currentSupplierApplication.LastStatusDate = reader.GetDateTime(12); currentSupplierApplication.Remarks = !reader.IsDBNull(13) ? currentSupplierApplication.Remarks = reader.GetValue(13).ToString() : null; ApplicationList.Add(currentSupplierApplication); } } else { var ex = new ApplicationException("No Supplier Applications Found!"); throw ex; } } catch (Exception) { throw; } finally { conn.Close(); } return(ApplicationList); }
public void AddSupplierApplicationPartialTest() // ☐ { SupplierApplication testSupplierApp2 = new SupplierApplication(); testSupplierApp2.ApplicationDate = new DateTime(); testSupplierApp2.CompanyDescription = "test"; testSupplierApp2.CompanyName = "name"; testSupplierApp2.PhoneNumber = "234-234-2341"; testSupplierApp2.FirstName = "test"; SupplierMang.AddASupplierApplication(testSupplierApp2); TestCleanupAccessor.deleteTestApplication(); }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Add a single Supplier Application Record to the database /// Throws any exceptions caught by the DAL /// </summary> /// <remarks> /// Pat Banks /// Updated: 2015/04/11 /// Added logic for returning the result of the operations to the presentation layer /// </remarks> /// <param name="newSupplier">Supplier object containing the information of the supplier to be added</param> /// <returns>An int reflecting the number of rows affected</returns> public SupplierResult AddASupplierApplication(SupplierApplication newSupplierApp) { try { return(SupplierApplicationAccessor.AddSupplierApplication(newSupplierApp) == 1 ? SupplierResult.Success : SupplierResult.NotAdded); } catch (ApplicationException ex) { return(ex.Message == "Concurrency Violation" ? SupplierResult.ChangedByOtherUser : SupplierResult.DatabaseError); } catch (Exception) { return(SupplierResult.DatabaseError); } }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Retrieves a single Supplier Application Records from the Database /// </summary> /// <param name="SupplierApplicationID">A string of the SupplierApplicationID of the Supplier Application to be fetched</param> /// <returns>SupplierApplication object</returns> public static SupplierApplication GetSupplierApplication(String SupplierApplicationID) { var currentSupplierApplication = new SupplierApplication(); var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spSelectSupplierApplication"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ApplicationID", SupplierApplicationID); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { currentSupplierApplication.ApplicationID = reader.GetInt32(0); currentSupplierApplication.CompanyName = reader.GetValue(1).ToString(); currentSupplierApplication.CompanyDescription = !reader.IsDBNull(2) ? currentSupplierApplication.CompanyDescription = reader.GetString(2) : null; currentSupplierApplication.FirstName = reader.GetValue(3).ToString(); currentSupplierApplication.LastName = reader.GetValue(4).ToString(); currentSupplierApplication.Address1 = reader.GetValue(5).ToString(); currentSupplierApplication.Address2 = reader.GetValue(6).ToString(); currentSupplierApplication.Zip = reader.GetValue(7).ToString(); currentSupplierApplication.PhoneNumber = reader.GetValue(8).ToString(); currentSupplierApplication.EmailAddress = reader.GetValue(9).ToString(); currentSupplierApplication.ApplicationDate = reader.GetDateTime(10); currentSupplierApplication.ApplicationStatus = reader.GetValue(11).ToString(); currentSupplierApplication.LastStatusDate = reader.GetDateTime(12); currentSupplierApplication.Remarks = !reader.IsDBNull(13) ? currentSupplierApplication.Remarks = reader.GetValue(13).ToString() : null; } else { var ax = new ApplicationException("Supplier Application Not Found!"); throw ax; } } catch (Exception) { throw; } finally { conn.Close(); } return(currentSupplierApplication); }
/// <summary> /// Miguel Santana /// Created: 2015/04/09 /// Handles loading of the screen with data from the list. /// </summary> /// <param name="currentSupplierApplication"></param> /// <param name="readOnly"></param> /// <exception cref="WanderingTurtleException">Occurs making components readonly.</exception> public AddEditPendingSupplier(SupplierApplication currentSupplierApplication, bool readOnly = false) { InitializeComponent(); _cityStateManager.PopulateCityStateCache(); CurrentSupplierApplication = currentSupplierApplication; Title = "Editing Pending Supplier: " + CurrentSupplierApplication.GetFullName; ReloadComboBox(); FillComboBox(); SetFields(); if (readOnly) { (Content as Panel).MakeReadOnly(BtnCancel); } }
public void EditSupplierApplicationWorkingTest() // ☑ { Setup("EditSupAppWorking"); SupplierApplication testSupplierApp2 = testSupplierApp; testSupplierApp2.CompanyName = "Awsomest Tours"; testSupplierApp2.CompanyDescription = "tours of epicness"; testSupplierApp2.LastName = "blabla"; testSupplierApp2.Zip = "50229"; testSupplierApp2.EmailAddress = "*****@*****.**"; testSupplierApp2.Address2 = ""; testSupplierApp.ApplicationDate = new DateTime(2005, 2, 2); testSupplierApp.ApplicationStatus = "pending"; testSupplierApp.LastStatusDate = new DateTime(2005, 2, 1); testSupplierApp.Remarks = ""; SupplierMang.EditSupplierApplication(testSupplierApp, testSupplierApp2); testSupplierApp = testSupplierApp2; TestCleanupAccessor.DeleteTestSupplier(testSupplier); }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Inserts a new Supplier Application Record into the Database /// </summary> /// <param name="supplierApplicationToAdd">A Supplier Application Object that contains all the information to be added</param> /// <returns>int reflecting number of rows affected</returns> public static int AddSupplierApplication(SupplierApplication supplierApplicationToAdd) { var conn = DatabaseConnection.GetDatabaseConnection(); string cmdtext = "spInsertSupplierApplication"; var cmd = new SqlCommand(cmdtext, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyName", supplierApplicationToAdd.CompanyName); cmd.Parameters.AddWithValue("@CompanyDescription", supplierApplicationToAdd.CompanyDescription); cmd.Parameters.AddWithValue("@FirstName", supplierApplicationToAdd.FirstName); cmd.Parameters.AddWithValue("@LastName", supplierApplicationToAdd.LastName); cmd.Parameters.AddWithValue("@Address1", supplierApplicationToAdd.Address1); cmd.Parameters.AddWithValue("@Address2", supplierApplicationToAdd.Address2); cmd.Parameters.AddWithValue("@Zip", supplierApplicationToAdd.Zip); cmd.Parameters.AddWithValue("@PhoneNumber", supplierApplicationToAdd.PhoneNumber); cmd.Parameters.AddWithValue("@EmailAddress", supplierApplicationToAdd.EmailAddress); cmd.Parameters.AddWithValue("@ApplicationDate", supplierApplicationToAdd.ApplicationDate); cmd.Parameters.AddWithValue("@ApplicationStatus", supplierApplicationToAdd.ApplicationStatus); cmd.Parameters.AddWithValue("@LastStatusDate", supplierApplicationToAdd.LastStatusDate); cmd.Parameters.AddWithValue("@Remarks", supplierApplicationToAdd.Remarks); var rowsAffected = 0; try { conn.Open(); rowsAffected = (int)cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(rowsAffected); }
/// <summary> /// Matt Lapka /// Created: 2015/02/08 /// Updates a Supplier Application Record /// Throws any exceptions caught by the DAL /// </summary> /// <remarks> /// Pat Banks /// Updated: 2015/04/11 /// Added logic for returning the result of the operations to the presentation layer /// </remarks> /// <param name="newSupplier">Supplier object containing the new information of the supplier</param> /// <param name="oldSupplier">Supplier object containing the current information of the supplier to be matched to salve concurrency problems</param> /// <returns>An int reflecting the of rows affected</returns> public SupplierResult EditSupplierApplication(SupplierApplication oldSupplierApp, SupplierApplication updatedSupplierApp) { try { if (updatedSupplierApp.ApplicationStatus.Equals(ApplicationStatus.Pending.ToString())) { //just editing application - still Pending //update db with new info not related to approval int numRows = SupplierApplicationAccessor.UpdateSupplierApplication(oldSupplierApp, updatedSupplierApp); if (numRows == 1) { RetrieveSupplierApplicationList(); return(SupplierResult.Success); } return(SupplierResult.ChangedByOtherUser); } //Rejecting the application if (updatedSupplierApp.ApplicationStatus.Equals(ApplicationStatus.Rejected.ToString())) { //update db with rejection int numRows = SupplierApplicationAccessor.UpdateSupplierApplication(oldSupplierApp, updatedSupplierApp); return(numRows == 1 ? SupplierResult.Success : SupplierResult.ChangedByOtherUser); } return(SupplierResult.NotChanged); } catch (ApplicationException ex) { return(ex.Message == "Concurrency Violation." ? SupplierResult.ChangedByOtherUser : SupplierResult.DatabaseError); } catch (Exception) { return(SupplierResult.DatabaseError); } }
public void EditSupplierApplicationPartialTest2() // ☑ { SupplierApplication testSupplierApp2 = null; SupplierMang.EditSupplierApplication(testSupplierApp, testSupplierApp2); }
public void EditSupplierApplicationNullTest() // ☑ { SupplierApplication testSupplierAppNull = null; SupplierMang.EditSupplierApplication(testSupplierAppNull, testSupplierAppNull); }
public void EditSupplierApplicationEmptyTest() // ☑ { SupplierApplication testSupplierAppEmpty = new SupplierApplication(); SupplierMang.EditSupplierApplication(testSupplierAppEmpty, testSupplierAppEmpty); }
/// <summary> /// Kelsey Blount /// Created 2015/04/07 /// submits data to bll for supplier application /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmitApplication_Click(object sender, EventArgs e) { clearBorderColors(); int errorCount = 0; lblFinish.Text = ""; //Validate if (validateText(txtCompanyName, "Please enter a company name")) { errorCount++; } if (validateName(txtFirstName, "Please enter your first name")) { errorCount++; } if (validateName(txtLastName, "Please enter your second name")) { errorCount++; } if (validateText(txtAddress, "Please enter your address")) { errorCount++; } //check zips bool goodZip = false; foreach (var zip in zips) { if (txtZip.Text == zip.Zip) { goodZip = true; } } if (!goodZip) { txtZip.ToolTip = "Please enter a valid Zip Code"; txtZip.BorderColor = Color.Red; errorCount++; } if (validateText(txtDescription, "Please enter your description")) { errorCount++; } if (!txtEmail.Text.ValidateEmail()) { txtEmail.ToolTip = "Please enter a valid e-mail"; txtEmail.BorderColor = Color.Red; errorCount++; } else { txtEmail.ToolTip = ""; txtEmail.BorderColor = Color.Empty; } if (!txtPhoneNumber.Text.ValidatePhone()) { txtPhoneNumber.ToolTip = "Please enter a valid phone number"; txtPhoneNumber.BorderColor = Color.Red; } else { txtPhoneNumber.ToolTip = ""; txtPhoneNumber.BorderColor = Color.Empty; } if (errorCount > 0) { showError("You have " + errorCount + " errors that need to be fixed."); return; } else { //reset border colors clearBorderColors(); try { //create new Suppler Application SupplierApplication application = new SupplierApplication(txtCompanyName.Text, txtDescription.Text, txtFirstName.Text, txtLastName.Text, txtAddress.Text, txtAddress2.Text, txtZip.Text, txtPhoneNumber.Text, txtEmail.Text, DateTime.Now); SupplierResult result = ApplicationManager.AddASupplierApplication(application); if (result == SupplierResult.Success) { showError("Thank you for your Application!<br /> We will be in contact once we have reviewed the information. "); clearForm(); } } catch (Exception ex) { showError(ex.Message); } } }