public int setCreateOrderHistory(OrderHistoryTO objOrderHistory, ref int codError, ref string msjError) { List <OrderHistoryTO> objList = new List <OrderHistoryTO>(); try { using (SqlConnection sql = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand("createOrderHistory", sql)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@idOrder", SqlDbType.Int).Value = objOrderHistory.IdOrder; cmd.Parameters.Add("@idStatus", SqlDbType.Int).Value = objOrderHistory.IdStatus; sql.Open(); var ds = new DataSet(); var da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds.Tables.Count == 1) { List <ResultTO> error = ds.Tables[0].AsEnumerable() .Select(dataRow => new ResultTO { Result = dataRow.Field <int>("result"), Msg = dataRow.Field <string>("msg") }).ToList(); codError = 1; msjError = error.FirstOrDefault().Msg; return(0); } List <ResultTO> results = ds.Tables[1].AsEnumerable() .Select(dataRow => new ResultTO { Result = dataRow.Field <int>("result"), Msg = dataRow.Field <string>("msg") }).ToList(); objList = ds.Tables[0].AsEnumerable() .Select(dataRow => new OrderHistoryTO { IdHistory = dataRow.Field <int>("idHistory") }).ToList(); } } return(objList.FirstOrDefault().IdHistory); } catch (Exception e) { codError = 0; msjError = e.Message; return(0); } }
public IHttpActionResult setCreateOrderHistory(OrderHistoryTO ordr) { int codError = 1; string msjError = ""; OrderServices objServicio = new OrderServices(); var result = objServicio.setCreateOrderHistory(ordr, ref codError, ref msjError); if (codError == 1) { return(Ok(result)); } return(BadRequest(msjError)); }