Exemple #1
0
        public HttpResponseMessage CreateWorkHistory([FromBody] WorkHistoryAddRequest payload)
        {
            try
            {
                ItemResponse <int> response = new ItemResponse <int>();

                response.Item = _workHistoryService.WorkHistoryInsert(payload);

                return(Request.CreateResponse(response));
            }
            catch (Exception ex)
            {
                ErrorLogService    svc   = new ErrorLogService();
                ErrorLogAddRequest error = new ErrorLogAddRequest();
                error.ErrorFunction = "Aic.Web.Controllers.Api.CreateWorkHistory";
                error.ErrorMessage  = ex.Message;
                error.UserId        = UserService.UserSelect().PersonId;
                svc.ErrorLogInsert(error);
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        } // CreateWorkHistory
        public int WorkHistoryInsert(WorkHistoryAddRequest payload)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.WorkHistory_Upsert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@PersonID", payload.PersonID);
                paramCollection.AddWithValue("@CompanyID", payload.CompanyID);
                paramCollection.AddWithValue("@Company", payload.Company);
                paramCollection.AddWithValue("@Title", payload.Title);
                paramCollection.AddWithValue("@Contract", payload.Contract);
                paramCollection.AddWithValue("@Datestarted", payload.DateStarted.ToShortDateString());     // .Date

                if (payload.DateEnded.HasValue)
                {
                    paramCollection.AddWithValue("@DateEnded", payload.DateEnded.Value.Date);
                }
                else
                {
                    // send dbnull
                    paramCollection.AddWithValue("@DateEnded", System.DBNull.Value);
                };

                paramCollection.AddWithValue("@Description", payload.Description);

                SqlParameter w = new SqlParameter("@ID", System.Data.SqlDbType.Int);
                w.Direction    = System.Data.ParameterDirection.Output;

                paramCollection.Add(w);
            }, returnParameters : delegate(SqlParameterCollection paramCollection)
            {
                int.TryParse(paramCollection["@ID"].Value.ToString(), out id);
            }
                                         );
            return(id);
        } // WorkHistoryInsert