public ActionResult <ItemResponse <CMSTemplate> > SelectById(int id)
{
int iCode = 201;
BaseResponse response;
try
{
CMSTemplate cmsTemplate = _cmsTemplateService.SelectById(id);
response = new ItemResponse <CMSTemplate>();
if (cmsTemplate == null)
{
iCode = 404;
response = new ErrorResponse("CMSTemplate not found");
}
else
{
response = new ItemResponse <CMSTemplate> {
Item = cmsTemplate
};
}
}
catch (Exception ex)
{
iCode = 500;
base.Logger.LogError(ex.ToString());
response = new ErrorResponse($"Generic Error: ${ ex.Message } ");
}
return(StatusCode(iCode, response));
}
public HttpResponseMessage GetById(int id)
{
CMSTemplate template = cmsService.GetById(id);
ItemResponse <CMSTemplate> itemResponse = new ItemResponse <CMSTemplate>();
itemResponse.Item = template;
return(Request.CreateResponse(HttpStatusCode.OK, itemResponse));
}
private static void NewCmsTemplateMapper(IDataReader reader, out CMSTemplate cmsTemplate, out int index)
{
cmsTemplate = new CMSTemplate();
index = 0;
cmsTemplate.Id = reader.GetSafeInt32(index++);
cmsTemplate.Name = reader.GetSafeString(index++);
cmsTemplate.Description = reader.GetSafeString(index++);
cmsTemplate.PrimaryImage = reader.GetSafeString(index++);
cmsTemplate.CreatedBy = reader.GetSafeInt32(index++);
cmsTemplate.DateCreated = reader.GetSafeDateTime(index++);
cmsTemplate.DateModified = reader.GetSafeDateTime(index++);
}
public List <CMSTemplate> GetAll()
{
List <CMSTemplate> results = new List <CMSTemplate>();
dataProvider.ExecuteCmd(
"CMSTemplates_GetAll",
inputParamMapper: null,
singleRecordMapper: (reader, resultSetNumber) =>
{
CMSTemplate template = new CMSTemplate();
template.Id = (int)reader["Id"];
template.Name = (string)reader["Name"];
template.TemplateHtml = (string)reader["TemplateHtml"];
results.Add(template);
});
return(results);
}
public CMSTemplate GetById(int id)
{
CMSTemplate template = null;
dataProvider.ExecuteCmd(
"CMSTemplates_GetById",
inputParamMapper: (parameters) =>
{
parameters.AddWithValue("@Id", id);
},
singleRecordMapper: (reader, resultSetNumber) =>
{
template = new CMSTemplate();
template.Name = (string)reader["Name"];
template.TemplateHtml = (string)reader["TemplateHtml"];
});
return(template);
}
public CMSTemplate SelectById(int id)
{
string procName = "[dbo].[CMSTemplate_SelectById]";
CMSTemplate cmsTemplate = null;
_data.ExecuteCmd(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
col.AddWithValue("@Id", id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
CMSTemplate cmsTemplate;
int index;
NewCmsTemplateMapper(reader, out cmsTemplate, out index);
});
return(cmsTemplate);
}
