public void Update(FaqCategoryUpdateRequest model) { DataProvider.ExecuteNonQuery("dbo.FaqCategory_UpdateById" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", model.Id); paramCollection.AddWithValue("@DisplayName", model.DisplayName); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@ModifiedBy", model.ModifiedBy); }); }
public HttpResponseMessage Put(FaqCategoryUpdateRequest model) { try { _faqCategoryService.Update(model); return(Request.CreateResponse(HttpStatusCode.OK, new SuccessResponse())); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public void Update(FaqCategoryUpdateRequest model) //change out void to int { //int id = 0; Adapter.ExecuteQuery("dbo.FaqCategory_Update", new[] { SqlDbParameter.Instance.BuildParameter("@Title", model.Title, System.Data.SqlDbType.NVarChar, 200), SqlDbParameter.Instance.BuildParameter("@Description", model.Description, System.Data.SqlDbType.NVarChar, 4000), SqlDbParameter.Instance.BuildParameter("@Id", model.Id, System.Data.SqlDbType.Int) }); //get rid of the ); //, //(parameters => //{ // id = parameters.GetParamValue<int>("@Id");//an extention against the IDBparameters array //} //)); //return id; }