示例#1
0
 private void MapCommonParameters(InvoiceAddRequest model, SqlParameterCollection paramCollection)
 {
     paramCollection.AddWithValue("@ProjectsId", model.ProjectsId);
     paramCollection.AddWithValue("@InvoiceDate", model.InvoiceDate);
     paramCollection.AddWithValue("@Description1", model.Description1);
     paramCollection.AddWithValue("@Description2", model.Description2);
     paramCollection.AddWithValue("LineTotal1", model.LineTotal1);
     paramCollection.AddWithValue("LineTotal2", model.LineTotal2);
     paramCollection.AddWithValue("@TimeCardTotals", model.TimeCardTotals);
     paramCollection.AddWithValue("@StatusId", model.StatusId);
 }
示例#2
0
        public HttpResponseMessage Insert(InvoiceAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
            }
            ItemResponse <int> response = new ItemResponse <int>();

            response.Item = _invoice.Insert(model);
            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }
示例#3
0
        public int Insert(InvoiceAddRequest model)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Invoice_Insert",
                                         inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                MapCommonParameters(model, paramCollection);

                SqlParameter outputParam = new SqlParameter("@Id", SqlDbType.Int);
                outputParam.Direction    = ParameterDirection.Output;

                paramCollection.Add(outputParam);
            }, returnParameters : delegate(SqlParameterCollection param)
            {
                Int32.TryParse(param["@Id"].Value.ToString(), out id);
            }
                                         );
            return(id);
        }