/// <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);
}
