// POST Create new page
public int Insert(CMSAddPageRequestModel model)
{
int id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.CMSPages_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@PageName", model.PageName);
paramCollection.AddWithValue("@PageDescription", model.PageDescription);
paramCollection.AddWithValue("@PageTemplate", model.PageTemplate);
paramCollection.AddWithValue("@PageIsActive", model.PageIsActive);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out id);
}
);
return(id);
}
public HttpResponseMessage CreateCMSPage(CMSAddPageRequestModel model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _pagesManagerService.Insert(model);
return(Request.CreateResponse(response));
}
public HttpResponseMessage UpdateCMSPages(CMSAddPageRequestModel model, int pagesId)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
SuccessResponse response = new SuccessResponse();
_pagesManagerService.Update(model, pagesId);
return(Request.CreateResponse(response));
}
// PUT Update Pages by Id
public void Update(CMSAddPageRequestModel model, int pagesId)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.CMSPages_Update"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", pagesId);
paramCollection.AddWithValue("@PageName", model.PageName);
paramCollection.AddWithValue("@PageDescription", model.PageDescription);
paramCollection.AddWithValue("@PageTemplate", model.PageTemplate);
paramCollection.AddWithValue("@PageIsActive", model.PageIsActive);
}, returnParameters : delegate(SqlParameterCollection param)
{
});
}
