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