public IHttpActionResult setCreateOrderDetail(OrderDetailTO ordr)
{
int codError = 1;
string msjError = "";
OrderServices objServicio = new OrderServices();
var result = objServicio.setCreateOrderDetail(ordr, ref codError, ref msjError);
if (codError == 1)
{
return(Ok(result));
}
return(BadRequest(msjError));
}
public int setCreateOrderDetail(OrderDetailTO objOrderDetail, ref int codError, ref string msjError)
{
List <OrderDetailTO> objList = new List <OrderDetailTO>();
try
{
using (SqlConnection sql = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("createOrderDetail", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@idOrder", SqlDbType.Int).Value = objOrderDetail.IdOrder;
cmd.Parameters.Add("@idStatus", SqlDbType.Int).Value = objOrderDetail.IdStatus;
cmd.Parameters.Add("@idEdge", SqlDbType.Int).Value = objOrderDetail.IdEdge;
cmd.Parameters.Add("@idComposition", SqlDbType.Int).Value = objOrderDetail.IdComposition;
cmd.Parameters.Add("@idCheese", SqlDbType.Int).Value = objOrderDetail.IdCheese;
cmd.Parameters.Add("@quantity", SqlDbType.Int).Value = objOrderDetail.Quantity;
cmd.Parameters.Add("@price", SqlDbType.Int).Value = objOrderDetail.Price;
cmd.Parameters.Add("@commentary", SqlDbType.VarChar).Value = objOrderDetail.Commentary;
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 OrderDetailTO
{
IdOrderDetail = dataRow.Field <int>("idOrderDetail")
}).ToList();
}
}
return(objList.FirstOrDefault().IdOrderDetail);
}
catch (Exception e)
{
codError = 0;
msjError = e.Message;
return(0);
}
}
