/// <summary> /// Inserts a person grant points intop the database /// </summary> /// <param name="personGrantPoints"></param> /// <returns></returns> public int InsertPersonGrantPoints(PersonGrantPoints personGrantPoints) { int personGrantPointsID = 0; var conn = DBConnection.GetConnection(); var cmd = new SqlCommand("sp_insert_person_grant_points", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PersonID", personGrantPoints.PersonID); cmd.Parameters.AddWithValue("@ElectionID", personGrantPoints.Points); try { conn.Open(); personGrantPointsID = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(personGrantPointsID); }
/// <summary> /// updates person grant points /// </summary> /// <param name="oldPersonGrantPoints"></param> /// <param name="newPersonGrantPoints"></param> /// <returns></returns> public int UpdatePersonGrantPoints(PersonGrantPoints oldPersonGrantPoints, PersonGrantPoints newPersonGrantPoints) { int rows = 0; var conn = DBConnection.GetConnection(); var cmd = new SqlCommand("sp_update_person_grant_points", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PersonGrantPointsID", oldPersonGrantPoints.PersonGrantPointsID); cmd.Parameters.AddWithValue("@OldPersonID", oldPersonGrantPoints.PersonID); cmd.Parameters.AddWithValue("@OldPoints", oldPersonGrantPoints.Points); cmd.Parameters.AddWithValue("@NewPersonID", newPersonGrantPoints.PersonID); cmd.Parameters.AddWithValue("@NewPoints", newPersonGrantPoints.Points); try { conn.Open(); rows = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(rows); }
/// <summary> /// Edits a person grant points /// </summary> /// <param name="oldPersonGrantPoints"></param> /// <param name="newPersonGrantPoints"></param> /// <returns></returns> public bool EditPersonGrantPoints(PersonGrantPoints oldPersonGrantPoints, PersonGrantPoints newPersonGrantPoints) { bool result; try { result = 1 == _personGrantPointsAccessor.UpdatePersonGrantPoints(oldPersonGrantPoints, newPersonGrantPoints); } catch (Exception ex) { throw new ApplicationException("Person Grant Points not Edited", ex); } return(result); }
/// <summary> /// adds a persons grant points /// </summary> /// <param name="personGrantPoints"></param> /// <returns></returns> public int AddPersonGrantPoints(PersonGrantPoints personGrantPoints) { int result; try { result = _personGrantPointsAccessor.InsertPersonGrantPoints(personGrantPoints); } catch (Exception ex) { throw new ApplicationException("Person Grant Points not Added", ex); } return(result); }