/// <summary> /// Created by Justin Pennington 2015/02/25 /// Deletes a SupplierFeedbackRecord from the database (no archive setting as of 2015/02/25) /// </summary> /// <remarks> /// </remarks> /// <param name="supplierFeedback">A Supplier feedback record Object that contain all the information to be deleted</param> /// <exception cref="SQLException">Delete Fails</exception> /// <returns>rowsAffected (int)</returns> public static int DeleteSupplierFeedbackRecord(SupplierFeedbackRecord supplierFeedback) { var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spDeleteSupplierFeedbackRecord"; var cmd = new SqlCommand(cmdText, conn); var rowsAffected = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RatingID", supplierFeedback.RatingID); cmd.Parameters.AddWithValue("@SupplierID", supplierFeedback.SupplierID); cmd.Parameters.AddWithValue("@EmployeeID", supplierFeedback.EmployeeID); cmd.Parameters.AddWithValue("@Rating", supplierFeedback.Rating); cmd.Parameters.AddWithValue("@Notes", supplierFeedback.RatingNotes); try { conn.Open(); rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new ApplicationException("Concurrency Violation"); } } catch (Exception) { throw; } finally { conn.Close(); } return rowsAffected; // needs to be rows affected }
/// <summary> /// Created by Justin Pennington 2015/02/25 /// Adds a SupplierFeedbackRecord to the database /// </summary> /// <param name="newFeedbackRecord">Contains values to be added to the database</param> /// <returns>rowsAffected (int)</returns> public static int AddSupplierFeedbackRecord(SupplierFeedbackRecord newFeedbackRecord) { //Connect To Database var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spInsertSupplierFeedbackRecord"; var cmd = new SqlCommand(cmdText, conn); var rowsAffected = 0; cmd.CommandType = CommandType.StoredProcedure; //Set up Parameters For the Stored Procedure cmd.Parameters.AddWithValue("@SupplierID", newFeedbackRecord.SupplierID); cmd.Parameters.AddWithValue("@EmployeeID", newFeedbackRecord.EmployeeID); cmd.Parameters.AddWithValue("@Rating", newFeedbackRecord.Rating); cmd.Parameters.AddWithValue("@Notes", newFeedbackRecord.RatingNotes); try { conn.Open(); rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new ApplicationException("Concurrency Violation"); } } catch (Exception) { throw; } finally { conn.Close(); } return rowsAffected; }
/// <summary> /// Created by Justin Pennington 2015/02/25 /// Retrieves a SupplierFeedbackRecord list from the database /// </summary> /// <remarks> /// </remarks> /// <exception cref="SQLException">Insert Fails</exception> /// <returns>List of SupplierFeedbackRecord</returns> public static List<SupplierFeedbackRecord> GetSupplierFeedbackRecordList() { var recordList = new List<SupplierFeedbackRecord>(); // set up the database call var conn = DatabaseConnection.GetDatabaseConnection(); string cmdText = "spSelectAllSupplierFeedbackRecord"; var cmd = new SqlCommand(cmdText, conn); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { var currentRecord = new SupplierFeedbackRecord(); currentRecord.RatingID = reader.GetInt32(0); currentRecord.SupplierID = reader.GetInt32(1); currentRecord.EmployeeID = reader.GetInt32(2); currentRecord.Rating = reader.GetInt32(3); currentRecord.RatingNotes = reader.GetString(4); recordList.Add(currentRecord); } } else { var ax = new ApplicationException("Data not found!"); throw ax; } } catch (Exception) { throw; } finally { conn.Close(); } return recordList; }
/// <summary> /// Created by Justin Pennington 2015/02/25 /// Deletes a SupplierFeedbackRecord from the database /// </summary> /// <remarks> /// </remarks> /// <param name="oldFeedbackRecord">An object that contains all the values of the record pre-change</param> /// <param name="newFeedbackRecord">An object that contains all the values of the record post-change</param> /// <returns>rowsAffected (int)</returns> public static int UpdateSupplierFeedbackRecord(SupplierFeedbackRecord oldFeedbackRecord, SupplierFeedbackRecord newFeedbackRecord) { var conn = DatabaseConnection.GetDatabaseConnection(); var cmdText = "spUpdateSupplierFeedbackRecord"; 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("@RatingID", newFeedbackRecord.RatingID); cmd.Parameters.AddWithValue("@SupplierID", newFeedbackRecord.SupplierID); cmd.Parameters.AddWithValue("@EmployeeID", newFeedbackRecord.EmployeeID); cmd.Parameters.AddWithValue("@Rating", newFeedbackRecord.Rating); cmd.Parameters.AddWithValue("@Notes", newFeedbackRecord.RatingNotes); cmd.Parameters.AddWithValue("@originalRatingID", oldFeedbackRecord.RatingID); cmd.Parameters.AddWithValue("@originalSupplierID", oldFeedbackRecord.SupplierID); cmd.Parameters.AddWithValue("@originalEmployeeID", oldFeedbackRecord.EmployeeID); cmd.Parameters.AddWithValue("@originalRating", oldFeedbackRecord.Rating); cmd.Parameters.AddWithValue("@originalNotes", oldFeedbackRecord.RatingNotes); try { conn.Open(); rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new ApplicationException("Concurrency Violation"); } } catch (Exception) { throw; } finally { conn.Close(); } return rowsAffected; // needs to be rows affected }
/// <summary> /// Created by Justin Pennington 2015/02/25 /// Retrieves a SupplierFeedbackRecord from the database /// </summary> /// <remarks> /// </remarks> /// <param name="ratingID">A rating ID pulled from an object</param> /// <exception cref="SQLException">Insert Fails</exception> /// <returns>SupplierFeedbackRecord</returns> public static SupplierFeedbackRecord GetSupplierFeedbackRecord(String ratingID) { var theRecord = new SupplierFeedbackRecord(); // set up the database call var conn = DatabaseConnection.GetDatabaseConnection(); string cmdText = "spSelectSupplierFeedbackRecord"; var cmd = new SqlCommand(cmdText, conn); cmd.Parameters.AddWithValue("@RatingID", ratingID); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows == true) { theRecord.RatingID = reader.GetInt32(0); theRecord.SupplierID = reader.GetInt32(1); theRecord.EmployeeID = reader.GetInt32(2); theRecord.Rating = reader.GetInt32(3); theRecord.RatingNotes = reader.GetString(4); } else { var ax = new ApplicationException("Data not found!"); throw ax; } } catch (Exception) { throw; } finally { conn.Close(); } return theRecord; }