public FileStorageDomain SelectByIdDelete(int Id)
{
FileStorageDomain rawData = new FileStorageDomain();
_dataProvider.ExecuteCmd(
"file_storage_select_by_id",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", Id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
int idx = 0;
rawData.Id = reader.GetSafeInt32(idx++);
rawData.UserFileName = reader.GetSafeString(idx++);
rawData.BasePath = reader.GetSafeString(idx++);
rawData.SystemFileName = reader.GetSafeString(idx++);
rawData.IncidentId = reader.GetSafeInt32(idx++);
rawData.CreatedDate = reader.GetSafeDateTime(idx++);
rawData.ModifiedDate = reader.GetSafeDateTime(idx++);
rawData.ModifiedBy = reader.GetSafeString(idx++);
}
);
return(rawData);
}
public List <FileStorageViewModel> SelectByIncidentId(int incidentId)
{
List <FileStorageDomain> rawData = new List <FileStorageDomain>();
_dataProvider.ExecuteCmd(
"file_storage_select_by_incident_id",
inputParamMapper : delegate(SqlParameterCollection paramCol) {
paramCol.AddWithValue("@IncidentId", incidentId);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
FileStorageDomain model = new FileStorageDomain();
int idx = 0;
model.Id = reader.GetSafeInt32(idx++);
model.UserFileName = reader.GetSafeString(idx++);
model.BasePath = reader.GetSafeString(idx++);
model.SystemFileName = reader.GetSafeString(idx++);
model.IncidentId = reader.GetSafeInt32(idx++);
model.CreatedDate = reader.GetSafeDateTime(idx++);
model.ModifiedDate = reader.GetSafeDateTime(idx++);
model.ModifiedBy = reader.GetSafeString(idx++);
rawData.Add(model);
}
);
List <FileStorageViewModel> viewModelResp = new List <FileStorageViewModel>();
for (int i = 0; i < rawData.Count; i++)
{
viewModelResp.Add(new FileStorageViewModel
{
Id = rawData[i].Id,
UserFileName = rawData[i].UserFileName,
Url = "https://sabio-training.s3.us-west-2.amazonaws.com/" + rawData[i].BasePath + rawData[i].SystemFileName,
IncidentId = rawData[i].IncidentId,
ModifiedDate = rawData[i].ModifiedDate,
ModifiedBy = rawData[i].ModifiedBy
});
}
;
return(viewModelResp);
}
public FileStorageViewModel SelectById(int Id)
{
FileStorageDomain rawData = new FileStorageDomain();
_dataProvider.ExecuteCmd(
"file_storage_select_by_id",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", Id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
int idx = 0;
rawData.Id = reader.GetSafeInt32(idx++);
rawData.UserFileName = reader.GetSafeString(idx++);
rawData.BasePath = reader.GetSafeString(idx++);
rawData.SystemFileName = reader.GetSafeString(idx++);
rawData.IncidentId = reader.GetSafeInt32(idx++);
rawData.CreatedDate = reader.GetSafeDateTime(idx++);
rawData.ModifiedDate = reader.GetSafeDateTime(idx++);
rawData.ModifiedBy = reader.GetSafeString(idx++);
}
);
FileStorageViewModel viewModelResp = new FileStorageViewModel
{
Id = rawData.Id,
UserFileName = rawData.UserFileName,
Url = "https://sabio-training.s3.us-west-2.amazonaws.com/" + rawData.BasePath + rawData.SystemFileName,
IncidentId = rawData.IncidentId,
ModifiedDate = rawData.ModifiedDate,
ModifiedBy = rawData.ModifiedBy
};
return(viewModelResp);
}
