public bool addNewVoyageData(VoyageData data)
        {
            bool result = false;
            //creating the connection to the database
            DbConnection  connection = new DbConnection();
            SqlConnection con        = connection.connectToDatabase();
            //create the instance to the SqlCommand Object
            SqlCommand cmd = new SqlCommand();

            //Command Object population to the connection and providing the Query string to the sql command object
            cmd.Connection  = con;
            cmd.CommandText = "INSERT INTO VoyageData(VoyageUserID,ImageData,VoyageContent,VoyageState,VoyageCity)" +
                              "VALUES(@userId,@image,@content,@state,@city)";
            //using the parameterized query
            cmd.Parameters.AddWithValue("@userId", data.UserId);
            cmd.Parameters.AddWithValue("@image", data.imageData);
            cmd.Parameters.AddWithValue("@content", data.VoyageContent);
            cmd.Parameters.AddWithValue("@state", data.VoyageState);
            cmd.Parameters.AddWithValue("@city", data.VoyageCity);

            //try block starting
            try
            {
                //open the connection to database
                con.Open();
                //returns the number of rows affected in the database
                int rows_affected = cmd.ExecuteNonQuery();
                //return the result of the operation
                result = true;
            }
            //starting of the catch block
            catch (Exception ex)
            {
                //just for checking for the developer purpose
                Console.WriteLine("Error Occured:" + ex.Message);
                //using the custom exception to return the error message at the client side
                Custom_Exception custom_Exception = new Custom_Exception();
                //Giving the appropriate values to the custom exception object
                custom_Exception.Title            = "Voyage_Guide Custom Exception Message";
                custom_Exception.ExceptionMessage = ex.Message;
                //throwthe fault exception
                throw new FaultException <Custom_Exception>(custom_Exception);
            }
            finally
            {
                //Closing the Database Connection
                con.Close();
            }
            return(result);
        }
        //Login Service Implmentation
        public AuthenticateReply authenticateUser(AuthenticateUser authUserData)
        {
            //Creating the instance of the Message Contract Typw which is required to send to the user
            AuthenticateReply authenticateReply = new AuthenticateReply();

            authenticateReply.VoyageisAuthenticated = false;
            //creating the instance of the Conenction
            DbConnection  connection = new DbConnection();
            SqlConnection con        = connection.connectToDatabase();
            //Creating the instance of the Sql Command Object
            SqlCommand cmd = new SqlCommand();

            cmd.Connection = con;
            //Parameterized query for the Database to authenticate the user
            cmd.CommandText = "Select Id,UserName,userPassword from VoyageUser where UserName=@username and userPassword=@password";
            cmd.Parameters.AddWithValue("@username", authUserData.VoyageUserName);
            cmd.Parameters.AddWithValue("@password", authUserData.VoyagePassword);
            try
            {
                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                if (rdr.Read())
                {
                    authenticateReply.VoyageisAuthenticated = true;
                    authenticateReply.VoyageUserId          = Int32.Parse(rdr["Id"].ToString());
                    rdr.Close();
                }
                //rdr.Close();
            }
            catch (Exception ex)
            {
                //creating the custom exception so that the client can be awared about the exception occured on the service side.
                Console.WriteLine("Error Message is:" + ex.Message);
                Custom_Exception exception = new Custom_Exception();
                exception.Title            = "Error Occured While authenticating the Voyage User";
                exception.ExceptionMessage = ex.Message;
                throw new FaultException <Custom_Exception>(exception);
            }
            finally
            {
                //finally closing the Database Connection
                con.Close();
            }
            return(authenticateReply);
        }