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