public List <IncidentDomain> SelectAll()
{
var returnVal = new List <IncidentDomain>();
_dataProvider.ExecuteCmd(
"incidents_select_all",
inputParamMapper : null,
singleRecordMapper : delegate(IDataReader reader, short set)
{
var model = new IncidentDomain();
int idx = 0;
model.Id = reader.GetSafeInt32(idx++);
model.OffenseType = reader.GetSafeString(idx++);
model.Incident = reader.GetSafeString(idx++);
model.IncidentDate = reader.GetSafeDateTime(idx++);
model.IncidentTime = reader.GetSafeString(idx++);
model.Location = reader.GetSafeString(idx++);
model.Upvotes = reader.GetSafeInt32(idx++);
model.Downvotes = reader.GetSafeInt32(idx++);
model.AdditionalDescription = reader.GetSafeString(idx++);
model.CreatedDate = reader.GetSafeDateTime(idx++);
model.ModifiedDate = reader.GetSafeDateTime(idx++);
model.Images = _fileStorageService.SelectByIncidentId(model.Id);
returnVal.Add(model);
}
);
return(returnVal);
}
public IncidentDomain SelectById(int id)
{
var returnVal = new IncidentDomain();
_dataProvider.ExecuteCmd(
"incidents_select_by_id",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
int idx = 0;
returnVal.Id = reader.GetSafeInt32(idx++);
returnVal.OffenseType = reader.GetSafeString(idx++);
returnVal.Incident = reader.GetSafeString(idx++);
returnVal.IncidentDate = reader.GetSafeDateTime(idx++);
returnVal.IncidentTime = reader.GetSafeString(idx++);
returnVal.Location = reader.GetSafeString(idx++);
returnVal.Upvotes = reader.GetSafeInt32(idx++);
returnVal.Downvotes = reader.GetSafeInt32(idx++);
returnVal.AdditionalDescription = reader.GetSafeString(idx++);
returnVal.CreatedDate = reader.GetSafeDateTime(idx++);
returnVal.ModifiedDate = reader.GetSafeDateTime(idx++);
}
);
return(returnVal);
}
public ActionResult EditData(IncidentDomain.Entities.Incident incident)
{
incidentService.UpdateIncident(incident);
return RedirectToAction("Index");
}
