public int Create(EmergencyReportsDto emergencyreport)
{
using (var db = GetConnection())
{
db.Open();
var emergencyReportId = db.QuerySingle <int>(@"INSERT INTO [dbo].[EmergencyReport]
([Date]
,[ManagerId]
,[Caller]
,[CallerPhoneNumber]
,[Address]
,[IncidentDescription]
,[ActionTaken]
,[PropertyId]
,[OnCallManagerName])
VALUES
(@Date
,@ManagerId
,@Caller
,@CallerPhoneNumber
,@Address
,@IncidentDescription
,@ActionTaken
,@PropertyId
,@OnCallManagerName);
SELECT CAST(SCOPE_IDENTITY() as int)", emergencyreport);
return(emergencyReportId);
}
}
public HttpResponseMessage EditEmergencyReport(int Id, EmergencyReportsDto emergencyreport)
{
var repository = new EmergencyReportsRepository();
var result = repository.Edit(Id, emergencyreport);
if (result)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Report could not be updated"));
}
public bool Edit(int id, EmergencyReportsDto emergencyreport)
{
emergencyreport.EmergencyReportId = id;
using (var db = GetConnection())
{
db.Open();
var edited = db.Execute(@"Update [dbo].[EmergencyReport]
SET [Date] = @Date
,[ManagerId] = @ManagerId
,[Caller] = @Caller
,[CallerPhoneNumber] = @CallerPhoneNumber
,[Address] = @Address
,[IncidentDescription] = @IncidentDescription
,[ActionTaken] = @ActionTaken
,[PropertyId] = @PropertyId
WHERE [EmergencyReportId] = @Id", emergencyreport);
return(edited == 1);
}
}
public HttpResponseMessage AddEmergencyReport(EmergencyReportsDto newEmergencyReport)
{
var repository = new EmergencyReportsRepository();
var id = repository.Create(newEmergencyReport);
var emergencyReportToSend = repository.GetEmergencyReportForEmail(id);
var bodyOfEmail =
$@"Below is an emergency report generated by the on call manager:<br/>
Date: {emergencyReportToSend.Date} <br/>
Manager Name: {emergencyReportToSend.ManagerName} <br/>
Caller: {emergencyReportToSend.Caller}<br/>
Caller Phone Number: {emergencyReportToSend.CallerPhoneNumber}<br/>
Property Name: {emergencyReportToSend.PropertyName}<br/>
Address: {emergencyReportToSend.Address}<br/>
Incident Description: {emergencyReportToSend.IncidentDescription}<br/>
Action Taken: {emergencyReportToSend.ActionTaken}<br/>
";
SendgridEmail.Execute(emergencyReportToSend.ManagerEmail, emergencyReportToSend.ManagerName, bodyOfEmail);
return(Request.CreateResponse(HttpStatusCode.Created));
}
