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;
}
