public void Insert(PageMetaTagsAddRequest model)
{
DataProvider.ExecuteNonQuery("dbo.PageMetaTags_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@OwnerTypeId", model.OwnerTypeId);
});
}
public HttpResponseMessage Insert(PageMetaTagsAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
try
{
//var u = HttpContext.Current.User.Identity.GetCurrentUser();
_pageMetaTagsService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, new SuccessResponse()));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void PageMetaTagsInsert(PageMetaTagsAddRequest payload) //int mtId,
{
// create a new datatable
DataTable newMT = new DataTable();
// create a new comlumns to match SQL
DataColumn ID = new DataColumn("ID", typeof(int));
DataColumn MetaTagID = new DataColumn("MetaTagID", typeof(int)); // SQL doesn't understand object types
DataColumn Value = new DataColumn("Value", typeof(string));
DataColumn OwnerId = new DataColumn("OwnerId", typeof(int));
DataColumn OwnerTypeId = new DataColumn("OwnerTypeId", typeof(int));
// add columns to data table
newMT.Columns.Add(ID);
newMT.Columns.Add(MetaTagID);
newMT.Columns.Add(Value);
newMT.Columns.Add(OwnerId);
newMT.Columns.Add(OwnerTypeId);
DataProvider.ExecuteNonQuery(GetConnection, "dbo.PageMetaTags_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
// have to hydrate table with info from List
foreach (PageMetaTags p in payload.MetaTags)
{
DataRow dr1 = newMT.NewRow();
//dr1[0] = ID;
dr1[1] = (int)p.MetaTagID;
dr1[2] = p.MetaTagValue;
dr1[3] = 15;
dr1[4] = payload.OwnerTypeId; //mtId;
newMT.Rows.Add(dr1);
}
paramCollection.AddWithValue("@OwnerTypeId", payload.OwnerTypeId);
paramCollection.AddWithValue("@MetaTagTableType", newMT);
} //, returnParameters: null
);
} // PageMetaTagsInsert
public HttpResponseMessage CreatePageMetaTag([FromUri] int id, [FromBody] Dictionary <string, string> payload)
{
try
{
List <PageMetaTags> pageMetaTagList = new List <PageMetaTags>();
foreach (var kv_pair in payload)
{
MtEnum metaTag;
bool success = Enum.TryParse <MtEnum>(kv_pair.Key, out metaTag);
if (success)
{
PageMetaTags pmt = new PageMetaTags();
pmt.MetaTagValue = kv_pair.Value;
pmt.MetaTagID = metaTag;
pageMetaTagList.Add(pmt);
}
}
// creating a new object to match requested parameter for the service
PageMetaTagsAddRequest request = new PageMetaTagsAddRequest(); // instantiating model
request.OwnerTypeId = id;
request.MetaTags = pageMetaTagList; // set MetaTags property of model to a variable
_metaTagsService.PageMetaTagsInsert(request); // pass model into web service
// confirming that everything went OK
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
ErrorLogService svc = new ErrorLogService();
ErrorLogAddRequest error = new ErrorLogAddRequest();
error.ErrorFunction = "Aic.Web.Controllers.Api.CreatePageMetaTag";
error.ErrorMessage = ex.Message;
error.UserId = UserService.UserSelect().PersonId;
svc.ErrorLogInsert(error);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
} // CreatePageMetaTag
