public ResponseDTO CrearMesa(CrearMesaDTO mesaDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); var responseDTO = new ResponseDTO(); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_MESA"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(mesaDTO.nombre); inParam.Add(mesaDTO.cantidadPersonas.ToString()); inParam.Add(mesaDTO.estadoMesa.ToString()); inParam.Add(mesaDTO.categoriaMesa.ToString()); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }
public ResponseDTO CreateReserve(CreateReserveDTO createReserveDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_RESERVA"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(createReserveDTO.isTotem); inParam.Add(createReserveDTO.cantPerson.ToString()); inParam.Add(createReserveDTO.reserveDate); inParam.Add(createReserveDTO.usuarioEmail); inParam.Add(createReserveDTO.usuarioFono.ToString()); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }
public ResponseDTO flow(int numero) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); var responseDTO = new ResponseDTO(); string packageName = "PKG_TEST"; string procedureName = "TEST1"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(numero.ToString()); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = "NoOk"; } return(response); }
public ResponseDTO CrearPedido(IngresarPedidoDTO pedidoDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_PEDIDO"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); int id = 0; foreach (var producto in pedidoDTO.listaProducto) { inParam = new List <string>(); outParam = new List <string>(); result = new List <string>(); inParam.Add(id.ToString()); inParam.Add(pedidoDTO.usuarioId.ToString()); inParam.Add(producto.productoId.ToString()); inParam.Add(producto.cantidadProducto.ToString()); inParam.Add(pedidoDTO.mesaId.ToString()); inParam.Add(producto.observacion); outParam.Add("o_result"); outParam.Add("o_id"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; id = Int32.Parse(result[1].ToString()); } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } } return(response); }
public ResponseDTO createUser(CreateUserDTO createUserDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); var responseDTO = new ResponseDTO(); string packageName = "pkg_iteracion_1"; string procedureName = "CREATE_USER"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(createUserDTO.rut); inParam.Add(createUserDTO.name); inParam.Add(createUserDTO.lastName); inParam.Add(createUserDTO.motherName); inParam.Add(createUserDTO.birthdate); inParam.Add(createUserDTO.sexId.ToString()); inParam.Add(createUserDTO.email); inParam.Add(createUserDTO.password); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }
public ResponseDTO CrearInsumo(CrearInsumoDTO insumoDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); var responseDTO = new ResponseDTO(); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_INSUMO"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(insumoDTO.nombre); inParam.Add(insumoDTO.marca.ToString()); inParam.Add(insumoDTO.categoriaInsumo.ToString()); inParam.Add(insumoDTO.isActivo.ToString()); inParam.Add(insumoDTO.precio.ToString()); inParam.Add(insumoDTO.unidadMedida.ToString()); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }
public ResponseProductoDTO CrearProducto(ProductoDTO productoDTO) { ResponseProductoDTO response = new ResponseProductoDTO(); _IResultlSetHelper.setDataSource(conectionString); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_PRODUCTO"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(productoDTO.nombre); inParam.Add(productoDTO.precio.ToString()); inParam.Add(productoDTO.descripcion); inParam.Add(productoDTO.categoriaId.ToString()); outParam.Add("o_result"); outParam.Add("o_id"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; response.productoId = int.Parse(result[1].ToString()); } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }
public ResponseDTO CrearReceta(IngresarRecetaDTO recetaDTO) { ResponseDTO response = new ResponseDTO(); _IResultlSetHelper.setDataSource(conectionString); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_RECETA"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); foreach (var insumo in recetaDTO.listaInsumo) { inParam = new List <string>(); outParam = new List <string>(); result = new List <string>(); inParam.Add(recetaDTO.productoId.ToString()); inParam.Add(insumo.cantidad.ToString()); inParam.Add(insumo.unidadMedidaId.ToString()); inParam.Add(insumo.insumoId.ToString()); outParam.Add("o_result"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } } return(response); }
public InsertarTrabajadorOutDTO InsertarTrabajador(InsertarTrabajadorInDTO trabajadorDTO) { InsertarTrabajadorOutDTO response = new InsertarTrabajadorOutDTO(); _IResultlSetHelper.setDataSource(conectionString); string packageName = "pkg_iteracion_2"; string procedureName = "INSERTAR_TRABAJADOR"; List <string> inParam = new List <string>(); List <string> outParam = new List <string>(); List <string> result = new List <string>(); inParam.Add(trabajadorDTO.rut.ToString()); inParam.Add(trabajadorDTO.nombre); inParam.Add(trabajadorDTO.apellidoPat); inParam.Add(trabajadorDTO.apellidoMat); inParam.Add(trabajadorDTO.fechaNacimiento); inParam.Add(trabajadorDTO.sexoId.ToString()); inParam.Add(trabajadorDTO.perfilId.ToString()); outParam.Add("o_result"); outParam.Add("o_usuario"); outParam.Add("o_password"); result = _IResultlSetHelper.executePackage(packageName, procedureName, inParam, outParam); if (result[0].ToString().Equals("OK")) { response.code = 0; response.message = "OK"; response.correoUsuario = result[1].ToString(); response.password = result[2].ToString(); } else { response.code = 999; response.message = String.Concat("NoOk - ", result[0].ToString()); } return(response); }