예제 #1
0
        public IActionResult Post([FromBody] NewOrderInputModel model)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest());
            }

            var res = repo.AddNewOrder(model);

            //if(res.Ord_No == null)
            //{
            //    return Ok(new { Message = "Не верный id пользователя", Status = false });
            //}
            return(Ok(res));
        }
예제 #2
0
        public NewOrderOutputModel AddNewOrder(NewOrderInputModel input)
        {
            var result = new NewOrderOutputModel();

            //dynamic count_id;

            using (IDbConnection db = new SqlConnection(Global.Connection))
            {
                var p = new DynamicParameters();
                p.Add("@Cust_ID", input.Cust_ID);
                p.Add("@Cur_Code", input.Cur_Code);
                p.Add("@Ord_ID", dbType: DbType.Int32, direction: ParameterDirection.Output, size: 10);
                p.Add("@Ord_No", dbType: DbType.String, direction: ParameterDirection.Output, size: 50);

                var res = db.Execute("sp_AddNewOrder", p, commandType: CommandType.StoredProcedure);

                result = new NewOrderOutputModel
                {
                    Ord_ID = p.Get <int?>("@Ord_ID"),
                };
            }
            return(result);
        }