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