public int Insert(string name, string lastName, string mail, int cardNumber, int phone, string dateIn, string dateOut, int idRoom, string subscription) { Debug.WriteLine("abc" + subscription + "1234"); Client client = new Client(0, name, lastName, mail, cardNumber, phone, 0); int clientId = 0; RoomContext rc = new RoomContext(); int roomAvaible = rc.verifyRoomAvailable(conn, dateIn, dateOut, idRoom); int msgs = 0; ClientContext cc = new ClientContext(); int clientExists = cc.returnClientId(conn, client.email); if (clientExists == -1) { clientId = cc.insertClient(conn, client); } else { clientId = clientExists; } ReservationContext rec = new ReservationContext(); //código int retorno = rec.isAvailable(conn, dateIn, dateOut, idRoom); if (retorno == 0) { return(15); } else { string result = rec.insertReservation(conn, dateIn, dateOut, clientId, idRoom, mail, subscription); if (result == "n") { return(-7); //no reservada } else { return(-11); //reservada } } //return msgs; }