/// <summary>
/// Inserts the badge missing report.
/// </summary>
/// <param name="details">The details.</param>
/// <param name="staffID">The staff ID.</param>
public void InsertBadgeMissingReport(LostBadgeDetails details, int staffID)
{
var storedProcedure = new StoredProcedure()
{
StoredProcedureName = schema + ".[Badging.InsertBadgeMissingReport]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeID", ParameterType.DBInteger, details.BadgeID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@WhenReported", ParameterType.DBDateTime, details.ReportedDate));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@DateOfOccurrence", ParameterType.DBDateTime, details.DateOfOccurance));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeStatusCode", ParameterType.DBString, details.Type));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@CustomSeal", ParameterType.DBString, details.Type));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ReportedByName", ParameterType.DBString, details.ReportedBy));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ReportedByTitle", ParameterType.DBString, details.Title));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ReportedByPhoneNumber", ParameterType.DBString, details.Phone));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeMissingReportMethodID", ParameterType.DBInteger, details.HowReported));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@Notes", ParameterType.DBString, details.Details));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@StaffID", ParameterType.DBInteger, staffID));
storedProcedure.ExecuteNonQuery();
}
/// <summary>
/// Inserts the badge missing report.
/// </summary>
/// <param name="details">The details.</param>
/// <param name="staffID">The staff ID.</param>
public void InsertBadgeMissingReport(LostBadgeDetails details, int staffID)
{
this.badgeRepository.InsertBadgeMissingReport(details, staffID);
}