public TOTransaction CancelarReserva(short emp_codi, int id, int motivo) { string txterror = ""; SAeReser.SAeReserDMR com = new SAeReser.SAeReserDMR(); object[] varEntr = { usuario, Encrypta.EncriptarClave(password), alias, "SAeReser", "", "", "", "", "", "N" }; object varSali; try { var txOptions = new System.Transactions.TransactionOptions(); txOptions.IsolationLevel = System.Transactions.IsolationLevel.Serializable; txOptions.Timeout = TimeSpan.MaxValue; if (com.ProgramLogin(varEntr, out varSali, out txterror) != 0) { throw new Exception("Error al ingresar a SEVEN-ERP, " + txterror); } object[] pdataIn = { emp_codi, id, motivo }; object pDatOut; if (com.Cancelar(pdataIn, out pDatOut, out txterror) != 0) { throw new Exception(txterror); } var pDataOut2 = (object[])pDatOut; return(new TOTransaction() { TxtError = txterror, Retorno = 0 }); } catch (Exception ex) { return(new TOTransaction() { Retorno = 1, TxtError = ex.Message }); } }
public TOTransaction CrearReserva(TOAeReser reserva) { string txterror = ""; try { SAeReser.SAeReserDMR com = new SAeReser.SAeReserDMR(); object[] varEntr = { usuario, Encrypta.EncriptarClave(password), alias, "SAeReser", "", "", "", "", "", "N" }; //object[] varEntr = { "seven12", "182193186192127126174178192192", "SevenDesarrollo", "SAeReser", "cerezo", "", "", "", "", "N" }; object varSali; if (com.ProgramLogin(varEntr, out varSali, out txterror) != 0) { throw new Exception("Error al ingresar a SEVEN-ERP, " + txterror); } object[] arrayReserva = new object[17]; arrayReserva[0] = reserva.Emp_codi; arrayReserva[1] = reserva.Res_fini.AddMinutes(1); arrayReserva[2] = reserva.Res_fina.AddMinutes(-1); arrayReserva[3] = reserva.Soc_cont; arrayReserva[4] = reserva.Mac_nume; arrayReserva[5] = reserva.Sbe_cont; arrayReserva[6] = reserva.Esp_cont; arrayReserva[7] = reserva.Res_numd; arrayReserva[8] = reserva.Ite_cont; arrayReserva[9] = reserva.Ter_codi; arrayReserva[10] = reserva.Res_tdoc; arrayReserva[11] = reserva.Res_dinv; arrayReserva[12] = reserva.Res_ninv; arrayReserva[13] = reserva.Res_inac; arrayReserva[15] = reserva.Productos[0].Pro_cont; arrayReserva[16] = reserva.Cla_cont; int i = reserva.Productos.Count; int y = 3; object[,] arrayProductos = new object[i, y]; for (int index = 0; index < i; index++) { arrayProductos[index, 0] = reserva.Productos[index].Pro_cont; arrayProductos[index, 1] = reserva.Productos[index].Dpr_valo; arrayProductos[index, 2] = reserva.Productos[index].Dpr_dura; } arrayReserva[14] = arrayProductos; object pDatOut; if (com.InsertarReserva(arrayReserva, out pDatOut, out txterror) == 1) { throw new Exception(txterror); } com = null; var pDataOut2 = (object[])pDatOut; var salida = new TSalida(); salida.Txterror = txterror; salida.retorno = (int)pDataOut2[1]; return(new TOTransaction() { Retorno = 0, TxtError = "", InvoiceId = salida.retorno }); } catch (Exception ex) { return(new TOTransaction() { Retorno = 1, TxtError = ex.Message, InvoiceId = 0 }); } }