public AdvertisementDocument MapAdvertisementDocument(IDataReader reader)
{
AdvertisementDocument model = new AdvertisementDocument();
int index = 0;
model.Id = reader.GetSafeInt32(index++);
model.EventId = reader.GetSafeInt32(index++);
model.Name = reader.GetSafeString(index++);
model.DocumentUrl = reader.GetSafeUri(index++);
model.DateCreated = reader.GetSafeDateTime(index++);
model.CreatedBy = reader.GetSafeInt32(index++);
return(model);
}
public AdvertisementDocument Get(int adId)
{
AdvertisementDocument model = null;
_dataProvider.ExecuteCmd(
"dbo.AdvertisementDocuments_GetById",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", adId);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
model = MapAdvertisementDocument(reader);
}
);
return(model);
}
public ActionResult <ItemResponse <AdvertisementDocument> > Get(int adId)
{
try
{
AdvertisementDocument model = _advertisementDocumentService.Get(adId);
if (model == null)
{
return(NotFound404(new ErrorResponse("Record not found")));
}
else
{
ItemResponse <AdvertisementDocument> response = new ItemResponse <AdvertisementDocument>();
response.Item = model;
return(Ok200(response));
}
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
return(StatusCode(500, new ErrorResponse(ex.Message)));
}
}
public List <AdvertisementDocument> GetByCreatedBy(int createdBy)
{
List <AdvertisementDocument> list = null;
_dataProvider.ExecuteCmd(
"dbo.AdvertisementDocuments_GetByCreatedBy",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@CreatedBy", createdBy);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
AdvertisementDocument model = MapAdvertisementDocument(reader);
if (list == null)
{
list = new List <AdvertisementDocument>();
}
list.Add(model);
}
);
return(list);
}
